Have you tried using DTS? This would be a pretty simple task using the text file source connection.

SELECT 'A',

aID,

Col,

aBol1,

...

I'll second that. In fact, it would be good if you'd include sample data from before and after your cursor runs. This seems like a pretty straight forward...

Thanks for picking this one up Matt. I think I messed with the query just before posting it becuase I had the COUNT(*) included when I was playing with...

Put the error code into a variable so you can return it.

SET @SQLError = @@ERROR

IF @SQLError <> 0 .......

You can then later query @SQLError and get the actual...

Your average CPU time looks good. When your CPU usage goes up to 100%, how long does it stay there for? If you are just seeing spikes up...

SET NOCOUNT ON

DECLARE @r TABLE (ID int, DateShipped datetime, ItemId int)

INSERT INTO @r

SELECT 1, '1/1/2005', 1 UNION ALL

SELECT 2, '1/1/2005', 2 UNION ALL

SELECT 3, '1/2/2005', 1 UNION ALL

SELECT 4,...

We'll need more helpful information from you on this. You've posted part of your table, where's the rest? The table you've posted has 2 columns, but the...

If SQL Oracle's answer does not do it for you, you'll want to give us some more info such as sample data, expected results, and how 'bout posting the queries...

Great. Thanks for posting your results.

This is a simple task if you use the RESTORE DATABASE T-SQL command.

First, get the file info from the backup file:

RESTORE FILELISTONLY

FROM DISK='backup file path and name'

Then, restore WITH...

What you need is another outer join. Check out this example and see if you can get your UPDATE statement from it:

DECLARE @STU TABLE (SC int, SN int)

DECLARE @PRG...

Procedure cache hit rate refers to how often a stored procedures execution plan is found in the procedure cache. Buffer cache hit rate refers to how often a request...

From your description, I am not clear on whether you are trying to update the 3rd table or simply add it to the JOIN. Can you clarify this for...

Create an ActiveX task and simply set the variables to zero/blank depending on the data types.