Forum Replies Created

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

  • RE: Getting the most recent record

    Hmm, got your point.

    I tested against a database with 339642 records and got 18302 records back in 1 second using the proposed query against 5 seconds with my own proposed...

    November 13, 2006 at 3:20 am

    #671280

  • RE: Getting the most recent record

    OK, it is Monday morning, so I forgot something to declare..

     

    SELECT          t.PupilID,...

    November 13, 2006 at 2:16 am

    #671276

  • RE: Getting the most recent record

    You could also use this one:

     

    SELECT          t.PupilID,

    November 13, 2006 at 2:12 am

    #671274

  • RE: Last Saturday in month

    The following code makes it possible to get the last weekday for any year and month selected. You can fit this code into a stored procedure with month and year...

    November 2, 2005 at 6:30 am

    #601805

  • RE: summing totals in a query

    Try this select statement:

    Select (((select count(*) from A) + (select count(*) from B) + (select count(*) from C) + (select count(*) from D)) - (select count(*) from Klanten)) as Finalcount

    February 27, 2004 at 5:38 am

    #496151

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