Ok, thanks Farrell I understand.

Thanks to everyone, their help is much appreciated.

Kevin.

Hello all, sorry joined in the discussions, I've been away all weekend.

In reply to Farrell Keough: The application should recieve ALL and determine what to present.  That solves any problems with...

Thank you Shawn. Much appreciated.

sukhoi971, i was able to log into your website by keying my username and password both as

' or ''='

The problem is that you are not sanitizing your user input in...

I just discovered that I could do that! I took my trigger and put it into the QA as if it was a series of queries I was trying to...

The table is a list of status's relating to a job. Note that a job can be split into several stages.

When a record is inserted into this table I need to update or...

Yes no problem. As I mentioned everything up to the part called "Find out how many stages this job has" costs nothing and is comment in. Everything after the query in...

I recently saw your article at http://www.orcsweb.com/articles/sendmailsql.aspx and it solved my problem perfectly.

Just wanted to say thanks.

Thanks, everyone.

I wasn't really looking for someone to code me anything up. It does work and return the right results. I just wanted either a) re-assurance that this was not...

Below is the SP in question. The number of rows returned won't ever by higher than 100 and thats high estimate.

Basically the only thing I'm doing here is changing the...

Great link, cchitanu.

Less space used sounds good to me.

Can I take it that you ran no other procedure to recover this space?

This is a pretty good article by G Vijayakumar, published right here on sql server central!

http://www.sqlservercentral.com/columnists/gvijayakumar/executionplans.asp

A good place to start.

This is really wierd. I tried the CONVERT version of the query again and it's still not working! I know it should - I thought I was just being a...

Thanks for getting back so quickly SQLBill!

I'd given those two solutions a try already, though.

The first one still misses out the 05/04/2004 records.

The second one gets screwed up over the...