Is not all the proc just where order by is

SELECT DISTINCT
' + @RFQID + ',
ItemMaster.ItemID,
CASE WHEN ' + @ItemListID + ' = 0 THEN IsNull(ItemMaster.ItemLotSize,1)
ELSE IsNull(ItemList_ItemMaster.Quantity,1) END AS Quantity,
ItemMaster.ItemName,
ItemMaster.ItemDescription,
ItemMaster.UnitOfMeasureID,
1,
''' + @ItemDeliveryDate + ''' AS ItemDeliveryDate,
V_CompanyDefaultManufacturers.Manufacturer,
V_CompanyDefaultManufacturers.ManpartNumber,
ItemMaster.UNSPSC,
ItemMaster.ItemBuyerPartNumber,
-1,
-1,
' + @ShipStateID + ' AS ShipStateID,
' + @ShipCountryID + ' AS ShipCountryID,
ItemMaster.ItemStdCost,
CASE WHEN V_CompanyDefaultManufacturers.ApprovedPrefManCount > 1 THEN -1
ELSE 0 END AS SubstituteAllowed
FROM ItemMaster LEFT OUTER JOIN ItemList_ItemMaster ON ItemMaster.ItemID
= ItemList_ItemMaster.ItemID
LEFT OUTER JOIN V_CompanyDefaultManufacturers ON ItemMaster.ItemID =
V_CompanyDefaultManufacturers.itemID
WHERE ItemMaster.CompanyID = ' + @companyID + ' AND ItemMaster.ItemID IN (
' + @ItemIDs + ')
ORDER BY ItemMaster.ItemBuyerPartNumber ASC')






>From: Ken Nickels <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] FW: Stored Proc 2000
>Date: Tue, 17 Sep 2002 09:51:10 -0400
>
>Are you sure you don't have something like this in production?
>
>select stuff
>from table
>where condition is so and so
>-- order by something
>
>
>-----Original Message-----
>From: Hakim Tadjer [mailto:[Email Address Removed] Tuesday, September 17, 2002 9:52 AM
>To: LazyDBA.com Discussion
>Subject: Stored Proc 2000
>
>
>
>Hi,
>
>I have a little problem, my stored procedure don't execute the
>ORDER BY in my request in live database and he can do it in test database.
>
>where i can check to verify where is the problem
>
>sql 2000/ WIN 2000 environement in .Net tech
>
>Thanl's
>
>
>
>
>_________________________________________________________________
>Discutez en ligne avec vos amis ! http://messenger.msn.fr
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] en ligne avec vos amis ! http://messenger.msn.fr

MS Sql Server LazyDBA home page