Forum Replies Created

Viewing 2 posts - 16 through 17 (of 17 total)

  • RE: Multiple Records on one page

    Right, that gets me the Top 5 records.  Simple.  Now, how does one go about displaying the records across the page in columns?

    My solution is 5 data sets, With a...

  • RE: Compare 2 databases

    I have done something like this:

    Insert INTO TrustChecks (

      CheckNumber,

      Amount,

      ClearedDate,

      ClearedStatus)

     SELECT

      ClearedChecks.CheckNumber,

      ClearedChecks.Amount,

      ClearedChecks.CheckDate,

      'C'

      FROM ClearedChecks

      Left Join TrustChecks

      On TrustChecks.CheckNumber = ClearedChecks.CheckNumber

      where TrustChecks.CheckNumber is NULL

    Only inserts the entries from...

Viewing 2 posts - 16 through 17 (of 17 total)