Post reply

SQL Dependency or Change data capture

  • June 30, 2010 at 6:12 am

    #1186994

    replication can be an alternative

    Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.

  • June 30, 2010 at 6:23 am

    #1187003

    why not use a VIEW that is nothing more than a UNION ALL of the three tables in question?

    then the view will never be out of sync, and will have all the data you need at the instant you query it.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • July 6, 2010 at 4:22 am

    #1189004

    Lowell (6/30/2010)

    why not use a VIEW that is nothing more than a UNION ALL of the three tables in question?

    or you might need to use JOINs to get related data into VIEW.

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Viewing 3 posts - 1 through 4 (of 4 total)

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