jaffrey (10/16/2010)

So far the query works fine as long as the constraints,triggers,procedures...

I would use the "quirky update" method.

Disclaimer:

DO NOT USE the code

until you've read Jeff's article[/url] and the related discussion.

DO NOT USE the code

until you...

Lowell (10/16/2010)

a single record? no...the TRUNCATE TABLE [TABLENAME] command will delete all records in a table. so that deletes...

WayneS (10/15/2010)

Specifically, Do ALL tables that reference table konten have indexes on their foreign key...

Do you have to store it on the disk?

Why not storing the xml results in a separate table (file name in one column, xml data in a xml column, one...

Did you try the WITH ROLLUP operator?

If that doesn't help you, please provide table def and some sample data together wit your expected result so we have something to test...

Would you mind telling us your expected result based on your sample data?

It's probably a lot easier to understand than your current description...

Ok, here's the recursive CTE with a triangular join:

Side note: I changed my version slightly to cover different values for holeid.

If you compare the performance you'll see that the quirky...

@Chrissy321:

You're not using SQL2000, are you? (fingers crossed)

If you're still at SQL 2000, it'll require "slightly more work".

One option is to use a stored procedure that calls itself. An example...

Here's what I came up with:

-- sample data setup

DECLARE @tbl TABLE

(

HOLEID VARCHAR(30),

DFROM DEC(8,2),

DTO DEC(8,2)

)

INSERT INTO @tbl

SELECT 'TEST', 104.45 , 110.43 UNION ALL

SELECT 'TEST',...

Something like this?

;

WITH CTE (id, Parent_ID, [LEVEL]) -- recursive CTE

AS

(

SELECT h.id, h.Parent_ID, 0 AS LEVEL -- get all id's

FROM History h

UNION ALL

...

Question: How many false statements can you find in his reply?...

E-book or wife?

There are places...

As usual: It depends. 😀

There is simply not enough information available.

For instance:

Do you need to preserve order of operations?

In what frequency do you receive new messages (each SEND...

You might want to have a look at the CrossTab article referenced in my signature to see an alternative to PIVOT.

I find it easier to remember and it seems to...