Hello Lynn Pettis... That worked. Seems very simple. Thanks a...

Hello Luis Cazares Sorry for replying to an older post...

Yeah Louis. I understood those parts correctly.

Thanks everyone.

Thanks Luis. That is very simple and it worked. 🙂

Thanks all for the reply. I got it.

Once again Thanks a lot.

Jeff- I understand your concern but we have data coming from third party so we have to massage data here.

The Dixie Flatline- You are right. I...

INSERT INTO #EXAMPLE(AZ,NY,PA)

SELECT AZ,NY,PA FROM

(SELECT code,value FROM #UnPivotExample

) AS cp

PIVOT

( MAX(code) for value IN ([AZ],[NY],[PA])

) AS up

When I try this way, it says,

Msg 8114, Level 16, State 1, Line 50

Error...

Thanks a lot guys. However I tried this approach

CREATE TABLE #UnPivotExample(code varchar(2), value int)

INSERT INTO #UnPivotExample (code,value)

SELECT code,value

FROM

(SELECT [AZ], [NY], [PA] FROM #Example

) AS cp

UNPIVOT

...

Thanks

Thanks guys.

Patindex is not supoorted in ssis i guess. So if i use this in ssis then it may be prob. but i think i understand the logic here and...

u r right Lowel. Thanks a lot again.

Anyway Thanks a lot. I hope this is flawless

SELECT

'exec sp_rename ''' + QUOTENAME( Table_Name) + '.' + QUOTENAME(COLUMN_NAME) +

''', ''' + QUOTENAME(LOWER(REPLACE(column_name, '''', ''''''))) + ''', ' +...

Thanks

I was using this to change all at once,

SELECT

'exec sp_rename ''' + QUOTENAME( Table_Name) + '.' + QUOTENAME(COLUMN_NAME) +

''', ''' + QUOTENAME(LOWER(COLUMN_NAME)) + ''', ' + '''COLUMN'';'

FROM

Information_Schema.[COLUMNS]

Now I...

Thanks a lot experts. I will definitely use all these advises and try one more time.

3 to 4 mins