on 10-01-2015 8:43 PM
Hola muy buenas tardes, soy nuevo en esta blog, tengo una duda con una consulta que no la puedo guardar y le pido de antemano a ver si me puede ayudar en esta consulta?
Me arroja el siguiente error:
1). [Microsoft][SQL Server Native Client 10.0][SQL Server]Debe especificar la tabla en la que hacer la selección.2). [Microsoft][SQL Server Native Client 10.0][SQL Server]No se puede preparar la instrucción o instrucciones.
'' (SWEI)
Anexo la consulta a continuación:
DECLARE @VAR1 INT
DECLARE @INI1 DATETIME
DECLARE @FIN1 DATETIME
SET @VAR1 = (SELECT TOP 1 A.TransId FROM JDT1 A WHERE A.RefDate BETWEEN '[%0]' AND '[%1]')
SET @INI1 = '[%0]'
SET @FIN1 = '[%1]'
SELECT
T0.[ItemCode],
T0.[ItemName],
T3.[ItmsGrpNam],
T0.[LastPurPrc],
T0.[LastPurCur],
T0.[LastPurDat],
T0.[PrchseItem],
/* Almacen 900 */
-- Venta --
ISNULL((SELECT SUM(Y.Quantity)
FROM OINV X INNER JOIN INV1 Y ON Y.DocEntry = X.DocEntry
WHERE Y.ItemCode = T0.ItemCode AND X.DocDate >= @INI1 AND X.DocDate <= @FIN1 AND Y.WhsCode = '900'),0)
-ISNULL((SELECT SUM(Y.Quantity)
FROM ORIN X INNER JOIN RIN1 Y ON Y.DocEntry=X.DocEntry
WHERE Y.ItemCode = T0.ItemCode AND X.DocDate >= @INI1 AND X.DocDate <= @FIN1 AND Y.WhsCode = '900'),0) 'Venta',
T0.[OnHand],
T1.[U_SCAT]
FROM OITM T0
INNER JOIN [dbo].[@INVSCAT] T1 ON T0.U_CAT = T1.U_SCOD
INNER JOIN [dbo].[@INVCAT] T2 ON T1.Code = T2.Code
INNER JOIN OITB T3 ON T0.[ItmsGrpCod] = T3.[ItmsGrpCod]
WHERE T2.[U_CAT] = [%2]
De antemanco Mucha Gracias
SALUDOS
JOHAN DYCK
Que valores guardas en el campo U_CAT
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hola muy buenas tardes en el U_CAT es la Categoria del articulo, en el U_CAT si me funciona donde no me funcione es esta parte: ([%0]') ( '[%1])lo que es la parte de fecha
Y si la pongo de este modo si funciona.
DECLARE @VAR1 INT
DECLARE @INI1 DATETIME
DECLARE @FIN1 DATETIME
SET @VAR1 = (SELECT TOP 1 A.TransId FROM JDT1 A WHERE A.RefDate BETWEEN '20150101' AND '20151231')
SET @INI1 = '20150101'
SET @FIN1 = '20151231'
SELECT
T0.[ItemCode],
T0.[ItemName],
T3.[ItmsGrpNam],
T0.[LastPurPrc],
T0.[LastPurCur],
T0.[LastPurDat],
T0.[PrchseItem],
/* Almacen 900 */
-- Venta --
ISNULL((SELECT SUM(Y.Quantity)
FROM OINV X INNER JOIN INV1 Y ON Y.DocEntry = X.DocEntry
WHERE Y.ItemCode = T0.ItemCode AND X.DocDate >= @INI1 AND X.DocDate <= @FIN1 AND Y.WhsCode = '900'),0)
-ISNULL((SELECT SUM(Y.Quantity)
FROM ORIN X INNER JOIN RIN1 Y ON Y.DocEntry=X.DocEntry
WHERE Y.ItemCode = T0.ItemCode AND X.DocDate >= @INI1 AND X.DocDate <= @FIN1 AND Y.WhsCode = '900'),0) 'Venta',
T0.[OnHand],
T1.[U_SCAT]
FROM OITM T0
INNER JOIN [dbo].[@INVSCAT] T1 ON T0.U_CAT = T1.U_SCOD
INNER JOIN [dbo].[@INVCAT] T2 ON T1.Code = T2.Code
INNER JOIN OITB T3 ON T0.[ItmsGrpCod] = T3.[ItmsGrpCod]
WHERE T2.[U_CAT] = [%2]
GRACIAS
SALUDOS
User | Count |
---|---|
107 | |
12 | |
11 | |
6 | |
5 | |
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.