[JSON] 將傳回JSON日期格式化

Birthday傳回格式 : /Date(1418900173730)/
var parsedDate = new Date(parseInt(JData[i].Birthday.substr(6)));
                    var customBirthday = new Date(parsedDate);
                    customBirthday = customBirthday.getFullYear() + "/" + (customBirthday.getMonth() + 1) + "/" + customBirthday.getDate();

格式化後:2014/12/18

[SQL] IN 使用資料表值函示傳回table篩選條件

資料列表

1.建立function
CREATE FUNCTION GetWeekStrings (@roomListID int)
RETURNS TABLE
AS
RETURN (
         SELECT [Week] FROM RoomOpenSet WHERE RoomListID= 1
          )

2.找出資料Week欄位不等於 2,3,4
SELECT *, DATEPART(WEEKDAY, StartDate -1) as [Week] FROM RoomOpen WHERE RoomListID = 1 AND convert(varchar,DATEPART(WEEKDAY, StartDate -1)) not in
(
  Select * From GetWeekStrings(1)
)

結果為下表,過濾掉星期2,3,4 只撈出星期五的資料

[SQL]如何將多筆資料列的值組成同一欄位

原本的資料列表

但是我想將Week欄位組成 2,3,4 使用stuff

select stuff(Strings.MarkUp,1,1,'') as [Week]
from
(
select RoomListID,
(
SELECT ',' +cast([Week] AS NVARCHAR)
FROM RoomOpenSet  
WHERE RoomListID=ro2.RoomListID
for xml path('')
)MarkUp
from RoomOpenSet ro2
GROUP BY RoomListID
) as Strings
where RoomListID = 1