Typos in the text:

Four columns of data (not three) numbered 0-3; text says 10000 rows imported, screenshot shows 100000.

Not up to SSC's usual standard

Don't worry about being late for your weeding anniversary - the garden will be overgrown already! 😀

Great article though.

Heresy!

How can you say such things?

This tells me all I need to know: I don't understand so partitioning is not for me.:unsure:

Steve

Certificates are one way. But too often they are completely ignored by information professionals who really ought to know better (I'm pointing the finger at the British NHS).

Peace of cake????!!!

Sorry, I stopped right there.

Unless I am mistaken the source and target table names have been transposed within the article.

Apart from that: good article!

Thanks Wesley,

That certainly makes it easier to parse

😀

I'm getting a different error:

Update TestTable

Set ColRowNo = RowNo

From

(

????Select RowID, Row_Number() Over (Partition By Col1 Order by RowID) RowNo From TestTable

) B Where TestTable.RowID = B.RowID

;

gives this:

Msg 102,...

david_wendelken (6/16/2008)

---

There is no substitute for correctly understanding the business requirements. There is no subsitute for a design that correctly implements those requirements. There is no substitute for...

Yeah

That should never happen.

But of course it has in the past. 🙁

smunson (6/11/2008)

---

Please don't think that I'm making you responsible for a data collection faillure - most of us are put into positions of having to make do with less than...

smunson (6/10/2008)

---

While this appears to be solved, I was just wondering why use CONVERT or CAST? I would think that if you already have DateTime data types, why...

This returns a syntax error:

but a small amendment and slight repositioning of the parentheses sorted that:

SELECT CONVERT(DateTime, [ARRIVAL_DATE], 120) +...

Thanks Robert

This makes sense to me. 🙂