sql按天查数据

qiantin

• [SQL] 纯文本查看 复制代码

  declare @T  
  table([日期] Datetime,[工作内容] nvarchar(8),[发布人] nvarchar(50))  
  Insert  
  @T  
  select  
  '2008-8-11',N'content1','' union all  
  select  
  '2008-8-12',N'content2',''  
   
   
   
   
   
  ;with Date  
   
   
  as  
  (select  
  cast('2008-08-01' as datetime) Date  
  union  
  all  
  select Date+1  
  from Date where Date+1 < '2008-9-1')  
   
  select  
  a.Date,[工作内容]=isnull([工作内容],''),[发布人]=isnull([发布人],'')  
  from  
     
  Date  
  a  
  left  
  join  
  @T b on  
  a.Date=b.[日期] 
   
  with Date as  
  (select cast('2013-04-01' as datetime) Date  
   union all  
   select Date+1  
   from Date where Date+1 < '2013-05-01')    
   
  select  
  CONVERT(VARCHAR(10),a.Date,120),[count]=isnull([count],'')  
  from Date a  
  left join (SELECT COUNT([BID]) as [count],CONVERT(VARCHAR(10),EndTime,120) as [日期] FROM Borrow  
  group by CONVERT(VARCHAR(10),EndTime,120) 
  having CONVERT(VARCHAR(10),EndTime,120) >= '2013-04-01' and  CONVERT(VARCHAR(10),EndTime,120)<'2013-05-01') b on a.date=b.[日期] 

  
  

纸水仙

此地禁止大小便，违者没收工具。

zlzyp

天塌下来你顶着，我垫着!

benzhou

解释就是掩饰，掩饰就是编故事!

wind-cold

我是来刷分的，嘿嘿

hujh20

只要不下流，我们就是主流!

qq489498494

不错不错，楼主您辛苦了。。。