Need a Column Name defined in statement 3

[VonFranzken]

How can I give a name to the column where this statement displays its results?

SELECT *,
case srctable_cah
when 'dbo.activity' then 'Activities at 689'
when 'dbo.goal' then 'Goals'
when 'dbo.technician' then 'Technicians Report'
when 'dbo.marketintell' then 'Market Intelligence'
when 'dbo.activityout' then 'Activities Outside 689'
when 'dbo.targetartist' then 'Target Artist Update'
else '...'
end
FROM admin.src_cache_cah

 

[DrSql]

SELECT
column= case srctable_cah
when 'dbo.activity' then 'Activities at 689'
when 'dbo.goal' then 'Goals'
when 'dbo.technician' then 'Technicians Report'
when 'dbo.marketintell' then 'Market Intelligence'
when 'dbo.activityout' then 'Activities Outside 689'
when 'dbo.targetartist' then 'Target Artist Update'
else '...'
end
FROM admin.src_cache_cah

Dr. Sql
goEdeveloper@yahoo.com
Good Luck.

 

[MDXer]

Try THis

SELECT *,
[COLOR=red]MYCOLUMN = [/color]case srctable_cah
       when 'dbo.activity' then  'Activities at 689'
       when 'dbo.goal' then 'Goals'
       when 'dbo.technician' then 'Technicians Report'
       when 'dbo.marketintell' then 'Market Intelligence'
       when 'dbo.activityout' then 'Activities Outside 689'
       when 'dbo.targetartist' then 'Target Artist Update'
       else '...'
       end
FROM admin.src_cache_cah

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[amrita418]

Just to show you another way to do the same:

SELECT *,
       case srctable_cah
       when 'dbo.activity' then  'Activities at 689'
       when 'dbo.goal' then 'Goals'
       when 'dbo.technician' then 'Technicians Report'
       when 'dbo.marketintell' then 'Market Intelligence'
       when 'dbo.activityout' then 'Activities Outside 689'
       when 'dbo.targetartist' then 'Target Artist Update'
       else '...'
       end [COLOR=red] 'MYCOLUMN' -- you can get rid of the quotes too [/color]
FROM admin.src_cache_cah

Regards,
AA