digitalox (3/13/2014)

---

this sql is really ugly but if you execute it on the table described above it will give the dupes combined into one row for each.

using it you insert...

hisakimatama (3/13/2014)

---

I'll have a shot at the UPDATE part of this:

This will generate a test version of your table, for a proof-of-concept test, and make the UPDATE by generating a...

Thanks guys - I'm going to experiment with both of these queries today, I'll obviously report back on their success (feel the confidence 😀 )

And thanks for taking the time...

Thanks for the tip Jeff, that shaves a few more seconds off (I *think* my tally table is already unit based).

If I can just workout how to use synonyms to...

Sorry about the delay in replying chaps, work got a little hectic.

Hi Brandie, the only real reason if I'm honest is my lack of knowledge/training - that or a MERGE...

That looks incredibly 'clean' Jeff - I'll test this out later today

Thank you all for your advice and hard work! I gave a poorly worded problem and a poorly...

Aiello DBA (9/15/2011)

---

I miss understand the problem. I think that next execution try to read, but it's the app isn it? well the best option is MERGE and you will...

Aiello DBA (9/15/2011)

---

use merge statment, it's the best option. In other hand just serialize querys in steps, soo a job don't invoque next execution until finish one.

-

Lic. Andrés M. Aiello

DBA...

The truncate and changing the union all to multiple selects has halved the time this takes to run; it's now below one minute so thank you very much for the...

You won't believe how complicated (or maybe bloated) this neat little query has become - which leads me to ask further questions, particularly to help performance..

I've found the dateadd method...

Chaps, that worked beautifully, the tally table seems ingenious in it's simplicity - there will be other uses for that I'm sure!

I did think of one small addition - but...

Thank you very much Gentlemen I really appreciate your efforts.

Mark, I'll chase down the article on creating a Tally table (and keep fingers crossed it is easy enough for an...