[Resolved] Error in CASE statement

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)

[Resolved] Error in CASE statement

Author

Topic

snufse
Constraint Violating Yak Guru

469 Posts

Posted - 2011-04-19 : 07:49:48

Getting error in CASE statement.

update #TempTable 
       set    #TempTable.mode_transp_descr 
         case  
            when #TempTable.mode_transp = 'PL' then #TempTable.mode_transp_descr = 'Pipeline'
            when #TempTable.mode_transp = 'S'  then #TempTable.mode_transp_descr = 'Ship'
         else
              #TempTable.mode_transp_descr 
         end

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2011-04-19 : 07:51:57

A case statement returns a value

update #TempTable
set #TempTable.mode_transp_descr =
case
when #TempTable.mode_transp = 'PL' then 'Pipeline'
when #TempTable.mode_transp = 'S' then 'Ship'
else
#TempTable.mode_transp_descr
end

or better

update #TempTable
set #TempTable.mode_transp_descr =
case
when #TempTable.mode_transp = 'PL' then 'Pipeline'
when #TempTable.mode_transp = 'S' then 'Ship'
end
where #TempTable.mode_transp in ('PL','S')

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.

snufse
Constraint Violating Yak Guru

469 Posts

Posted - 2011-04-19 : 08:19:11

Great, both suggestions worked. Thank you.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources