How can I Execute a SQL statement with one of the paramaters to a variable date?

Question

What I want to do is to let the system date dictate what my reporting year should be in this query:

EXEC [reporting].[Testing]
        @CompanyNames = NULL,
        @ReportYear = 2020

to something like this:

EXEC [reporting].[Testing]
        @CompanyNames = NULL,
        @ReportYear = YEAR(SYSDATE())

Any thoughts?

Thank you

What are you trying to do here? You define variables but never use them. — Tim Biegeleisen, Feb 04 '20 at 06:04

score 0 · Answer 1 · answered Feb 04 '20 at 06:08

0

you can try this . I hope your reporting is database

EXEC [reporting].[Testing]
@CompanyNames = NULL,
@ReportYear = cast(getdate() as date(30))

answered Feb 04 '20 at 06:08

1 Answers1