on 07-13-2012 4:59 PM
Apreciados compañeros: como puedo agregarle una columna que mantenga la numeracion a este informe necesito colocar la numeracion de las lineas a este informe. SELECT T0.callID'Llamada #', T0.createDate, T0.createTime, T0.U_ModCon'Contrato', T0.priority, T5.firstName'Técnico', T0.custmrName'Cliente', T0.U_Suc1'Ubicación-Equipo', T3.Name'Status', T0.subject FROM OSCL T0 INNER JOIN OSCO T2 ON T0.origin = T2.originID INNER JOIN OSCS T3 ON T0.status = T3.statusID INNER JOIN OUSR T4 ON T0.assignee = T4.INTERNAL_K INNER JOIN OHEM T5 ON T0.technician = T5.empID WHERE T4.U_NAME Like '%%Luis Kaa%%' and T0.status NOT Like '%%-1%%' and T0.status NOT Like '%%1%%' ORDER BY T0.createDate gracias, alberto
No, no funciona ni como stored procedure ni como sql dinamico y eso que lo estoy ejecutando sin campos de usuario.
Pero si lo ejecutas desde sql management studio, funciona sin problemas.
Seguiré probando.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ya logre hacer funcionar el ROW_NUMBER()
Utiliza este query, agrega tus campos de usuario...se los quite cuando hize las pruebas
SELECT
CAST(ROW_NUMBER() OVER (ORDER BY T0.[createdate]) AS INT) AS Linea#,
T0.[callID] AS Llamada#,
T0.[createDate],
T0.[createTime],
T0.[priority],
T5.[firstName] AS Tecnico,
T0.[custmrName] AS Cliente,
T3.[Name] AS Status,
T0.[subject]
FROM [dbo].[OSCL] T0
LEFT JOIN [dbo].[OSCO] T2 ON T0.[origin] = T2.[originID]
LEFT JOIN [dbo].[OSCS] T3 ON T0.[status] = T3.[statusID]
LEFT JOIN [dbo].[OUSR] T4 ON T0.[assignee] = T4.[INTERNAL_K]
LEFT JOIN [dbo].[OHEM] T5 ON T0.[technician] = T5.[empID]
ORDER BY T0.[createDate]
SALUDOS
Alberto:
Prueba la siguiente query:
SELECT
T0.callID'Llamada #', T0.createDate, T0.createTime, T0.U_ModCon'Contrato', T0.priority,
T5
.firstName'Tcnico', T0.custmrName'Cliente', T0.U_Suc1'Ubicacin-Equipo', T3.Name'Status',
T0
.subject ,
ROW_NUMBER () OVER (ORDER BY createdate) as Registro
FROM OSCL T0
INNER JOIN OSCO T2 ON T0.origin = T2.originID
INNER JOIN OSCS T3 ON T0.status = T3.statusID
INNER JOIN OUSR T4 ON T0.assignee = T4.INTERNAL_K
INNER JOIN OHEM T5 ON T0.technician = T5.empID
WHERE T4.U_NAME Like '%%Luis Kaa%%' and T0.status NOT Like '%%-1%%'
and T0.status NOT Like '%%1%%'
ORDER BY T0.createDate
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Prueba lo siguiente:
SELECT
T0.callID'Llamada #', T0.createDate, T0.createTime, T0.U_ModCon'Contrato', T0.priority,
T5
.firstName'Tcnico', T0.custmrName'Cliente', T0.U_Suc1'Ubicacin-Equipo', T3.Name'Status',
T0
.subject ,
ROW_NUMBER () OVER (ORDER BY t0.createdate) as Registro
FROM OSCL T0
INNER JOIN OSCO T2 ON T0.origin = T2.originID
INNER JOIN OSCS T3 ON T0.status = T3.statusID
INNER JOIN OUSR T4 ON T0.assignee = T4.INTERNAL_K
INNER JOIN OHEM T5 ON T0.technician = T5.empID
WHERE T4.U_NAME Like '%%Luis Kaa%%' and T0.status NOT Like '%%-1%%'
and T0.status NOT Like '%%1%%'
ORDER BY T0.createDate
Hola Fernando, me sale el siguiente error, 1). [Microsoft][SQL Server Native Client 10.0][SQL Server]Must specify table to select from. 2). [Microsoft][SQL Server Native Client 10.0][SQL Server]Statement 'Valores definidos por usuario' (CSHS) (s) could not be prepared. gracias por tu atención, Alberto
Hola Alberto, no entiendo muy bien que requieres.
Podrias especificar mejor o poner un pequeño ejemplo.
Atte.
Felipe
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hola
Prueba este query
SELECT
ROW_NUMBER() OVER (ORDER BY T0.createdate) AS Linea#,
, T0.callID AS Llamada#,
T0.createDate,
T0.createTime,
T0.U_ModCon'Contrato',
T0.priority,
T5.firstName AS Tecnico,
T0.custmrName AS Cliente,
T0.U_Suc1 AS Ubicacin_Equipo,
T3.Name AS Statu,
T0.subject
FROM OSCL T0
INNER JOIN OSCO T2 ON T0.origin = T2.originID
INNER JOIN OSCS T3 ON T0.status = T3.statusID
INNER JOIN OUSR T4 ON T0.assignee = T4.INTERNAL_K
INNER JOIN OHEM T5 ON T0.technician = T5.empID
WHERE T4.U_NAME LIKE '%%Luis Kaa%%' AND T0.status NOT LIKE '%%-1%%' AND T0.status NOT LIKE '%%1%%'
ORDER BY T0.createDate
Saludos
Prueba ahora, habia una "coma" mal puesta
SELECT
ROW_NUMBER() OVER (ORDER BY T0.createdate) AS Linea#,
T0.callID AS Llamada#,
T0.createDate,
T0.createTime,
T0.U_ModCon'Contrato',
T0.priority,
T5.firstName AS Tecnico,
T0.custmrName AS Cliente,
T0.U_Suc1 AS Ubicacin_Equipo,
T3.Name AS Statu,
T0.subject
FROM OSCL T0
INNER JOIN OSCO T2 ON T0.origin = T2.originID
INNER JOIN OSCS T3 ON T0.status = T3.statusID
INNER JOIN OUSR T4 ON T0.assignee = T4.INTERNAL_K
INNER JOIN OHEM T5 ON T0.technician = T5.empID
WHERE T4.U_NAME LIKE '%%Luis Kaa%%' AND T0.status NOT LIKE '%%-1%%' AND T0.status NOT LIKE '%%1%%'
ORDER BY T0.createDate
User | Count |
---|---|
93 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
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.