Do you think there is a performance benefit to using the Tally table?

cengland0 (11/17/2009)

---

What about daylight savings time? Getdate() accounts for that because the server time changes. Does the UTC time take into account? I doubt it. So...

Lynn Pettis (11/17/2009)

---

I GOT it!

The query should have been written like this instead of as four separate queries:

SELECT

DATEADD(day, -1, GETDATE()),DATENAME (dw ,DATEADD(day, -1, GETDATE()) ),

...

Lynn Pettis (11/17/2009)

---

Okay, I give up. No one is really paying attention to the concept that the question was trying to bring out. Everyone is concentrating on the...

This was absolutely perfect!

Thanks for the help. You really saved my project!

Very cool! This looks really awesome -- I'm still playing with integrating it into my code.

Thanks so much for your help 🙂

Basically the key thing here is the sequencing.

Every child node, whether it is a department or employee, is given a sequence within its parent .

An employee can come before...

And yes, the real data has nothing to do with employees or departments.

It is just an analogy since I can not post the real data.

This is NOT a homework assignment.

It is a multi-million dollar project on an extremely tight deadline.:w00t:

I have written many recursive CTEs in the past.

The reason I am having difficulty with...

Thanks so much to both of you for your help.

In the end I neded to create a GUID field on my Sections table for other reasons, so I can use...

Paul White (8/8/2009)

---

Jeff Moden (8/6/2009)

---

Darned sorry about that, Goldie. I answered too quickly.

You would think that Microsoft would allow you to return data from the "from_table_name" on an insert...

That will give me the IDs of the newly inserted records.

But how do I know which one of the original records they are a copy of?

Why bother with the database at all then? Just store the XML directly on the disk? 😀

Seriously though, in today's day and age physical space is not usually an issue.

And,...

My objection is...

Eralper (7/10/2009)

---

Hello Goldie,

Do you mean using the XML logic or placing it into a udf causes the performance decrease?

Using the XML inline is a little bit difficult for whom do...