un lucru f important pe care am uitat sa-l precizez si-mi cer scuze este ca
tabela este catre un linked server
daca rulez scriptul direct pe server>>databaseul unde se afla tabela merge f bine adica
declare
@Data varchar(8)
set
@Data = '20090331'
select ClientId, Dept, (-1) * sum(Soldl) as Sold
from
tabela
where
Bdata = @Data
and
left(AccSint,4) in ('2021','2031','2042','2052','2061','2091','2312','2811','2821')
group
by ClientId, Dept
daca rulez scriptul prin linked server atunci merge f greu (dar daca inlocuiesc @data cu '20090331' merge ok)
declare
@Data varchar(8)
set
@Data = '20090331'
select ClientId, Dept, (-1) * sum(Soldl) as Sold
from
server.db.dbo.tabela
where Bdata = @Data
and
left(AccSint,4) in ('2021','2031','2042','2052','2061','2091','2312','2811','2821')
group
by ClientId, Dept
multumesc.