Post reply

Hiii

  • February 17, 2011 at 1:11 pm

    #388888

    I am starter in learning sql server.

    I have to write a stored procedure using this logic which works in sqlserver2008.

    If i am having 100 Orders coming, then if i have 150 orders i.e, 50 orders are exceeded.I have to share to 3Cumstomers, 1st priority to 1st customer 100% (blackberry),then 2nd customer 80% (Nokia) ,then 3rd customer XXX%(LG) or

    I can share the orders in equal to 3customers.

    This is the logic i have can anyone help me in writing Stored procedure to query this.

  • February 17, 2011 at 1:25 pm

    #1288488

    please read and follow the advice given in the first link refernced in my signature and provide ready to use test data together with your expected output and what you've tried so far.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • February 17, 2011 at 1:27 pm

    #1288490

    Please provide the info that Lutz has requested. It would be extremely helpful.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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