solaleh
پنج شنبه 22 مرداد 1388, 14:05 عصر
سلام دوستان
من storedprocedure ای دارم که مجبورم در قسمت پارامترهای select برای آن شرط بذارم.storedprocedure به صورت زیر است:
PROCEDURE sp_TarazeKol
@kolcd1 nvarchar(50),
@kolcd2 nvarchar(50),
@docnum1 nvarchar(50),
@docnum2 nvarchar(50),
@docdate1 nvarchar(13),
@docdate2 nvarchar(13)
AS
Declare @sql nvarchar(4000),@paramlist nvarchar(4000)
SELECT @sql=
"select Document.KolCode,KolName,sum(Debtor) as 'DebtCircle',sum(Creditor) as 'CredCircle'"
if sum(Debtor)>sum(Creditor)
begin
SELECT @sql=@sql+",sum(Debtor)-sum(Creditor) as 'Remain'
from Document inner join Kol on Document.KolCode=Kol.KolCode
where Document.KolCode between @kolcd1 and @kolcd2
and DocNum between @docnum1 and @docnum2
and DocDate between @docdate1 and @docdate2
group by Document.KolCode,KolName"
end
if sum(Creditor)>sum(Debtor)
begin
SELECT @sql=@sql+",sum(Creditor)-sum(Debtor) as 'Remain'
from Document inner join Kol on Document.KolCode=Kol.KolCode
where Document.KolCode between @kolcd1 and @kolcd2
and DocNum between @docnum1 and @docnum2
and DocDate between @docdate1 and @docdate2
group by Document.KolCode,KolName"
end
Exec(@sql)
اما موقع ذخیره خطایی می ده که ضمیمه اش کردم.
اشکال کجاست؟
ممنون از توجهتون.
من storedprocedure ای دارم که مجبورم در قسمت پارامترهای select برای آن شرط بذارم.storedprocedure به صورت زیر است:
PROCEDURE sp_TarazeKol
@kolcd1 nvarchar(50),
@kolcd2 nvarchar(50),
@docnum1 nvarchar(50),
@docnum2 nvarchar(50),
@docdate1 nvarchar(13),
@docdate2 nvarchar(13)
AS
Declare @sql nvarchar(4000),@paramlist nvarchar(4000)
SELECT @sql=
"select Document.KolCode,KolName,sum(Debtor) as 'DebtCircle',sum(Creditor) as 'CredCircle'"
if sum(Debtor)>sum(Creditor)
begin
SELECT @sql=@sql+",sum(Debtor)-sum(Creditor) as 'Remain'
from Document inner join Kol on Document.KolCode=Kol.KolCode
where Document.KolCode between @kolcd1 and @kolcd2
and DocNum between @docnum1 and @docnum2
and DocDate between @docdate1 and @docdate2
group by Document.KolCode,KolName"
end
if sum(Creditor)>sum(Debtor)
begin
SELECT @sql=@sql+",sum(Creditor)-sum(Debtor) as 'Remain'
from Document inner join Kol on Document.KolCode=Kol.KolCode
where Document.KolCode between @kolcd1 and @kolcd2
and DocNum between @docnum1 and @docnum2
and DocDate between @docdate1 and @docdate2
group by Document.KolCode,KolName"
end
Exec(@sql)
اما موقع ذخیره خطایی می ده که ضمیمه اش کردم.
اشکال کجاست؟
ممنون از توجهتون.