Thanks - you've confirmed my thoughts!

I've managed to get something like

select * from customers where (stage & intValue) > 0

where the intValue is the user chosen values of the...

Great thanks.

It aint pretty but I guess it is what it is! A lot better than 15 x the code.

Cheers again.

Yeah sorry... a parameter will be passed into the proc giving the column name (or a look up value if required - as it hasn't been written yet!).

So lets assume...

OK Thanks!

Here's a more realistic snippet (you'll have to work around the temp table!):

SELECT cc.vchrCustomer, tintWeekNo,dteWeekEndSubmit, MYCOLUMN , s.vchrFirst_name + ' ' + s.vchrSurname, cc.vchrFile_number

FROM tbl_bpm_customer_collection cc

INNER JOIN #staff s

ON

s.vchrFile_Number...

The easiest way is to use a DTS which in itself is a fairly large area of knowledge but the task you want should be fairly straight forward. Lots of...

So.... given the real world example where my proc is actually considerably longer than the simple select shown, I am going to have to replicate the code 15 times?.. or...