Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT Nombre, Url, Orden FROM
- (
- SELECT
- CASE
- WHEN UxB.IdTipoUsuario = 1 THEN TU.Tipo
- WHEN UxB.IdTipoUsuario = 2 THEN TU.Tipo
- WHEN UxB.IdTipoUsuario = 3 THEN BS.Nombre
- END AS Nombre,
- CASE
- WHEN UxB.IdTipoUsuario = 1 THEN TU.Url
- WHEN UxB.IdTipoUsuario = 2 THEN TU.Url
- WHEN UxB.IdTipoUsuario = 3 THEN '/Brandsite/Login.aspx?id=' + CONVERT(VARCHAR, BS.IdBrandSite)
- END AS Url,
- CASE
- WHEN UxB.IdTipoUsuario = 2 THEN 1 ELSE 2
- END AS Orden
- FROM catUsuariosPorBrandSite UxB
- LEFT JOIN catBrandSites BS ON BS.IdBrandSite = UxB.IdBrandSite AND BS.IdEstatus in (1)
- LEFT JOIN catTiposUsuario TU ON TU.IdTipoUsuario = UxB.IdTipoUsuario AND TU.Activo = 1
- INNER JOIN catUsuarios U ON U.IdUsuario = UxB.IdUsuario AND U.Activo = 1
- WHERE UxB.Activo = 1 AND UxB.IdUsuario = 220
- ) AS MisSitios
- WHERE Nombre IS NOT NULL AND Url IS NOT NULL
- ORDER BY Orden, Nombre ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement