declare @p1 int
--set @p1=30
exec sp_prepare @p1 output,NULL,N'select top 40 billcode,item,case when SUM(inqty) <> 0 then 0 else 1 end as qty from v_item_in_out a left join u_ware_q b (nolock) on a.wareid = b.wareid where   a.wareid = ''0000004'' and  a.execdate between ''2024-12-01'' and dateadd(ms,-3,dateadd(dd,1,''2024-12-31''))  group by billcode,item order by qty,billcode',1
exec sp_execute @p1　　--執行

exec sp_unprepare @p1