Forum Replies Created

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

  • RE: Set-based query

    David

    Brilliant - Looks to be doing exactly what I need but it's gonna take me a while to work out what's going on !!

    Thx again and to everyone else for your...

    January 25, 2006 at 3:37 am

    #616853

  • RE: Set-based query

    Oops - sorry should read (modifications in italics)

    select n.num, m.rfreq, m.pfreq --,

    --DATEADD(mm, m.rfreq, m2.StartDate) -- JOIN m2 returned no rows

    -- DATEADD(mm, m.rfreq, (SELECT StartDate FROM tblmain WHERE rfreq = m.rfreq AND...

    January 24, 2006 at 5:26 am

    #616623

  • RE: Set-based query

    Thx KH - solving one thing leads to another prob

    tblMain has an additional column startdate which I need to populate with the startdate from...

    January 24, 2006 at 4:52 am

    #616619

  • RE: Set-based query

    KH/Jesper/Jeff

     

    Thanks Guys for the response

    KH's code is great for up to 7 but the practical Max will be a couple of hundred - Jesper's additional code re the numbers table...

    January 23, 2006 at 7:22 am

    #616412

  • RE: Worst Practice - Not Qualifying Objects With The Owner

    Excellent article but I note the author doesn't follow his own advice in the example code in some of his other articles eg SQL Injection etc !!

    November 17, 2005 at 8:37 am

    #604441

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