Εργαλεια χειρος

select * from (select Row_Number() over ( ORDER BY [prodPrice] ) as RowIndex, * FROM [prods] WHERE ([diathesi]<>N'Μη διαθέσιμο') AND ( CHARINDEX('~193~',[prodKatID]) > 0 OR CHARINDEX('~407411~',[prodKatID]) > 0 OR CHARINDEX('~198~',[prodKatID]) > 0 OR CHARINDEX('~195~',[prodKatID]) > 0 OR CHARINDEX('~352~',[prodKatID]) > 0 OR CHARINDEX('~353~',[prodKatID]) > 0 OR CHARINDEX('~356~',[prodKatID]) > 0 OR CHARINDEX('~557~',[prodKatID]) > 0 OR CHARINDEX('~194~',[prodKatID]) > 0 OR CHARINDEX('~315372~',[prodKatID]) > 0 OR CHARINDEX('~603~',[prodKatID]) > 0 OR CHARINDEX('~113570~',[prodKatID]) > 0 OR CHARINDEX('~361069~',[prodKatID]) > 0 OR CHARINDEX('~382958~',[prodKatID]) > 0 OR CHARINDEX('~344636~',[prodKatID]) > 0 OR CHARINDEX('~114511~',[prodKatID]) > 0 OR CHARINDEX('~362199~',[prodKatID]) > 0 OR CHARINDEX('~382393~',[prodKatID]) > 0 OR CHARINDEX('~116305~',[prodKatID]) > 0 OR CHARINDEX('~116306~',[prodKatID]) > 0 OR CHARINDEX('~116439~',[prodKatID]) > 0 OR CHARINDEX('~386553~',[prodKatID]) > 0 OR CHARINDEX('~412344~',[prodKatID]) > 0 )) as Sub Where Sub.RowIndex >= 1 and Sub.RowIndex <= 12;

DECLARE @klist NVARCHAR(MAX) SELECT @klist = COALESCE(@klist+'|' ,'') + CAST(katigoriaID as varchar(20)) + '~' + katigoriaName FROM (SELECT TOP 500 prods.prodKatID,katigories.katigoriaName,katigories.katigoriaID FROM prods INNER JOIN Katigories ON CHARINDEX('~'+ CAST(katigories.katigoriaID as varchar(20)) +'~',prods.prodKatID) > 0 WHERE ( CHARINDEX('~193~',[prodKatID]) > 0 OR CHARINDEX('~407411~',[prodKatID]) > 0 OR CHARINDEX('~198~',[prodKatID]) > 0 OR CHARINDEX('~195~',[prodKatID]) > 0 OR CHARINDEX('~352~',[prodKatID]) > 0 OR CHARINDEX('~353~',[prodKatID]) > 0 OR CHARINDEX('~356~',[prodKatID]) > 0 OR CHARINDEX('~557~',[prodKatID]) > 0 OR CHARINDEX('~194~',[prodKatID]) > 0 OR CHARINDEX('~315372~',[prodKatID]) > 0 OR CHARINDEX('~603~',[prodKatID]) > 0 OR CHARINDEX('~113570~',[prodKatID]) > 0 OR CHARINDEX('~361069~',[prodKatID]) > 0 OR CHARINDEX('~382958~',[prodKatID]) > 0 OR CHARINDEX('~344636~',[prodKatID]) > 0 OR CHARINDEX('~114511~',[prodKatID]) > 0 OR CHARINDEX('~362199~',[prodKatID]) > 0 OR CHARINDEX('~382393~',[prodKatID]) > 0 OR CHARINDEX('~116305~',[prodKatID]) > 0 OR CHARINDEX('~116306~',[prodKatID]) > 0 OR CHARINDEX('~116439~',[prodKatID]) > 0 OR CHARINDEX('~386553~',[prodKatID]) > 0 OR CHARINDEX('~412344~',[prodKatID]) > 0 ) ORDER BY katigories.katigoriaName) t SELECT IsNull(@klist, '')

SELECT MAX([prodPrice]) AS HighestPrice FROM [prods] WHERE ([diathesi]<>N'Μη διαθέσιμο') AND ( CHARINDEX('~193~',[prodKatID]) > 0 OR CHARINDEX('~407411~',[prodKatID]) > 0 OR CHARINDEX('~198~',[prodKatID]) > 0 OR CHARINDEX('~195~',[prodKatID]) > 0 OR CHARINDEX('~352~',[prodKatID]) > 0 OR CHARINDEX('~353~',[prodKatID]) > 0 OR CHARINDEX('~356~',[prodKatID]) > 0 OR CHARINDEX('~557~',[prodKatID]) > 0 OR CHARINDEX('~194~',[prodKatID]) > 0 OR CHARINDEX('~315372~',[prodKatID]) > 0 OR CHARINDEX('~603~',[prodKatID]) > 0 OR CHARINDEX('~113570~',[prodKatID]) > 0 OR CHARINDEX('~361069~',[prodKatID]) > 0 OR CHARINDEX('~382958~',[prodKatID]) > 0 OR CHARINDEX('~344636~',[prodKatID]) > 0 OR CHARINDEX('~114511~',[prodKatID]) > 0 OR CHARINDEX('~362199~',[prodKatID]) > 0 OR CHARINDEX('~382393~',[prodKatID]) > 0 OR CHARINDEX('~116305~',[prodKatID]) > 0 OR CHARINDEX('~116306~',[prodKatID]) > 0 OR CHARINDEX('~116439~',[prodKatID]) > 0 OR CHARINDEX('~386553~',[prodKatID]) > 0 OR CHARINDEX('~412344~',[prodKatID]) > 0 )