Thanks Grant, I had not considered using TOP.

Cheers

Allen

Thanks Grant, I've seen a few of Jeff's articles on triangular joins and RBAR (and other stuff). I was using a < in the join and getting bad performance.

Essentially I...

Thanks Pradeep. Also thanks for the pointer about partitioning!

Regards

Allen

Thanks Luke - I got there. I had left some bad options set in my Execute SQL task and of course I was sure I hadn't!

Thanks Luke,

I tried the 'bulid a string and execute it in a loop' method and although I got no errors nothing was written to the MySQL table. I tried this...

Looks like the delete button has given up...

I would start by checkig the SQL and system logs. Is there anything in there?

I would first check the SQL and system logs. Anything there?

I would first check the SQL and system logs. Anything there?

Search BOL for BCP and look under command options. Edit: sorry only answered the bit about -c -t, -T (talk about not reading the question) not sure if you can...

SMALLDATETIME is fine for your data.

SELECT CAST('2009-04-11 04:00:11' AS SMALLDATETIME)

I would check your field and row terminator options. Is the data file as is in your post?

If you are only using Access to do the cross tabs then I would suggest scrapping access and reworking the crosstab SQL using CASE statements if you are on SQL2000...

No problem. CASE is hugely powerful and can be used in loads of places/problems.

Or CASE

USE tempDB

GO

CREATE TABLE

X

(ClientIdINT,

ClientNameVARCHAR(50),

VersionsourceVARCHAR(50))

INSERT X

(ClientId,

ClientName,

Versionsource)

SELECT 1, 'X', 'David' UNION

SELECT 2, 'y', 'Manual' UNION

SELECT 3, 'Z', 'Richard' UNION

SELECT 4, 'A', 'Manual' UNION

SELECT 5, 'B', 'David'

SELECT

CASE

WHEN VersionSource =...

I'm not sure on this but you could try having the excel workbook defined as a linked server then running a bit of dynamic sql like 'select * into linkedservername.oranges...