Comparacion de una variable tabla
Publicado por Jorge (3 intervenciones) el 07/10/2016 07:26:10
Hola amigos, necesito ayuda con este sentencia.
quiero comparar el folder produccion con cada uno de los que estan en la imagen.
al final logro comparar dos, pero nose como comparar los demas
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
DECLARE @TICKETSGEN as table(Folder Varchar(30),
Ticket Varchar(30)
)Insert into @TICKETSGEN
Select a.Carpeta, a.BaseValue as Ticket_SW
from
(Select
CHARINDEX ( '\' , v.FullPath,3 )as PP,
CHARINDEX ( '\' , v.FullPath,CHARINDEX ( '\' , v.FullPath,3 )+1 ) as SP,
SUBSTRING(v.FullPath,CHARINDEX ( '\' , v.FullPath,3 )+1,CHARINDEX ( '\' , v.FullPath,CHARINDEX ( '\' , v.FullPath,3 )+1 )-CHARINDEX ( '\' , v.FullPath,3 )-1)as Carpeta,
FieldName,BaseValue
from tbl_Changeset cs
INNER JOIN tbl_Version v ON v.VersionFrom = cs.ChangesetID
INNER JOIN tbl_IdentityMap im ON cs.OwnerId = im.localId
INNER JOIN Tfs_Configuration..tbl_identity i ON im.masterId = i.Id
INNER JOIN tbl_ReleaseNoteDetails RN ON RN.ReleaseNoteId = cs.CheckInNoteId
) a where Fieldname like 'Ticket SW'Group by a.Carpeta, a.BaseValue
1
2
3
select * from @TICKETSGEN TPwhere Folder = 'Produccion'
and Not exists (select * from @TICKETSGEN TS where Folder = 'Soporte' and TP.Ticket = TS.Ticket)
Valora esta pregunta
0
