Forum Replies Created

Viewing 9 posts - 1 through 9 (of 9 total)

  • RE: group by continual

    Great. I realized that this is not really about CTE's. It is a smart way of taking advantage of the number sequences. Thanks!

  • RE: group by continual

    You are right to assume I have an older version (2005 🙁 ). However, I guess I was too short in my sample as this is not the result...

  • RE: Delete takes a long time

    Is TransactionID independent from AccountID? Or do you need to include AccountID to uniquely identify a transaction?

    AccountID is needed to uniquely identify a transaction.

    How common is the use of the...

  • RE: Delete takes a long time

    You could bulk insert into a staging table and insert the missing transactions.

    Sorry wasn't clear, I already bulk insert from csv into a staging table, then I do delete on...

  • RE: Recursive family, but how?

    One more note, my data is not normalized. I discovered the scenario below which causes and endless recursion. I can clean it up but just thought I would...

  • RE: Recursive family, but how?

    This is great!! Thanks.

    Just one note, this part of the code below I think always resolves as true and I am not sure what it was supposed to do:

    (

    A.relatedTo is...

  • RE: maximum rows without duplication

    Your code works for this particuar set of rows. If I add two more rows to my table, duplicates appear:

    select 18,19,'m' union all <--- new row

    select 18,20,'n' union all...

  • RE: maximum rows without duplication

    Sorry for not being clear.

    None of the above. It is not and/or/union.

    In my resultset I need all rows to have unique values in column a. There cannot be...

  • RE: maximum rows without duplication

    your query returns rows g and h which both have 12 in column b.

    Thanks for the speedy reply though!

Viewing 9 posts - 1 through 9 (of 9 total)