SQL: Combining String of all as a single string

DECLARE @AssignedRoll varchar(max)
SET @AssignedRoll=”
SELECT @AssignedRoll=@AssignedRoll+RollList FROM T_ExamAttendance_Room_Scheduling WHERE TermId=’CSE2012SEP_2K11Y1T2′ AND CourseId=’CSE2006MAYCSE1201′
SELECT @AssignedRoll=RIGHT(@AssignedRoll,len(@AssignedRoll)-1)
SELECT @AssignedRoll as AssignedRoll

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s