how can I show duplicate values in a query

See more:

SQL

Hello I have a query below. I am trying to show 7 days in 14 rows which means that each day should have 2 rows. which works fine

SELECT  t.*
FROM    Calender AS t
        CROSS JOIN (VALUES (1), (2)) AS Number 

However, when I Left Join with another table then each day will multiply by 2 again so becomes 4 rows

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 

is there another way to display 14 rows and that does not multiply when I left join?