You're right, I had thought of that...

I would have...

For even cleaner code, your method needs a 0-based tally table. This is easily accomplished by adding -1 to row_number(). Your code then looks like this:

DECLARE @StartDATE DATETIME;

SET @StartDATE =...

Instead of doing a where count(*) > 1 it is often faster to check for duplicates by looking for any rows for which you can find at least one other...

Like Dave suggested, use row_number(), then add a little math, a crosstab and some string manipulation...

declare @tbl table (

EmpCode int not null,

ShiftDateTime datetime not...

Let's throw in some "modern" commands (not that they do anything good to the performance).

SELECT *

FROM @Form

except

SELECT *

FROM @Form

WHERE FromID = 3 OR FromID = 4

Note to OP:...

Neither pivot nor cross-tab. Just a simple trick using for xml path(). Does any length of texts (up to varchar(max) - 1), and any number of rows.

declare @tbl table (

...

Isn't the essence of your problem that you are trying to calculate off of percentages of a volume per shipment? In other words, shouldn't you store absolute quantities of the...

In this posting I presented an example on how to use a cte as the target for merge. The cte can be used to filter the rows to act upon...

No, that is not the merge command OP is describing. OP describes some sort of 2-way merge, updating the first table when there is a match, inserting missing records from...

Without the internals of those views, their underlying tables and some test data we can not do much for you. Please provide some more details and people here will be...

And if you must do the formatting in T-SQL, you could replace the pivot by a crosstab. Then you can use max(), which allows for character strings to be handled,...

I, for one, would be very interested to see a nested set implementation explained. I've read a lot about it and think it looks very promising, but I so far...

Have a read at: http://msdn.microsoft.com/en-us/library/ms176057.aspx

An excerpt of this page:

"DBCC CHECKIDENT ( table_name, RESEED, new_reseed_value )

Current identity value is set to the new_reseed_value.

If no rows have been inserted into the...

Sean Lange (8/30/2011)