Thank you Keith for prompt reply. I have changed the @DB to NVARCHAR.

SP Executed succeessfully but when I executed by passing parameters it throws error.

Msg 207, Level 16, State 1, Line 19

Invalid column name 'ChannelName'.

Msg 207, Level 16, State 1, Line 20

Invalid column name 'ChannelID'.

Msg 207, Level 16, State 1, Line 6

Invalid column name 'ChannelName'.

Msg 207, Level 16, State 1, Line 7

Invalid column name 'ChannelID'.

Msg 207, Level 16, State 1, Line 19

Invalid column name 'ChannelName'.

Msg 207, Level 16, State 1, Line 20

Invalid column name 'ChannelID'.

Msg 207, Level 16, State 1, Line 6

Invalid column name 'ChannelName'.

Msg 207, Level 16, State 1, Line 7

Invalid column name 'ChannelID'.

But I have those fields in the base table as well as I declared those in the temp table also.