ChrisM@Work (3/6/2013)
You have single quoted a variable, making it a string-type constant: '@Date_Last_Payment'
Hi Chris,
I have temporarily changed it to a varchar - in the input parameters bit however I still get the following error
Server: Msg 170, Level 15, State 1, Procedure STP_Agent_upload, Line 92
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 92: Incorrect syntax near ' Reason: there is no transaction that matches the policy number, agent and transaction date specified.'.
Thanks