Viewing 15 posts - 2,296 through 2,310 (of 3,221 total)
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...
November 20, 2009 at 2:31 pm
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...
November 20, 2009 at 1:02 pm
Is this what you are looking for?
SELECT entry AS ' ', SUM(Entryid) AS ' ' FROM foobarVille GROUP BY entry
November 20, 2009 at 11:57 am
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...
November 20, 2009 at 11:49 am
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...
November 19, 2009 at 5:08 pm
as the company I currently work at insists on prefixing all their stored procedures with "sp"...
If memory serves me correctly .............
Is that an sp_somename (underscore after the sp)....
November 19, 2009 at 4:08 pm
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...
November 19, 2009 at 3:57 pm
David Todd-242471
What does this query output?
select datediff( second, getdate(), getutcdate())
Answers
a -46800
b -41000
... etc
z difference in seconds between my time and utc time.
To be honest with you.... I would have picked...
November 19, 2009 at 3:14 pm
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...
November 19, 2009 at 2:44 pm
David Todd-242471
You confused it by attempting to be overly exact and asking for hour minute and second, and they are not.
Now now ... the answer to you is that depends...
November 19, 2009 at 2:27 pm
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...
November 19, 2009 at 12:07 pm
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...
November 19, 2009 at 8:20 am
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...
November 18, 2009 at 2:49 pm
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...
November 18, 2009 at 1:01 pm
david.wright-948385
There's the answer then - we should restrict comments on the veracity of QOD to people who have submitted a QOD themselves.
No do not think that is appropriate, but...
November 17, 2009 at 9:36 am
Viewing 15 posts - 2,296 through 2,310 (of 3,221 total)