on 12-18-2014 9:15 AM
I get SQL query error if I get Year(Getdate()) inside the Case statement, but it ok when Getdate() in derived table.
(CASE WHEN @prompt('Enter This Year','N','Year Others',mono,constrained,persistent,{'9999'}) = '9999' then Getdate() else @prompt('Enter This Year','N','Year Others',mono,constrained,persistent,{'9999'}) END) ---- I receive no error.
(CASE WHEN @prompt('Enter This Year','N','Year Others',mono,constrained,persistent,{'9999'}) = '9999' then Year(Getdate()) else @prompt('Enter This Year','N','Year Others',mono,constrained,persistent,{'9999'}) END) ---- I received SQL Query error.
Trying to convert Year(Getdate()) to numeric because data type of @prompt is in 'N' but still I get SQL Query error.
Is the database SQL Server? If so, try this...
DATEPART(YEAR, GETDATE())
Noel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.