MS sql server 2005 case when in Select to change column name

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

MS sql server 2005 case when in Select to change column name

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2007-03-20 : 09:53:18

sharad writes "MS sql database table tmp contain following
fields

ModifiedON_A datetime
CreatedOn_A datetime
CreatedBy_A datetime

ModifiedON_B datetime
CreatedOn_B datetime
CreatedBy_B datetime

if the ModifiedON_A date is null then the CreatedOn_A date needs to be checked to see if it meets the timeframe. If CreatedOn_A date is used then the CreatedBy_A value should be used for the ModifiedBy field. If these are all NULL then you use the same process using the ModifiedON_B fields.

thanks"

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2007-03-20 : 10:06:43

But with what element they are required to be check..???

Chirag

http://chirikworld.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources