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.
| Author |
Topic |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2011-02-16 : 09:52:48
|
| Hi ALl,I am very beginner for T-SQL programming.From the table we have to filter or process the records as below.Based on status column i need to have diffeent operation for each row for different each status Lets say:there are possibalities of only 10 values in that columnif value is 01--then i need to send an email for that personif value is 02-- then i need to update some record in DBif value is 03--then i have to send an email to created person with different subject line and bodyand so on upto value 10.What would be the best option to do that for row by row operation to handle this,Kindly suggest with some algorithm.Thanks,GangadharThanks,Gangadhara MSSQL Developer and DBA |
|
|
RobertKaucher
Posting Yak Master
169 Posts |
Posted - 2011-02-16 : 12:35:15
|
| http://msdn.microsoft.com/en-us/library/ms181765.aspxShould do the trick.===http://www.ElementalSQL.com/ |
 |
|
|
|
|
|
Help required for T-SQL