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...

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 ...

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...

Steve Jones - SSC Editor (11/24/2012)

---

I'm back, and it looks like things were quiet. Other than Jason's humorous pictures and Jeff's attempt to get the thread into a serious discussion...

Thanks for a good question to start the week.

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...

sqlnaive (11/22/2012)

---

May your stuffing be tasty

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...

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...

SQLRNNR (11/20/2012)

---

Did I?

Are you really sure about that?

What if I gave you Steve's GPS coordinates so...

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...

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,...

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 ?

Lowell (11/16/2012)

---

here's a worst kept secret:

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 ...

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)

...

Thanks for a good back to basics question ...