[Solved] SQL server SELECT CASE large script [closed]

by


Try This ,

Create another table like this

    CREATE TABLE [dbo].[Table_1](
        [Col2] [nvarchar](50) NULL,
        [CaseVal] [nchar](10) NULL
    ) ON [PRIMARY]



    Insert all the Distinct data what you have. Then write a sql like below 



   SELECT b.Col1, b.Col2, a.CaseVal TargetAliasColumnName 
    FROM  Table_1 a inner join [dbo].[Table1] b on 
    a.col2=b.Col2

1

solved SQL server SELECT CASE large script [closed]