DELETE WHERE CURRENT OF?

OP wrote there was no primary key.

Is there a clustered index present?

CREATE TABLE#Sample

(

Col1 VARCHAR(5),

Col2 INT,

Col3 CHAR(1)

)

INSERT#Sample

SELECT'ABC', 24, 'M' UNION ALL

SELECT'ABC', 24, 'M' UNION ALL

SELECT'DEF', 24, 'M' UNION ALL

SELECT'DEF', 24, 'F'...

Here is a lot to read for you.

Start at the bottom

http://blogs.msdn.com/craigfr/archive/tags/Joins/default.aspx

You used double quote character for string data.

In SQL Server, that is one way to select a column name and of course you don't have a column named

[ and b.cust_fin_entity...

Which Edititon of SQL Server are you trying to install?

You also need at least service pack 3 to start SQL Server 2000 on XP.

So there may not be a real...

TOP 1 ???

According to what? You need a sort order to define TOP.

Also asked and answered here

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

You can also put the code in a tablevalued function, which accepts parameters.

I posted an answer here

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

Something like this?

DECLARE @Sample INT

SET @Sample = 692238

SELECT STUFF(CONVERT(CHAR(8), DATEADD(SECOND, @Sample % 86400, '00:00:00'), 108), 1, 2, CAST(@Sample / 3600 AS VARCHAR(12)))

Already asked and answered here

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

Google is your friend

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

http://www.sqlservercentral.com/scripts/Miscellaneous/31751/%5B/url%5D

GETDATE() or GETUTCDATE()

You can make it somewhat shorter by using style 108 instead of 113.

select convert(char(8), getdate(), 112) + '_' +

replace(convert(char(8), getdate(), 108), ':', '-')

or

select replace(replace(replace(convert(char(19), getdate(), 120),...

What kinnd of query needs 256-table join!?