Bum!

Thanks, everyone, for your contributions, but no matter what I try, I cant get this to run in an acceptable time and I've run out of both time and patience.

Here's...

Chris:

Thanks.

I eclared the new variable and ran it (24 secs) but it didn't erturn any data. Was there anything else I needed to do?

Cheers.

[EDIT]

"declared", even. lol

First up. thanks for the help.

I hadn't actually considered the possibility that anyone would select "(All)" and something else. Should have seen that.

My Tsql knowledge is rather scant when it...

Chirag (4/2/2009)

---

First why do you want to do this.

You would need to use dynamic queries to do this. You can pass the columns and their values as a string in...