Been fooling with this ever since my last post and this may be more complicated than it need be but it will handle input such as

1. 'ab 2/2/2009 Adjustment...

This may set your thinking onto the correct track

DECLARE @Something VARCHAR(max)

SET @Something = '2/2/2009 Adjustment made...'

SELECT SUBSTRING(@Something,1,CHARINDEX(' ', LTRIM(@Something))-1) AS 'Date'

Which will return 2/2/2009 - now the weakness of what...

Is this what you are looking for?

SELECT entry AS ' ', SUM(Entryid) AS ' ' FROM foobarVille GROUP BY entry

Use Books On Line:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/ac7e4c7c-e52f-4883-8f3c-9336cc77a9c8.htm

And it will show you how to handle auto-statistics creation and updatting. Both Create Auto statistics and update auto statistic is by defaul set to...

Go to this support page:

http://support.microsoft.com/kb/827422

Note If you are connecting to a named instance of SQL Server, make sure that you are running MDAC 2.6 or later on your computer. Earlier...

If memory serves me correctly .............

Is that an sp_somename (underscore after the sp)....

David Todd-242471

What I'm saying is that in mentioning hour, minute, second, you are focusing the readers attention on those values, and away from what you've later clarified as the intent...

To be honest with you.... I would have picked...

honza.mf

Oops sorry forgot to mention that I was a engineering graduate, class of 1954. Prior to college my high school physics course was taught in German (instructor spoke...

Now now ... the answer to you is that depends...

Having recently gotten my brains beat out, my integrity questioned, my intelligence derided and other wise vilified (Refer to the QOD 11/17/2009 forum). I am greatly surprised that...

David Todd-242471

Well BitBucket, .

I'm tired of playing the qod game with questions like this. I want to be tested on SQL, not on smarmy tricky questions that depend on a...

Bold emphasis entered by this poster.

Lynn Pettis

I learned quite a bit from the discussion that ensued, some of it not directly related to the question. It is from the...

Just a suggestion have you run these queries in SSMS and displayed the actual / estimated execution plans?. And since your request is for improving performance please post following...

No do not think that is appropriate, but...