I have an SQL store procedure that has a following input parameters:
|SQL EXEC [dbo].[reportSP_ExportDataFile] @__surveyID = $(surveyID),@__userID = 1,@__langID = 1,|
I would really want to have it dinamic, but cannot set it up like
using the following settings:
because I cannot get $(StartDate) and $(EndDate) in the same (nvarchar) format.
Could you please help?
Thank you very much in advance!!!