SQL Server 2000
In the stored proc I want to get all the studentId's and concatenate them like
Select studentID from StudentTable
lets say 1,2,3,4,5 are studentIDs retrieved using the above query
I want to assign it to a variable of string DataType contactenated by "-"
strStudentIds = "1-2-3-4-5"