Forum Replies Created

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

  • RE: Concatenate in SQL

    Opted for this in the end:

    SELECT AccRef, SPMNo, WKNo, CASE WHEN SPMNo < 10 THEN '0' + obw2.SPMNo ELSE SPMNo END AS SPMNo, CASE WHEN [WKNo] < 10 THEN '0'...

    January 4, 2013 at 6:20 am

    #1573720

  • RE: Function taking long time

    We had issues with Functions taking a long time to run when using parameters where the scope might change each time it's run.

    To resolve the issue, it was quicker and...

    January 4, 2013 at 5:19 am

    #1573699

  • RE: SQL Crosstab Query

    Always the way, a fresh set of eyes gets it straight away!!

    Thanks for your help, all working now.

    January 4, 2013 at 4:55 am

    #1573690

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