Forum Replies Created

Viewing 3 posts - 31 through 34 (of 34 total)

  • RE: Trace Updated records

    Hi

    CDC can can work as well as trigger. If you want to create like a manual system I recommend using something like this

    Create a Change table in your database lets...

    --------------------------------------------------------------------------------------------------------------------------------------------------------
    To some it may look best but to others it might be the worst, but then again to some it might be the worst but to others the best.
    http://www.sql-sa.co.za

    August 1, 2014 at 4:26 pm

    #1734554

  • RE: Using MERGE with loop

    Hi

    So i am assuming that your new table contains the id and the max time of the corresponding id in the original table.

    The problem with the while loop that...

    --------------------------------------------------------------------------------------------------------------------------------------------------------
    To some it may look best but to others it might be the worst, but then again to some it might be the worst but to others the best.
    http://www.sql-sa.co.za

    August 1, 2014 at 3:53 pm

    #1734549

  • RE: select statement

    Hi

    Please find the needed Pivot query below

    Create Table #tblPersonTask

    (

    DayNmchar(3),

    Personvarchar(20),

    Tasksmallint

    )

    insert into #tblPersonTask

    select 'sun', 'Jhon', 1 union all

    select 'sun', 'Smith', 1 union all

    select 'sun', 'Dan', 2 union all

    select 'mon', 'Smith', 2...

    --------------------------------------------------------------------------------------------------------------------------------------------------------
    To some it may look best but to others it might be the worst, but then again to some it might be the worst but to others the best.
    http://www.sql-sa.co.za

    August 1, 2014 at 2:04 pm

    #1734538

Viewing 3 posts - 31 through 34 (of 34 total)