Order By in function???

• ZA_Crafty

  Ten Centuries

  Points: 1228

  More actions

  July 16, 2010 at 5:10 am

  #100279

  Hi Guys/Girls,

  I've got a function that returns multiple rows into a single line of html.

  Now the select part of that query looks as follows.

  The user wants the names listed in descending form in the html. Here is the selct part of the query.

  This still returns multiple lines, but the lines should be listed by name desc

  However: It gives me on the order by clause

  Msg 156, Level 15, State 1, Procedure f_StockItemDepoQuantitySelect, Line 67

  Incorrect syntax near the keyword 'Order'.

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  July 16, 2010 at 8:16 pm

  #1194449

  Can you post full text of procedure f_StockItemDepoQuantitySelect?

  Or at least first 70 rows, where the error happens.

  _____________
  Code for TallyGenerator

• ZA_Crafty

  Ten Centuries

  Points: 1228

  More actions

  July 20, 2010 at 1:30 pm

  #1195771

  The error line was Order By

  Reasaon for that is that Order By is not allowed in function.

  However the client requirement was only that the warehouse be listed 1st.

  So what I did was to do a union select.

  Select everything where the name is warehouse

  union

  select everything else

  Ugly, but it works 😀