on 11-04-2010 10:22 PM
Hola, como hago para que esto me funcione, el query es mucho mas extenso pero inclui la parte relevante.
DECLARE @fecha_i smalldatetime
DECLARE @fecha_f smalldatetime
SET @fecha_i = '[%0]'
SET @fecha_f = '[%1]'
SELECT * FROM SBI_001.dbo.JDT1
WHERE JDT1.Refdate between @fecha_i and @fecha_f
Muchas gracias,
Sólo deberias hacer lo siguiente:
SELECT * FROM SBI_001.dbo.JDT1 T0
WHERE T0.Refdate between '[%0]' and '[%1]'
slds.
Edited by: rulius on Nov 4, 2010 7:24 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
98 | |
12 | |
10 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.