SQL CASE Question
Posted
by docsql
on Stack Overflow
See other posts from Stack Overflow
or by docsql
Published on 2010-03-28T11:16:46Z
Indexed on
2010/03/28
11:23 UTC
Read the original article
Hit count: 266
Hiya,
I dont know if this can be done but i'd though i'd ask.
What I want to do is have a case statement query and if a 1 begin another action. if 0 dont do anything.
For Example
select CASE WHEN client.deathofdeath = yes THEN 1
do another select in here (which is another table)
Else 0 End AS DeathDate
From Client client
Can this be done?
© Stack Overflow or respective owner