[dba-SQLServer] SP works sometimes

Your problems lie in your mixing of single quotes (') and double quotes (").
You don't use double quotes (") in T-SQL statements.  Dates in SQL are
surrounded in single quotes (').  

I've also found it helpful to preface all strings with the N designator to
be sure they are interpreted properly.

Doris Manning