Good point Michael, I'll definiately look into your suggestion.

Thanks for the dilligence John, I'll explore your suggestion.

Hi John, unfortunately when we began using reporting services for sql we went ahead without documenting our reports as we created them, now 60 reports later we want to start...

Hi Ken, just a follow up in case other readers want to use this. For the @List variable to work in a where clause I had to create a...

Thanks Ken, worked perfectly. I had actually tried that myself but didnt use enough quotes. Lesson learned.

Hello gents, that's pretty much what we've done using excel find and replace. Thanks again.

Hello all and thanks for responding, I wasn't able to get this to work for me. We are building a table that contains all our query's on our reporting...

Thanks, gents, both the substing and left functions with the where condition worked for me.

Thanks Matt, I'll play around with the parameter input into a sp. But you're probably right an asp web form is probably the way to go.

David, yes the code works great! Thanks to everyone who took the time to help me with this. It was a good learning experience for me, and now...

Yes, I definately see, and it makes a lot of sense in terms of making it easier for people helping me to help me, also having done that it also...

Hi Jeff,

I originally didn't want to come right out and ask for someone to write my query for me, so I apologize if I was vague or "plinking" to begin...

Ok thanks Jeff, I'm reading the article you posted now and will reply as instructed.

Hello everyone, I really appreciate your help with this. I'm starting to think I'm in the wrong job. I've tried all suggestions and can't get them to work...

Thanks Adam,

Although I've read up on them a bit, I've never used a cursor before. I'll give it a try and let you know how it goes.