Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql dynamic
Message
From
17/10/2011 21:35:36
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01526661
Message ID:
01526727
Views:
28
I need to add is a variable that contains the value 'balance at the time' but gives an error
set @concepto='Balance a la Fecha'
select rtrim(F.apellidos) as apellidos,@concepto as concepto,
SUM(M.balance) as balance,SUM(M.cuota) as monto,SUM(m.recargo) as recargo,0 as anticipo,
descuentos=sum(CASE WHEN (@fecha2>m.fechadescuento) THEN 0 else (M.descuento+M.descuento2) END),
dias30=sum(CASE WHEN (datediff(dd,m.fechacuota,@fecha2)<=30 and @fecha1>=m.fechacuota) THEN m.balance else 0 END),
dias45=sum(CASE WHEN (datediff(dd,m.fechacuota,@fecha2)> 30 and  datediff(dd,m.fechacuota,@fecha2)<= 45)  THEN m.balance else 0 END),
dias60=sum(CASE WHEN (datediff(dd,m.fechacuota,@fecha2)> 45 and  datediff(dd,m.fechacuota,@fecha2)<= 60)  THEN m.balance else 0 END),
dias75=sum(CASE WHEN (datediff(dd,m.fechacuota,@fecha2)> 60 and  datediff(dd,m.fechacuota,@fecha2)<= 75)  THEN m.balance else 0 END),
dias90=sum(CASE WHEN (datediff(dd,m.fechacuota,@fecha2)> 75 and  datediff(dd,m.fechacuota,@fecha2)<= 90)  THEN m.balance else 0 END),
dias91=sum(CASE WHEN (datediff(dd,m.fechacuota,@fecha2)>=91) THEN m.balance else 0 END)
from cuotas m,familias f 
where M.idfamilia=f.idfamilia and M.balance>0    AND m.fechacuota<=@fecha2   AND m.escolar=@escolar group by M.idfamilia,F.apellidos
Msg 137, Level 15, State 2, Line 1
Must declare the scalar variable "@concepto".
Jose Manuel Ramirez
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform