I removed the coma and it works fine

thanx alot your a genius

The code you provided results in the following error:

Incorrect syntax near the keyword 'Select'.

Refering to the second select statement

having is in there by mistake

having = where

I am sending a variable with a value of either 100, 300, 500, 700, 900 or 1000 to the stored procedure

if the variable @Range = 100 then I want it...