Wednesday, 22 January 2014

Get the records separated by comma in sqlserver

CREATE Procedure sp_GetMobileNo_CommaSeparated

@Fcode varchar(20) ,

@FromDate varchar(20),

@ToDate varchar(20)

as

begin

DECLARE @List VARCHAR(max)

SELECT @List = ISNULL(@List + ',', '') + CAST(F_MOBILE AS VARCHAR)

FROM XStudentMasterCopy

WHERE FranchiseCode = @Fcode

and ADMNDATE between convert(varchar(15),@FromDate,103) and convert(varchar(15),@ToDate,103)

SELECT @List



end

No comments:

Post a Comment