Not quite the same (0's not 1's), but maybe this snip from BOL can shed some light? (particularly the last bit) This suggests you're using either the -V parameter, or...

Nope, no trim in 2005 either, just ltrim and rtrim

/Kenneth

I'm sure there's no doubt about it being a demo.

I was just taking the opportunity to plug for ambigous vs nonambigous dateformats.

There's questions and confusion almost daily about dates, and...

Never given it much thought before, but come to think of it, I'd imagine that developers in general probably don't script/code much against the system procs - they are more...

Is this a real live example?

Select Fullname, Start_Date from tSearch where SearchGUID='BF33FA65-D558-43F5-0F0D20AB0028'

If it is, then the guid is too short to be a guid.

Try with something like...

This doesn't look too good.

For your first question - yes it is true. There is a reason that sp_OACreate permissions is set to...

It works fine, however do try out the difference when the language changes.

set language british

set language us_english

...just wanted to point out that it's important to provide dates in a 'failsafe'...

The tablescan is one obvious target for tuning. Check for appropriate indexing.

Another area is temptables. Are they necessary? .. really?

Hashjoins may be 'slow', but this is really an 'it depends'...

If you have a query that produces a list of ranges and sums, like so:

select   daterange, sum(amt) as sumValue

from     myTable

group by daterange

..you can make a virtual table of it,...

Why do you 'need' that? This is not what functions is ment to do.

Use a procedure instead, if possible, or rethink your strategy if you find yoursefl in a...

Since this seems to be more than one step

(find the rows, send mail, update sent to 1 for those (successfully(?) sent)

just be careful not to miss any in your 'batch'...

You're absolutely correct, a not exists construct will also produce the same (correct) result for the question 'which rows in A doesn't exist in B'.

There are truly many ways to skin a...

You have three different datecolumns in there... Does all three have something to do with the age?

If datecreated is what signifies the one-two hour limit, then this is one way...

Coffee and fresh air can make wonders....

David, you were right. It struck me that my inner query picks out all the latest posts from each user within each thread, not...

No..?

Why not?

I think it will

(adding the assumption here that DateEntered is a datetime so that it's...