and dbo.meetings.RoomID in (select val from dbo.inlist(@tcDeptList)) ORDER BY dbo.coRooms.deptdisplayorder,dbo.coRooms.RoomName, dbo.meetings.begintimeSample List Values
110,110,89,10This works and gets me the right records. Now I need to change the order by to match the order of the room ID's in the list. Does anyone have a suggestion how I might be able to do that. This code is in a stored procedure currently.