Viewing 15 posts - 211 through 225 (of 3,221 total)
Good question .... as one of the main objectives of the QOD is to TEACH people, the answers so far show that your question has more than fullfilled that objective.
Correct...
November 29, 2012 at 7:00 am
For what it is worth ... getting same results as you -- that is just that page coming up saying nothing could be found.
I tested Spackle, Moden, duplicates ...
November 27, 2012 at 11:43 am
Here is a method that you might want to test to verify it does what you require, and if it does test AGAIN and AGAIN to be certain, before attempting...
November 26, 2012 at 9:35 am
Steve Jones - SSC Editor (11/24/2012)
November 25, 2012 at 8:30 am
Thanks for a good question to start the week.
November 25, 2012 at 8:08 am
Like Luis Cazares - has said
But here is some T-SQL that you should be able follow and experiment with (USING tempdb of course) and with modifications make it the...
November 22, 2012 at 4:11 pm
sqlnaive (11/22/2012)
May your turkey plump,
May your potatoes and gravy
have nary a lump.
May your yams be delicious
and your pies take the prize,
and may your Thanksgiving dinner
stay off...
November 22, 2012 at 6:31 am
Agreed the 8K splitter refrenced by Luis Cazares is great, however for something as simple as your needs, you might want to try the following along with the 8K splitter...
November 21, 2012 at 10:34 am
SQLRNNR (11/20/2012)
The Dixie Flatline (11/20/2012)
You took all of the joy out of it, Jason. 🙁
Did I?
Are you really sure about that?
What if I gave you Steve's GPS coordinates so...
November 20, 2012 at 2:25 pm
With the information you have posted, it is difficult to say anything other than "It depends", which is NOT a suitable answer to your question. Now
a. Any other...
November 19, 2012 at 8:11 pm
You could try something like:
|
CREATE TABLE #T(Date_Stamp DATETIME,KW1 DECIMAL(5,1), KW2 DECIMAL(5,1))
INSERT INTO #T
SELECT '12/10/2010', 5.3, 3.1 UNION ALL
SELECT '12/10/2010', 5.3, 3.1 UNION ALL
SELECT '12/9/2010', 4, 2 UNION ALL
SELECT '12/8/2010', 3,...
November 18, 2012 at 9:35 pm
Unfortunately the cited reference for the correct answers does NOT or I could not find the "tie breaking rule" in that reference. Any one have better luck ?
November 18, 2012 at 6:03 am
Lowell (11/16/2012)
for any question that is not today's question of the day,
the answer is in the newsletters:
so if you were looking at the QOTD for ...
November 16, 2012 at 5:36 pm
Is this what you need ? Look up the LEFT function in BOL Books On Line
CREATE TABLE #T(Cola VARCHAR(6),Colb CHAR(1))
INSERT INTO #T(Cola,colb)
...
November 14, 2012 at 8:52 pm
Viewing 15 posts - 211 through 225 (of 3,221 total)