Post reply

awfwf

  • November 10, 2011 at 5:06 am

    #250536

    Hello all,

    I'm very inexperei

    SELECT TOP (100) PERCENT tr_trrefn, tr_abbrv,

    CASE WHEN tr_trtype = 'bl' THEN tr_disamt WHEN tr_trtype = 'ab' THEN - tr_disamt WHEN tr_trtype = 'up' THEN tr_amount ELSE NULL

    END AS Disbs

    FROM cafintrn

    WHERE (tr_matter = '00067603') AND (tr_trtype IN ('bl', '02', 'ab', 'up'))

    ORDER BY tr_trdate, tr_seqnum

  • November 10, 2011 at 5:15 am

    #1405643

    What is your question?

  • November 10, 2011 at 5:16 am

    #1405645

    matt_scott1984 (11/10/2011)

    Hello all,

    I'm very inexperei

    SELECT TOP (100) PERCENT tr_trrefn, tr_abbrv,

    CASE WHEN tr_trtype = 'bl' THEN tr_disamt WHEN tr_trtype = 'ab' THEN - tr_disamt WHEN tr_trtype = 'up' THEN tr_amount ELSE NULL

    END AS Disbs

    FROM cafintrn

    WHERE (tr_matter = '00067603') AND (tr_trtype IN ('bl', '02', 'ab', 'up'))

    ORDER BY tr_trdate, tr_seqnum

    Hello and welcome to SSC!

    It appears that you have forgotten to post a few details, so I'm unsure what your actual question is!

    What we could do with from you are four things: A clear description of your problem, DDL scripts, sample data in a readily consumable format and expected results.

    When you have time, please read this article[/url] about the best way to provide us with working sample data and DDL scripts. This will allow the unpaid volunteers of this site to provide you with working, tested code for your particular problem.

    Thanks.

    Forever trying to learn
    My blog - http://www.cadavre.co.uk/
    For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
    For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • November 10, 2011 at 5:33 am

    #1405656

    P.S. You need to upload your picture if you want us to see it. Right now it sits on your HD and we don't have access to that.

  • November 18, 2011 at 6:19 am

    #1409853

    matt_scott1984 (11/10/2011)

    Hello all

    Hello there 🙂

    Thanks God you have good manners - anything we can help with?

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • November 18, 2011 at 7:35 am

    #1409918

    PaulB-TheOneAndOnly (11/18/2011)

    matt_scott1984 (11/10/2011)

    Hello all

    Hello there 🙂

    Thanks God you have good manners - anything we can help with?

    There is, the OP posted it here.

    Forever trying to learn
    My blog - http://www.cadavre.co.uk/
    For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
    For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

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

You must be logged in to reply to this topic. Login to reply