RE: Order by an expression.

[Kenneth]

> Hi.
>
> I'm trying to sort a table with an expression in a stored procedure. Like
> this :
> SELECT * FROM ___ ORDER BY @T
>
> But this won't work.
>
> Does anyone have a good idea to solve that?
>
> Regards...
>
> Kenneth

Make it a string, and EXEC() it:

DECLARE @SQL varchar(255)

SET @SQL = 'SELECT * FROM MyTable ORDER BY ' + @T

EXEC(@SQL)

--
Colin McGuigan


Hi Colin.

When I try to do that, it comes out with an error: Error converting varchar
to int.

How should I declare the variable @t in the SP?

Thanks for your help so far.

Regards.

Kenneth

[Colin McGuigan]

Kenneth <ridder@snoopymail.com> wrote in message
news:39c1dfa4$1@news.devx.com...
> Hi Colin.
>
> When I try to do that, it comes out with an error: Error converting
varchar
> to int.
>
> How should I declare the variable @t in the SP?
>
> Thanks for your help so far.
>
> Regards.
>
> Kenneth

As a varchar, preferably:

If it's part of the stored proc declaration:

CREATE PROCEDURE MyProcedure
@T varchar(50)
AS

Or if it's just declared on it's own:

DECLARE @T varchar(50)


--
Colin McGuigan