şartlı sorgu

[erhan2484]

Merhaba,aşağıdaki sorguda değişkeni sorguya nasıl eklemeliyim

declare @logicalref int
select CLCARD.CODE,CLCARD.LOGICALREF=@logicalref 
from  LG_038_01_CLFLINE CLFLINE  LEFT JOIN LG_038_CLCARD CLCARD ON CLCARD.LOGICALREF=CLFLINE.CLIENTREF
WHERE  CLFLINE.CANCELLED=0  AND ((CLFLINE.TRCODE IN (38) AND
CLFLINE.DATE_ BETWEEN GETDATE()-180
AND GETDATE())  AND CLFLINE.CLIENTREF NOT IN (SELECT CLIENTREF FROM LG_038_01_CLFLINE
WHERE TRCODE IN (1 ,20,61,62,70) AND DATE_ BETWEEN GETDATE()-105 AND GETDATE()) AND CANCELLED=0)

if('LG_038_CLCARD.CODE'<>'')
begin
update LG_038_CLCARD SET SPECODE=1
end
ELSE
begin
update LG_038_CLCARD SET SPECODE=''
end

[Yazar]

Yazılar