hello ,,, i am totally new to sqlsever and i am suffering from z same problem
incorrect syntax near #
i removed it and enclosed may between date var between single quotes but still not working
any help please
it drives me crazy for more than a month now