一个sql语句，求高手过来看看如何写

[t_sheng]

想写个存储过程，传两个参数 ：一个 时间，还有一个是周期数
有个表里有两个时间，cr.tabDate 有可能是空的，下面的where中case怎么写
关键是
(case ISNULL(cr.tabDate,0)
when 0 then select datediff(DAY,cr.billdate,@nowData) = @day
else (select datediff(DAY,cr.tabDate,@nowData)) = @day
end)

要怎么加

create procedure ud_getRemindRepair
@nowData datetime,
@day varchar
as

select gr.billid,cr.code,cr.billdate,cr.Mobile from goodsrecord gr
left join clientrepair cr on cr.repairid=gr.billid
where ISNULL(gr.goodshabitus,0)=0 and ISNULL(gr.vrhabitus,0)=0 and notetype=50 and
(case ISNULL(cr.tabDate,0)
when 0 then select datediff(DAY,cr.billdate,@nowData) = @day
else (select datediff(DAY,cr.tabDate,@nowData)) = @day
end)
group by gr.billid,cr.code,cr.billdate,cr.Mobile

[t_sheng]

这个 @day 应该是int

[快溜]

create procedure ud_getRemindRepair
@nowData datetime=null,
@day int=0  
as

select gr.billid,cr.code,cr.billdate,cr.Mobile from goodsrecord gr
left join clientrepair cr on cr.repairid=gr.billid
where 
datediff(DAY,cr.billdate,isnull(@nowData,cr.billdate)) = @day 
group by gr.billid,cr.code,cr.billdate,cr.Mobile

[风车呼噜噜]

select gr.billid,cr.code,cr.billdate,cr.Mobile from goodsrecord gr
left join clientrepair cr on cr.repairid=gr.billid
where ISNULL(gr.goodshabitus,0)=0 and ISNULL(gr.vrhabitus,0)=0 and notetype=50 and
(case ISNULL(cr.tabDate,0) 
when 0 then datediff(DAY,cr.billdate,@nowData) 
else datediff(DAY,cr.tabDate,@nowData)
end) = @day 
group by gr.billid,cr.code,cr.billdate,cr.Mobile

试试

[t_sheng]

谢谢各位 ，出来了