Γενικης χρησης

select * from (select Row_Number() over ( ORDER BY [prodPrice] ) as RowIndex, * FROM [prods] WHERE ([diathesi]<>N'Μη διαθέσιμο') AND ( CHARINDEX('~299~',[prodKatID]) > 0 OR CHARINDEX('~358~',[prodKatID]) > 0 OR CHARINDEX('~364~',[prodKatID]) > 0 OR CHARINDEX('~535~',[prodKatID]) > 0 OR CHARINDEX('~431~',[prodKatID]) > 0 OR CHARINDEX('~432~',[prodKatID]) > 0 OR CHARINDEX('~433~',[prodKatID]) > 0 OR CHARINDEX('~434~',[prodKatID]) > 0 OR CHARINDEX('~443~',[prodKatID]) > 0 OR CHARINDEX('~456~',[prodKatID]) > 0 OR CHARINDEX('~458~',[prodKatID]) > 0 OR CHARINDEX('~459~',[prodKatID]) > 0 OR CHARINDEX('~308229~',[prodKatID]) > 0 OR CHARINDEX('~227530~',[prodKatID]) > 0 OR CHARINDEX('~540~',[prodKatID]) > 0 OR CHARINDEX('~541~',[prodKatID]) > 0 OR CHARINDEX('~39557~',[prodKatID]) > 0 OR CHARINDEX('~76425~',[prodKatID]) > 0 OR CHARINDEX('~76426~',[prodKatID]) > 0 OR CHARINDEX('~76427~',[prodKatID]) > 0 OR CHARINDEX('~77650~',[prodKatID]) > 0 OR CHARINDEX('~97024~',[prodKatID]) > 0 OR CHARINDEX('~97023~',[prodKatID]) > 0 OR CHARINDEX('~94951~',[prodKatID]) > 0 OR CHARINDEX('~94950~',[prodKatID]) > 0 OR CHARINDEX('~536~',[prodKatID]) > 0 )) as Sub Where Sub.RowIndex >= 97 and Sub.RowIndex <= 108;

299, / WHERE ( CHARINDEX('~299~',[prodKatID]) > 0 OR CHARINDEX('~358~',[prodKatID]) > 0 OR CHARINDEX('~364~',[prodKatID]) > 0 OR CHARINDEX('~535~',[prodKatID]) > 0 OR CHARINDEX('~431~',[prodKatID]) > 0 OR CHARINDEX('~432~',[prodKatID]) > 0 OR CHARINDEX('~433~',[prodKatID]) > 0 OR CHARINDEX('~434~',[prodKatID]) > 0 OR CHARINDEX('~443~',[prodKatID]) > 0 OR CHARINDEX('~456~',[prodKatID]) > 0 OR CHARINDEX('~458~',[prodKatID]) > 0 OR CHARINDEX('~459~',[prodKatID]) > 0 OR CHARINDEX('~308229~',[prodKatID]) > 0 OR CHARINDEX('~227530~',[prodKatID]) > 0 OR CHARINDEX('~540~',[prodKatID]) > 0 OR CHARINDEX('~541~',[prodKatID]) > 0 OR CHARINDEX('~39557~',[prodKatID]) > 0 OR CHARINDEX('~76425~',[prodKatID]) > 0 OR CHARINDEX('~76426~',[prodKatID]) > 0 OR CHARINDEX('~76427~',[prodKatID]) > 0 OR CHARINDEX('~77650~',[prodKatID]) > 0 OR CHARINDEX('~97024~',[prodKatID]) > 0 OR CHARINDEX('~97023~',[prodKatID]) > 0 OR CHARINDEX('~94951~',[prodKatID]) > 0 OR CHARINDEX('~94950~',[prodKatID]) > 0 OR CHARINDEX('~536~',[prodKatID]) > 0 )

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('~299~',[prodKatID]) > 0 OR CHARINDEX('~358~',[prodKatID]) > 0 OR CHARINDEX('~364~',[prodKatID]) > 0 OR CHARINDEX('~535~',[prodKatID]) > 0 OR CHARINDEX('~431~',[prodKatID]) > 0 OR CHARINDEX('~432~',[prodKatID]) > 0 OR CHARINDEX('~433~',[prodKatID]) > 0 OR CHARINDEX('~434~',[prodKatID]) > 0 OR CHARINDEX('~443~',[prodKatID]) > 0 OR CHARINDEX('~456~',[prodKatID]) > 0 OR CHARINDEX('~458~',[prodKatID]) > 0 OR CHARINDEX('~459~',[prodKatID]) > 0 OR CHARINDEX('~308229~',[prodKatID]) > 0 OR CHARINDEX('~227530~',[prodKatID]) > 0 OR CHARINDEX('~540~',[prodKatID]) > 0 OR CHARINDEX('~541~',[prodKatID]) > 0 OR CHARINDEX('~39557~',[prodKatID]) > 0 OR CHARINDEX('~76425~',[prodKatID]) > 0 OR CHARINDEX('~76426~',[prodKatID]) > 0 OR CHARINDEX('~76427~',[prodKatID]) > 0 OR CHARINDEX('~77650~',[prodKatID]) > 0 OR CHARINDEX('~97024~',[prodKatID]) > 0 OR CHARINDEX('~97023~',[prodKatID]) > 0 OR CHARINDEX('~94951~',[prodKatID]) > 0 OR CHARINDEX('~94950~',[prodKatID]) > 0 OR CHARINDEX('~536~',[prodKatID]) > 0 ) ORDER BY katigories.katigoriaName) t SELECT IsNull(@klist, '')

SELECT MAX([prodPrice]) AS HighestPrice FROM [prods] WHERE ([diathesi]<>N'Μη διαθέσιμο') AND ( CHARINDEX('~299~',[prodKatID]) > 0 OR CHARINDEX('~358~',[prodKatID]) > 0 OR CHARINDEX('~364~',[prodKatID]) > 0 OR CHARINDEX('~535~',[prodKatID]) > 0 OR CHARINDEX('~431~',[prodKatID]) > 0 OR CHARINDEX('~432~',[prodKatID]) > 0 OR CHARINDEX('~433~',[prodKatID]) > 0 OR CHARINDEX('~434~',[prodKatID]) > 0 OR CHARINDEX('~443~',[prodKatID]) > 0 OR CHARINDEX('~456~',[prodKatID]) > 0 OR CHARINDEX('~458~',[prodKatID]) > 0 OR CHARINDEX('~459~',[prodKatID]) > 0 OR CHARINDEX('~308229~',[prodKatID]) > 0 OR CHARINDEX('~227530~',[prodKatID]) > 0 OR CHARINDEX('~540~',[prodKatID]) > 0 OR CHARINDEX('~541~',[prodKatID]) > 0 OR CHARINDEX('~39557~',[prodKatID]) > 0 OR CHARINDEX('~76425~',[prodKatID]) > 0 OR CHARINDEX('~76426~',[prodKatID]) > 0 OR CHARINDEX('~76427~',[prodKatID]) > 0 OR CHARINDEX('~77650~',[prodKatID]) > 0 OR CHARINDEX('~97024~',[prodKatID]) > 0 OR CHARINDEX('~97023~',[prodKatID]) > 0 OR CHARINDEX('~94951~',[prodKatID]) > 0 OR CHARINDEX('~94950~',[prodKatID]) > 0 OR CHARINDEX('~536~',[prodKatID]) > 0 )