날짜별 기준으로 left join으로 데이터를 바인딩 할 수 있다..


DECLARE @START_DT VARCHAR(10)
SET @START_DT = '2015-02-26'

DECLARE @END_DT VARCHAR(10)
SET @END_DT = '2015-03-02'

/* 날짜별 리스트 */
SELECT top 100 CONVERT(CHAR(10),DATEADD(d,number,@START_DT),120) as regdate
  FROM master..spt_values WITH (NOLOCK)
 WHERE type = 'P' 
   AND CONVERT(CHAR(10),DATEADD(d,number,@START_DT),120) <= @END_DT
   
   
/* 시간까지 표현 */
SELECT CONVERT(char(13),DATEADD(hh,number,@START_DT),120) as regdate
  FROM master..spt_values with(nolock) 
 WHERE type = 'P' 
   AND CONVERT(char(10),DATEADD(hh,number,@START_DT),120) <= @END_DT