question

Richhaver avatar image
Richhaver asked

using one parameter to filter what date to use

Stupid question. I'm setting up a Stored procedure where if @parameterA = '1' then Expiration_Date between @StartDate and @EndDate else Due_Date between @StartDate and @EndDate. Tried casing it out, but it gave me a funky error. I know it's simple, but I can't figure it out.

t-sqlsql-serverssms
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.