"Wayne Hui" <whui@driehaus.com> wrote in message news:073001c37eec$185b8ae0$a301280a@phx.gbl...
> Hi, I was wondering if there's a way to put conditions
> within a select statement in a stored procedure. For
> example if I want to do different ordering depending on the
> input type -
>
> ALTER procedure test
> @inputType int
> AS
> BEGIN
> select * from someTable
>
> if (@inputType = 1)
> order by someCol1
> else
> order_by someCol2
> END
>
> Is this possible in some way?
>
> Sincerely,
> Wayne
>
>