SELECT t.* FROM Calender AS t CROSS JOIN (VALUES (1), (2)) AS Number
left outer join ( SELECT distinct CONVERT(VARCHAR(10), [DateTime], 120) as StampDate ,convert(varchar(9), [DateTime], 108) AS StampTime ,x.InOut ,x.UserID FROM [FTDP].[dbo].[Transaction] x INNER join [FTDP].[dbo].[UserMapping] c on x.userid = c.userid and c.DomainId = @DomainId ) x on A.date_id = x.StampDate ) ORDER BY
transaction
usermapping
A.date_id = x.StampDate
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)