locked
how to write stored procedure for this query? RRS feed

  • Question

  • User1288863645 posted

    string Query = "select distinct top 100 companyname from Member_List_US order by companyname";

    Monday, August 8, 2011 2:48 AM

Answers

  • User1682618242 posted

    create procedure ProcName

    as

       select distinct top 100 companyname from Member_List_US order by companyname

    go

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, August 8, 2011 2:52 AM
  • User498534395 posted

    Create Procedure Member_List

    AS

    BEGIN 

    select distinct top 100 companyname

    from Member_List_US

     order by companyname

    END

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, August 8, 2011 2:52 AM

All replies

  • User1682618242 posted

    create procedure ProcName

    as

       select distinct top 100 companyname from Member_List_US order by companyname

    go

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, August 8, 2011 2:52 AM
  • User498534395 posted

    Create Procedure Member_List

    AS

    BEGIN 

    select distinct top 100 companyname

    from Member_List_US

     order by companyname

    END

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, August 8, 2011 2:52 AM