drew.allen (11/16/2011)

---

Actually, as Jeff Moden points out in his excellent article Solving the Running Total and Ordinal Rank Problems (Rewritten)[/url] the whole reason that the quirky update works at all...

Why not have one row in the DeptShopped table for each customer who has shopped in each department? That's the tried and trusted way of doing it, and it...

That UPDATE statement won't loop through the rows in @Dept - it will use the first row in @Depts that it finds and then stop. That explains why the...

OK, I see - severity up to 10 is information or warning; 11 or greater is error. Have you tried an onInformation event handler instead? If that doesn't...

If the stored procedure is raising an error, would the OnError event handler work, instead of OnWarning?

John

Does the column(s) indexed in index ID 7 contain any NULLs? This would explain the difference, although it doesn't explain why it disappears after you rebuild the index.

John

Can you show us the exact queries you're running to get the counts, please?

Thanks

John

If it's a datetime column, won't this work?

CONVERT(datetime,MyCol,120)

John

If you think that would be useful, then by all means add it. But I wouldn't use third-party add-ins to achieve something that can be done with out-of-the-box functionality.

John

If you create your staging table with an identity column, you can do something like this:

INSERT INTO Table1 (colA, colB, colC,...)

SELECT (colA, colB, colC,...)

FROM MyStagingTable

WHERE IDCol <= 500

INSERT INTO Table2...

I don't know, because you haven't said on what criteria the record set will be split. There are transformations you may be able to use, such as the Conditional...

Import all the records into a staging table, then use whatever logic is necessary to move the first 500 records to one table and the rest to the other.

John

What goes into the parentheses at the end of the INSERT line is a list of the columns into which the rows will be inserted. If the columns in...

SELECT INTO creates a new table. If you want to insert into an existing table, do it like this:

INSERT INTO Table1 (ColA, ColB, ...)

SELECT ColA, ColB, ...

FROM Table2

John

Two things you might consider are converting your scalar-value "Get" functions to table-value functions, and omitting the ORDER BY and having your presentation layer do the sorting instead.

John