Studying the file, 2 problems. One is that there are 7 records per painting with the 7th line either missing or blank. Second the file does not contain CR/LF at...

How about creating a table of possible margin values (counter in my case containing 1 to 100) then doing

select sum([count]) as [count], c.number as margin...

To get your required results with BCP the data has to match exactly the definition in your fmt file, 6 lines per record separated by CR/LF including blank lines. To...

where ss is not null

Change the inner join to left outer join and add a where clause

WHERE JoiningTable.key IS NULL

Hi Frank,

Nah1 But you can cook Salmon!!!

No Kidding

This might work

update p

set p.mindate = x.mindate,

p.maxdate = x.maxdate

from parent p

left outer join(SELECT keyid,min(date) as mindate, max(date) as maxdate 

from child grouped by keyid) x

on...

I understand it to be machine, an old generic term for pc/server.

nb pc is personal computer

nb nb is ... oh b******s

I have no problem accessing 1600 byte fixed length records with DTS. Are you sure all records are 1600 bytes and as ghughes stated have got CR/LF. If your data...

Can you use an OUTPUT parameter in the top proc to return either error value (@ERR or @Result in my example) and test for this.

One way is to use RETURN to return non sql critical errors or user defined errors and to trap both errors after proc call

DECLARE @Result...

Is the data fixed column or separated by a delimiter. It looks like you specified delimited data in DTS but the data does not contain the delimiter specified.

p.s. DTS wizard...

If you know the max no of colours (3 in your example) then, not elegant but....

select b.Manufacturer,b.c1+

coalesce(', '+b.c2,'')+

coalesce(', '+b.c3,'') as 'ColorsAvailable'

from (select a.Manufacturer,

max(case when a.Colorct...

If I remember right from when I used 6.5 you have to extend the log first to enable sql to commit/rollback trans to put the database in the right state....

If the query you posted is accurate and id is varchar then I think the problem is with the difference in implicit/explicit conversion between 7 & 2000, you will need...