Dynamic Order By clouse 1

[vpekulas]

I have the following SP, how can I pass in the field name
that the recordset should be sorted by ? I want @FieldName
to be the field name ......

CREATE PROCEDURE sp_Index
@FieldName varchar(50)
AS
SELECT ID, fldS, fldEnable, fldMulti, fldSHOWRES, fldEDATE, fldACTIVE
FROM poll_tbl_poll
ORDER BY @FieldName ASC
Go


"Taxes are the fees we pay for civilized society"

 

[swampBoogie]

CREATE PROCEDURE sp_Index
   @FieldName varchar(50)
AS
exec('SELECT ID, fldS, fldEnable, fldMulti, fldSHOWRES, fldEDATE, fldACTIVE
   FROM poll_tbl_poll
   ORDER BY ' + @FieldName )
Go

 

[vpekulas]

Thanks swampBoogie, that did it.
BTW why did u use the exec command. Wouldn't it work with out it as well ?

"Taxes are the fees we pay for civilized society"