Facng Problem In CASE

Question

Post reply

Facng Problem In CASE

Shakti Singh Dulawat

SSC-Addicted

Points: 483
More actions
December 13, 2007 at 4:17 am

#177503

[font="Arial"]Hi all

I am facing some problem in the following please tell me that what is wrong.[/font]

DECLARE @TableName nvarchar(Max),@Abbreviation nvarchar(100)

SET @Abbreviation='HH'

select CASE @Abbreviation

WHEN 'HH' THEN SET @TableName='Hotel_History'

WHEN 'HA' THEN SET @TableName='Hotel_Accomodation'

WHEN 'HD' THEN SET @TableName='Hotel_Dining'

WHEN 'HB' THEN SET @TableName='Hotel_Banquet_Conference'

WHEN 'HF' THEN SET @TableName='Hotel_Facilities_Services'

WHEN 'HV' THEN SET @TableName='Hotel_Virtual_Tour'

WHEN 'HG' THEN SET @TableName='Hotel_Gallery'

ELSE SET @TableName='NotMatch'

END

PRINT @TableName

Thanks

Warm Regards,
Shakti Singh Dulawat
Before printing, think about the environment
Do the impossible, and go home early.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Jason Selburg SSC-Insane Points: 24641 More actions · Answer 1

Remove the SET= from the case as below ...



DECLARE @TableName nvarchar(Max),@Abbreviation nvarchar(100)

SET @Abbreviation='HH'

SELECT

    @TableName =

        CASE @Abbreviation

            WHEN 'HH' THEN 'Hotel_History'

            WHEN 'HA' THEN 'Hotel_Accomodation'

            WHEN 'HD' THEN 'Hotel_Dining'

            WHEN 'HB' THEN 'Hotel_Banquet_Conference'

            WHEN 'HF' THEN 'Hotel_Facilities_Services'

            WHEN 'HV' THEN 'Hotel_Virtual_Tour'

            WHEN 'HG' THEN 'Hotel_Gallery'

            ELSE 'NotMatch'

        END

PRINT @TableName

______________________________________________________________________

Personal Motto: Why push the envelope when you can just open it?

If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

Jason L. Selburg

Andras Belokosztolszki SSC-Insane Points: 21971 More actions · Answer 2

Use:



DECLARE @TableName nvarchar(Max),@Abbreviation nvarchar(100)

SET @Abbreviation='HH'

select @TableName = CASE @Abbreviation

WHEN 'HH' THEN  'Hotel_History'

WHEN 'HA' THEN  'Hotel_Accomodation'

WHEN 'HD' THEN  'Hotel_Dining'

WHEN 'HB' THEN  'Hotel_Banquet_Conference'

WHEN 'HF' THEN  'Hotel_Facilities_Services'

WHEN 'HV' THEN  'Hotel_Virtual_Tour'

WHEN 'HG' THEN  'Hotel_Gallery'

ELSE 'NotMatch'

END

PRINT @TableName

Regards,

Andras

Andras Belokosztolszki, MCPD, PhD
GoldenGate Software

Andras Belokosztolszki SSC-Insane Points: 21971 More actions · Answer 3

Andras Belokosztolszki

SSC-Insane

Points: 21971

December 13, 2007 at 4:48 am

#759765

Hmmm, Jason managed to post his response between me refreshing to see if someone answered, and pasting my answer in. Witchcraft? 🙂

Andras

Andras Belokosztolszki, MCPD, PhD
GoldenGate Software

Jason Selburg SSC-Insane Points: 24641 More actions · Answer 4

Nothing magical here, I'm just looking over your shoulder Andras. 😉

______________________________________________________________________

Personal Motto: Why push the envelope when you can just open it?

If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

Jason L. Selburg

Shakti Singh Dulawat SSC-Addicted Points: 483 More actions · Answer 5

Shakti Singh Dulawat

SSC-Addicted

Points: 483

December 13, 2007 at 6:44 am

#759801

Thanks you both

Warm Regards,
Shakti Singh Dulawat
Before printing, think about the environment
Do the impossible, and go home early.

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 6

Great minds think alike... and, frequently, at the same time. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Intro to Tally Tables and Functions