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: 267

Filed under:
|

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

Related posts about tsql

Related posts about sql