sql_language thread: Re: Syntax error converting datetime from character string.
I figured my problem out by changing the CASE statement from its original
state:
ORIGINAL:
> : ORDER BY
> : CASE @Sort
> : When 'Date' then v.Begin_Date
> : When 'OAvg' then v.OAvg
> : When 'Instr' then ie.LastName
> : When 'txtCourse' then e.[name]
> : When 'MAvg' then v.MAvg
> : When 'IAvg' then IAvg
> : When 'RecPcnt' then v.RecPcnt
> : Else v.Begin_Date
> : END
to this one:
WORKING:
ORDER BY
CASE When @Sort = 1 then v.Begin_Date END,
CASE When @Sort = 2 then v.OAvg END,
CASE When @Sort = 3 then ie.LastName END,
CASE When @Sort = 4 then e.[name] END,
CASE When @Sort = 5 then v.MAvg END,
CASE When @Sort = 6 then IAvg END,
CASE When @Sort = 7 then v.RecPcnt
Else v.Begin_Date
END
...And then assigned each string variable an integer in my asp page.