How can we help you today? How can we help you today?

SQL Server solution

Starting from the TABLE1 source table that contains consecutive value groups (which can reach hundreds of thousands of items) in the Serie field, we need to get to the TABLE2 table that contains the consecutive value groups, but without another grouping field in the TABLE1 table . I have implemented several solutions (recursive CTE, Cursor FETCH-ing, Self-Join on TABLE1, ... ) but none is fast enough. It's about hundreds of thousands of articles ... maybe more.
ygrr1w20pii5.png

Indebted.
biweb
0

Comments

3 comments

Sort by
  • Eddie D
    Hi, thank you for your forum post.

    I am sorry, I am confused. What does the information in your post has in regards to Redgate's SQL Test application?
    Eddie D
    0
  • biweb
    I just asked for help. But in the meantime I have found the solution sought, worthy of an architect. I apologize for inappropriateness.
    Best regards.
    biweb
    0
  • Eddie D
    Hi, thank you for your reply and good to read that you found a solution to your question.

    Unfortunately you posted your question in the SQL Test forum. If you have any questions, that are not Redgate product specific, in the future please post in the general forum available via this link:
    https://forum.red-gate.com/categories/general-forum

    Many Thanks
    Eddie

    Eddie D
    0

Add comment

Please sign in to leave a comment.