declare @t table (i int identity(1,1), name nvarchar(10))
insert into @t (name) values ('Name1'),('Name2'),('Name3')

select *
from @t 
  cross apply (values ('20140101') , ('20140202')) v(x)

DECLARE  @Date datetime
	
SET @Date = '2014-12-10 00:00:00';
			
			
DECLARE @FromDate SMALLDATETIME, @ToDate SMALLDATETIME;
SELECT @FromDate = DATEADD(HOUR, 6, @Date), @ToDate = DATEADD(HOUR, 18, @Date);
WITH [Hours](H) AS
(
 SELECT @FromDate WHERE @FromDate < @ToDate
 UNION ALL
 SELECT DATEADD(HOUR, 12, H) FROM Hours WHERE H < @ToDate
)

SELECT Id, Name Hours.H
FROM MyTable
CROSS JOIN Hours
ORDER BY Id