sanjshah12
asked on
Return a series of rows into one array
I am trying to return a series of rows into one array but this is for dates, the following works for text but not dates:
Am I able to convert the date to string or keep these as dates in the single string?
Any help is appreciated.
Regards
Declare @Datelist AS Nvarchar(MAX)
SELECT @Datelist = COALESCE(@Datelist + ',', '') + [StartDate]
FROM tbl_QuizDetails where StartDate IS NOT NULL
SELECT @Datelist
Am I able to convert the date to string or keep these as dates in the single string?
Any help is appreciated.
Regards
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Guys
01/01/2019,01/02/2019,01/0
Open in new window
»bp