Post reply

Please help me CREATE PROCEDURE..

  • March 14, 2012 at 2:03 am

    #270010

    Create a store procedure input is a mounth and product number in that month..

    Links :

    It's stay question 11

    ..

    Please help me.. I say E.. very bad..:(

    Thanks everybody ..^^

  • March 14, 2012 at 2:20 am

    #1459014

    We're not going to do your homework for you.

    Show what you've tried. Where specifically are you stuck?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 14, 2012 at 2:24 am

    #1459017

    ..:(.. I'm stuck and haven't solution ..

    Wait for me.. ^^ I post

  • March 14, 2012 at 2:37 am

    #1459025

    CREATE PROCEDURE spTopProductMonth

    (

    @ODate datetime

    )

    AS

    SELECT [Order].OID,PID,CID,ODate,[Status],UnitPrice,Amount

    from [Order] inner join OrderDetails

    on [Order].OID = OrderDetails.OID

    WHERE @ODate = ODate;

    EXECUTE spTopProductMonth '03/10/2012' ;

    I'm make it.. but it's not show when i run EXECUTE..

  • March 14, 2012 at 2:39 am

    #1459026

    Are there any rows in the table that have an ODate of '03/10/2012'?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 14, 2012 at 2:46 am

    #1459030

    Thanks ^^

    I forget 🙂

    Please You guide me ... input a month to show 🙂

  • March 14, 2012 at 6:35 am

    #1459124

    Not following. Please be specific about questions, I can't read your mind.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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