You can avoid CTE by doing this to incorporate the row_number function in the where clause

select * from

(select ROW_NUMBER()OVER (ORDER BY column_order_by) as RowNbr,col_1,col_2

from inner_table with(nolock)) as outer_table

where RowNbr...

Step 1

Open SQL server --> Management --> Database Mail --> use the wizard to set up your SMTP server and database email profile [your DB email profile]

Step 2

Make sure you...

try along these lines .....

select * from Tname

where (Tcol1 = @X OR Tcol1 is null)

AND (Tcol2 = @Y OR Tcol2 is null)

---- OR -----

select * from Tname

where Tcol1...