April 29, 2003 at 9:34 am
How can I get the dynamic OrderBy to work properly? Below is a simple sample:
DECLARE @test-2 SYSNAME
SET @test-2 = 'ColOne'
SELECT
'A' AS ColOne,
'D' AS ColTwo
UNION
SELECT
'C' AS ColOne,
'B' AS ColTwo
ORDER BY
--ColOne/*This Works*/
/*This does not*/
CASE @test-2
WHEN 'ColOne' THEN ColOne
WHEN 'ColTwo' THEN ColTwo
END
Here's an override (this works but cannot use for another reason):
DECLARE @test-2 SYSNAME
SET @test-2 = 'ColOne'
SELECT * FROM
(
SELECT
'A' AS ColOne,
'D' AS ColTwo
UNION
SELECT
'C' AS ColOne,
'B' AS ColTwo
) DynamicTable
ORDER BY
--ColOne/*This Works*/
/*This does not*/
CASE @test-2
WHEN 'ColOne' THEN DynamicTable.ColOne
WHEN 'ColTwo' THEN DynamicTable.ColTwo
END
Now - see my previous post about errors in using UDF's inside subqueries. That's why I'm trying to avoid the "Outer Query".
Thanks - B
April 29, 2003 at 10:29 am
Have you tried putting the query in a variable and using sp_executesql or will this not work in the way you want to use it?
Far away is close at hand in the images of elsewhere.
Anon.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy