Thanks Sean.. here is the query I have written.

DECLARE @Tab1 table (ID Int , PS varchar(10),NPS1 varchar(10), NPS2 varchar(10))

INSERT INTO @Tab1

SELECT 1, 'A', 'B', 'C'

UNION ALL

SELECT...

Just Wanted to check if there is any better way to write the query without case statements.

@balasach82,

Yes, the proxy account exists on the server and its having sysadmin privileges on the server.

any thoughts on this...