Bdata in tabela este varchar(8) si nu o pot modifica
am testat si cu
declare
@data varchar(8)
set
@data = '20090331'
si cu
declare @data datetime
set
@data = '20090331'
si cu
select ClientId, Dept, (-1)*sum(Soldl) as Sold
from table where cast(Bdata as varchar(8)) = @data
and left(AccSint,4) in ('2021','2031','2042','2052','2061','2091','2312','2811','2821')
group by ClientId, Dept
si la fel de prost merge