1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| select UserReqID,Title,Gamme.Libelle,ProjectName,Version.Libelle,convert(varchar(10),DateCreated,103)
from UserReq,XWUser,Gamme,Project,Version
where EnteredByID=XWUserID
and UserName='BMR'
and Project.GammeID=Gamme.GammeID
and UserReq.ProjectID=Project.ProjectID
and UserReq.VersionID=Version.VersionID
AND UserReq.VersionID IS NOT NULL
UNION
select UserReqID,Title,Gamme.Libelle,ProjectName, 'PAS DE VERSION DISPO',convert(varchar(10),DateCreated,103)
from UserReq,XWUser,Gamme,Project
where EnteredByID=XWUserID
and UserName='BMR'
and Project.GammeID=Gamme.GammeID
and UserReq.ProjectID=Project.ProjectID
and UserReq.VersionID IS NULL) |
Partager