UPDATE updatetble1

SET updatetble1.updatecol1 = updatetble2.updatecol2

FROM updatetble1 INNER JOIN updatetble2

ON updatetble1.joiningcolumn = updatetble2.joiningcolumn

WHERE Yourcondition = Your Value

An element is the main tag itself such as <Element>

An attribute is a value within the definition of an element such as <Element MyAttribute="An attribute value" />

How can I have 0.00632 reads and writes?

Use SCOPE_IDENTITY because SCOPE_IDENTITY identifies the last identity value for the current scope where as @@IDENTITY identifies the last identity regardless of scope.

SELECT @@VERSION

SP3 = 8.00.760

SP4 = 8.00.2039

SP4 plus embarrassing fix for memory problem in SP4 = 8.00.2040.

You should be on at least SP3

If you have an dbo.addOrderLine stored procedure then you could set up a dbo.addOrder stored procedure that accepts the parameters necessary to add an order and a single order line.

Wrap...

The N'string' thing converts an standard ASCII string to a unicode one.

db_owner is a database role that can do absolutely anything within the database. Destroy tables, alter stored procedures,...

Doesn't this mean that Excel has to be installed on the server?

If not then wouldn't it be better to break out the task so that one task writes the Excel...

Regardless of whether you have used sp_detach_db you can attach the MDF and LDF files.

As ever, backup your MASTER database on your target server before and after the attach.

You will...

If you have a compound index on cols A,B,C and your where clause contains ColA then it will use the index.

If your where clause doesn't contain A then it won't

See my article on RAISERROR. It may help

You could use the sp_OACreate, sp_OAMethod and sp_OAProperty stored procedures to access the Excel object model however I wouldn't recommend it.

Excel does not seem to have the concept of a...

As an aside I read an article quoting Steve Jobs on the subject of cars.

He was lamenting that the gorgeous concepts you see at a motor show rarely translate into...

Provided it precedes the tranformation into your txt/xls object it doesn't matter though personally I make it the first task in the DTS.

I actually agree with most of the things you say, possibly with the exception of the separating out toilet paper from sewage.

When ever I see a badly designed database supplied...