Post reply

Multiple Database record purge to 1 datbase table with x column- Query required

  • December 17, 2019 at 1:10 pm

    #3708442

    I have Multiple databases ,All the databases same table data is migrating into 1 database same table with column X and those are differentaited with value in X column ...

     

    eg:

    A database - XYZ - 200 rows

    B database -XYZ - 300 rows

    C database -XYZ - 400 rows

    like N databases in same server ....Migrated to F database ...

    F database -XYZ - 900 rows  with column - Value (Adatabase(123);Bdatabase(234);Cdatabase(345))...

    I need a query to run Count Validation ....

     

     

     

     

     

     

     

     

     

     

  • December 17, 2019 at 1:30 pm

    #3708447

    If you want a working query, please provide DDL, sample data (in the form of INSERT statements) and desired results (based on your sample data).

    You'll probably have to provide a more verbose explanation too, as I can't understand your requirement.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

You must be logged in to reply to this topic. Login to reply