1 2 3 4 5 6 7 8 9 10 11
|
DECLARE @SecteurNews VARCHAR(3), @LangueNews VARCHAR(3), @UserNews VARCHAR(5000), @CategorieNews VARCHAR(1000)
SET @SecteurNews = 'bil'
SET @LangueNews = 'ang'
SET @UserNews = '764e0c37-76d6-476c-9ad7-05cd11b4c104'',''606df898-5018-4470-bf8a-11084bf8f2bb'',''2432cc9e-3a3c-4b7f-b8e2-1383924c93c7'',''ef6ce12d-4055-442c-958a-3d78b7100948'',''5c051789-7232-4db0-8058-66f64146b178'',''bfa6aea8-0adb-4064-8b60-bb1e2ef282f6'',''f4be17f9-cb07-4332-b41a-c708895f6446'',''60b90952-59bc-42f7-a452-e2fde8b2b516'
SET @CategorieNews = '35,36,37,38,39,40,41,42,43,44'
SELECT NA.IdNews, U.UserName, NA.TitreNews, NA.TexteNews, NA.ImageMicroVisu FROM dbo.CORE_NewsApproved NA
INNER JOIN aspnet_Users U ON U.UserId = NA.GuidUser WHERE NA.SecteurNews = @SecteurNews AND NA.LangueNews = @LangueNews
AND NA.GuidUser IN (@UserNews)
AND NA.CategorieNews IN (@CategorieNews ) |
Partager