Server Error in '/' Application.

The multi-part identifier "Numbers.Number" could not be bound.
ORDER BY items must appear in the select list if the statement contains a UNION, INTERSECT or EXCEPT operator.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: The multi-part identifier "Numbers.Number" could not be bound.
ORDER BY items must appear in the select list if the statement contains a UNION, INTERSECT or EXCEPT operator.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[SqlException (0x80131904): The multi-part identifier "Numbers.Number" could not be bound.
ORDER BY items must appear in the select list if the statement contains a UNION, INTERSECT or EXCEPT operator.]
   BFLDataObjects.DDLs.GetLegHeightRangeByProduct(Int32 RecId) +299
   BFL.ucOptions06.PopulateDDLs() +1217
   BFL.ucOptions06.Page_Load(Object sender, EventArgs e) +107
   System.Web.UI.Control.OnLoad(EventArgs e) +108
   System.Web.UI.Control.LoadRecursive() +90
   System.Web.UI.Control.LoadRecursive() +185
   System.Web.UI.Control.LoadRecursive() +185
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1533


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4330.0