Hi
The following query works in all SQL server2000 except one server.
DECLARE @TBLAvgTOD_Page_Temp TABLE
(
Time_day_Month INT,
UnitID VARCHAR(10),
AverageFrom Decimal(20,2),
AverageTo Decimal(20,2)
)
DECLARE @TBLAvgTOD_Page TABLE
(
RowNum int IDENTITY (1, 1) NOT NULL,
Time_day_Month INT,
UnitID VARCHAR(10),
AverageFrom Decimal(20,2),
AverageTo Decimal(20,2)
)
DECLARE @SortColumn VARCHAR(30),
@SortOrder VARCHAR(5)
INSERT INTO @TBLAvgTOD_Page
(
Time_day_Month,
UnitID,
AverageFrom,
AverageTo
)
SELECT * FROM @TBLAvgTOD_Page_Temp
ORDER BY
case when @SortColumn='Time_Day_Month_Formated' and @SortOrder='Desc' then Time_Day_Month end desc,
case when @SortColumn='Time_Day_Month_Formated' and @SortOrder='asc' then Time_Day_Month end asc,
case when @SortColumn='UnitID' and @SortOrder='Desc' then UnitID end desc,
case when @SortColumn='UnitID' and @SortOrder='asc' then UnitID end asc,
case when @SortColumn='AverageFrom' and @SortOrder='Desc' then AverageFrom end desc,
case when @SortColumn='AverageFrom' and @SortOrder='asc' then AverageFrom end asc,
case when @SortColumn='AverageTo' and @SortOrder='Desc' then AverageTo end desc,
case when @SortColumn='AverageTo' and @SortOrder='asc' then AverageTo end asc
In that machine I get an error
"Column name doesnot match the table defenition." Any idea?