question

meddojeddo-3611 avatar image
0 Votes"
meddojeddo-3611 asked Joyzhao-MSFT answered

How to specify today's date for a parameter when running a proc

I am trying to a DDS where the subscription is triggered and send a a report in an email when there is data for the current date. But I am not sure how to specify the current date when specifying the script to execute the stored procedure in the DDS setup.

sql-server-transact-sqlsql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered

Hi @meddojeddo-3611 ,
What is your date? I am sorry I don't understand what you mean。
Regards,
Joy


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.