A CTE is nothing more than a "derived table" just like a subquery in a FROM clause would be. The big differences between itself and a "derived table" is...

Heh... spot on, actually. Sergiy is absolutely correct.

So change the update code to insert code and change the join to be a WHERE NOT EXISTS or other exclusionary join.

I do this same thing with a lot of mixed record files... they're usually fixed width instead of delimited, though. Anyway, I bring the whole file in as a...

... and, with SQL Server 2000, we end up with this...

DBCC UPDATEUSAGE (0)

SELECT so.Name AS TableName,

si.Rows AS [Rows]

...

So... hedging a bet against BOL and changing the code to something a bit more conventional, we end up with this...

DBCC UPDATEUSAGE (0)

SELECT so.Name AS TableName,

...

I've found that most of the books are simply a slightly longer, more expensive regurgitation of Books Online. Most of the books I've read don't explain things like the...

It can't happen unless the trigger has code in it telling it to ignore the inserts from WinCC. Recommend you post the trigger code.

Heh... hey! I need to know... does brother Darth have to take off the Chevy look-alike to eat?

Jeffrey Williams (8/10/2008)

---

For SQL Server 2005 and greater - there is no need to cursor at all. Just use the DMV sys.dm_db_partition_stats as in the following:

Select object_schema_name(object_id) As...

Also, have 0x100 as the row identifier for both the teacher and the test page does not seem logical... are you sure about that?

It would be helpful if you posted the CREATE statements for the tables you're trying to target... 😉

Aye... that's more like it.

The only thing I'd be worried about is... do you need to update usage (DBCC UPDATEUSAGE) as you do in SQL Server 2000 to get accurate...

Not sure a recursive CTE is needed for this simple update problem... it appears that the prototype ID is simply being updated for each occurance in the temp table...

Sainath,

Thank you...

Howdy,

Since you're brand new, please take the time to read and follow the suggestions in the link in my signature... it'll help you get very high quality help much faster....