Hi all
I am facing some problem in the following please tell me that what is wrong.

Code:
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