Between has only 3 "e".

Correct spelling and try again.

Remove Order_ID from the SELECT-list in the derived table.

what is the expected output?

Already asked and answered here

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=106744

I wonder if people like this think it is fun to make twice as many people work for them for free?

SELECTOrder_ID,

[Pending],

[Submitted],

[Received],

[Processing-CheckedIn],

[Processing],

[Processed],

[Archived],

[Discard]

FROM(

SELECTStatusDate,

Order_Status_Cd

FROMdbo.DW_ORDER_STATUS_HISTORY

) ps

Pivot(

Max(StatusDate)

for Order_Status_Cd in ([Pending],[Submitted],[Received],[Processing-CheckedIn],[Processing],[Processed],[Archived],[Discard])

) As PivotTable

order by 1

I recently blogged about that.

Have a look at http://weblogs.sqlteam.com/peterl/archive/2008/07/15/PIVOT-conundrum.aspx

Change you derive table ps to contain only the records present in the pivot. all other columns are used for transformation as...

NULL are automatically dumped with UNPIVOT.

SELECTu.Name,

AVG(u.theAmount) AS Average

FROM@T AS s

UNPIVOT(

theAmount

FOR theCol IN ([Amount1], [Amount2], [Amount3])

) AS u

WHEREu.theAmount > 0

GROUP BYu.Name

ORDER BYu.Name

No.

Maybe it's just a starting condition?

"Get these records and update a flag".

Call a SP to process the previously marked records.

Now start from beginning by picking a random record for each...

I agree with 3)

Even in SQL Server 2000, which is the this database forum?

No need for dynamic SQL. Seems like a panic attack to me.

ALTER PROCEDURE Get_CustomerDetailsByName

(

@CustomerName varchar(30)

)

AS

SET NOCOUNT ON

SELECT*

FROMCUSTOMER

WHERECUSTOMER_NAME LIKE '%' + @CustomerName + '%'

The differencies in your result is...

DECLARE@Sample TABLE (EmpNo INT, EmpName VARCHAR(20), City VARCHAR(20), xlsOrder INT)

INSERT@Sample

SELECT101, 'scott', 'hyd', 1 UNION ALL

SELECT102, 'tiger', 'jum', 2 UNION ALL

SELECT103, 'jakir', 'trhsj', 3 UNION ALL

SELECT104, 'upers', 'luknow', 2 UNION ALL

SELECT105,...

Try this for speed

SELECTRegistrationNo,

MIN(gps_datetime) AS minTime,

MAX(gps_datetime) AS maxTime

FROMgpsdata_history

WHEREgps_datetime >= '20080713'

AND gps_datetime < '20080715'

AND analog2 = 'stepii'

GROUP BYRegistrationNo

ORDER BYRegistrationNo

Most probably an input using a single quote was used.

And the programmer of the query didn't assume that possibility and hence didn't use QUOTENAME() function to remedy.