Match Comma Separated value(1,2,10) of field with int in sql 1 min read Sql server Match Comma Separated value(1,2,10) of field with int in sql Mahesh Javiya 14 years ago select * from STYLE_MST u where 1=1 ‘,’+replace(DmndRate_Qly, ‘ ‘, ”)+’,’ Like ‘%,2,%’... Read More
Get a Row Number in sql 1 min read Sql server Get a Row Number in sql Mahesh Javiya 14 years ago ROW_NUMBER() OVER(ORDER BY SalesYTD DESC) AS ‘Row Number’... Read More
