on 08-08-2011 8:39 PM
Hola a todos!!!
Quisiera que pudieran ayudar con este query
el informe debe tener :
Nom del SN , Territorio, Ramo , Vendedor(del Dato maestro del SN), sumatoria de ventas en un rango determinado
Arme este query
SELECT T0.[CardName], T0.[AliasName], T1.[SlpName], T2.[descript], T3.[IndName] ,sum (T4.[DocTotal])FROM OCRD T0 INNER JOIN OSLP T1 ON T0.SlpCode = T1.SlpCode INNER JOIN OTER T2 ON T0.Territory = T2.territryID INNER JOIN OOND T3 ON T0.IndustryC = T3.IndCode INNER JOIN OINV T4 ON T0.CardCode = T4.CardCode where T4.DocDate>=[%0] and T4.DocDate<=[%1] group by T0.[CardName],T0.[AliasName], T1.[SlpName], T2.[descript]
pero me sale el siguiente error
1). [SQL Server Native Client 10.0][SQL Server]Debe especificar la tabla en la que hacer la selección.
2). [SQL Server Native Client 10.0][SQL Server]No se puede preparar la instrucción o instrucciones.
'Contratos de servicio' (OCRT)
hola felipe, mira ahora me sale este
1). [Microsoft][SQL Server Native Client 10.0][SQL Server]No se pueden comparar ni ordenar los tipos de datos text, ntext e image, excepto cuando se utiliza el operador IS NULL o LIKE.
2). [Microsoft][SQL Server Native Client 10.0][SQL Server]No se pued
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Pruebalo asi tambien
SELECT T0.[CardName], CONVERT(NVARCHAR(MAX),T0.[AliasName])'Alias', T1.[SlpName], T2.[descript], T3.[IndName] , SUM(T4.[DocTotal])
FROM [dbo].[OCRD] T0
INNER JOIN [dbo].[OSLP] T1 ON T0.SlpCode = T1.SlpCode
INNER JOIN [dbo].[OTER] T2 ON T0.Territory = T2.territryID
INNER JOIN [dbo].[OOND] T3 ON T0.IndustryC = T3.IndCode
INNER JOIN [dbo].[OINV] T4 ON T0.CardCode = T4.CardCode
WHERE T4.DocDate>='[%0]' AND T4.DocDate<='[%1]'
GROUP BY T0.[CardName], CONVERT(NVARCHAR(MAX),T0.[AliasName]), T1.[SlpName], T2.[descript]
Slds
listo muchas gracias
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Lo ejecute y no me dio problemas
de todas maneras pruebalo asi
SELECT T0.[CardName], T0.[AliasName], T1.[SlpName], T2.[descript], T3.[IndName] , SUM(T4.[DocTotal])
FROM [dbo].[OCRD] T0
INNER JOIN [dbo].[OSLP] T1 ON T0.SlpCode = T1.SlpCode
INNER JOIN [dbo].[OTER] T2 ON T0.Territory = T2.territryID
INNER JOIN [dbo].[OOND] T3 ON T0.IndustryC = T3.IndCode
INNER JOIN [dbo].[OINV] T4 ON T0.CardCode = T4.CardCode
WHERE T4.DocDate>='[%0]' AND T4.DocDate<='[%1]'
GROUP BY T0.[CardName],T0.[AliasName], T1.[SlpName], T2.[descript]
Saludos
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
6 | |
5 | |
5 | |
5 | |
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.