Yay!

Jack you are a complete and utter star!

Thank you so much 😀

*Lil Ms has to restrain herself from jumping around excitedly* :hehe:

Ah, okay. Brilliant! That's a start at least.

I'm running SQL reports 9x

Now a friend of mine who is a bit of a SQL reports guru (well better than me...

Well it's a bit complicated.

I installed VS.net 2005.

Then a while later I installed SQL express.

Then I installed SQL reporting services from an MSDN CD that said it is...

Bah humbug 😛

Thanks though!

Grant is there a way to script that rename/drop/create generically rather than having to do a separate script for each of my 25 tables?

Probably, but I'm not allowed to do that, my DBA generally calls the shots and basically said that he's going to make all the changes to the audit tables by...

Hi Roy,

Could I ask why it's better to use the CASE statment?

Sorry, my bad! It was still running another IF statement in my sproc...

Thanks Ryan, that's brilliant 😎

I'm not sure I explained myself properly...

If @SiteNumber = -1 then I want to return all records but if @SiteNumber has a value of one or greater then I want...

As I said in my earlier post, I was having a problem with .NET not returning anything back into my dataset despite the fact that the sproc was retrieving values...

Thanks for your replies guys.

The lack of output problem was because I was testing it under my windows account in SQL Enterprise Manager (or whatever it's called in 2k5) but...