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
@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