>>DECLARE @NoSite Integer >>DECLARE @NoSite2 Integer >>DECLARE @Enabled Bit >>DECLARE @NoSite3 Integer >>DECLARE @Enabled2 Bit >>DECLARE @NoSite4 Integer >>DECLARE @Enabled3 Bit >>DECLARE @NoSite5 Integer >>DECLARE @NoSite6 Integer >> >>SET @NoSite=2 >>SET @NoSite2=2 >>SET @Enabled=1 >>SET @NoSite3=2 >>SET @Enabled2=1 >>SET @NoSite4=2 >>SET @Enabled3=1 >>SET @NoSite5=2 >>SET @NoSite6=2 >> >>SELECT TOP 40 News.Title_E,News.Title_F,News.Url,News.AddDate AS Date,News.Url2,1 AS Type, >>News.NoSite,'' AS Title2 >>FROM News WHERE News.NoSite=@NoSite >>UNION >>SELECT TOP 40 Event.Title AS Title_E,Event.Title AS Title_F,Event.Url,Event.AddDate AS Date, >>convert(char(74),'') AS Url2,2 AS Type,Event.NoSite,'' AS Title2 >>FROM Event >>LEFT JOIN Province ON Event.NoProvince=Province.Numero >>WHERE Event.NoSite=@NoSite2 AND Event.Enabled=@Enabled >>>>