|
| Iniciado por guest, 13,jul. 2018 14:12 - 1 respuesta |
| |
| | | |
|
| |
| Publicado el 13,julio 2018 - 14:12 |
Good day
How can you use a parameter inside a query in a CASE statement.
I.e. I want to pass a parameters {Period} = 2 as a field in the query and then se that in a case i.e. CASE WHEN Period = 1 then blah blah else blah blah END
So my query reads:
SELECT xyz, 1 as Period, CASE WHEN Period = 1 etc. etc. from tablename
Thanks in advance
Ericus Steyn |
| |
| |
| | | |
|
| | |
| |
| Publicado el 13,julio 2018 - 19:38 |
Maybe to try with
sSQL is string = "SELECT xyz, 1 as Period, CASE WHEN Period = %1 etc. etc. from tablename"
StringBuild(sSQL,1) |
| |
| |
| | | |
|
| | | | |
| | |
|