But Row_Number() was new in 2005, wasn't it?

Doesn't help that I'm developing on 2005 for a 2000 system ...

Oh yeah, that's what I want, very nice work, thanks! 😎

Now I'll try to understand how you did that 🙂

Thanks again.

There are some third-party utilities available which allow you to run a Crystal Report from the command line. So, once you have that working, your problem reduces to building the...

I hope you did not take offence - none was intended. My comment was meant in fun.

I never even suspected that English was not your native language - you...

Hmmm, you might be pretty good at SSIS, but I'm not so sure about your English! 😀

If no one else answers in the meantime, I will try to set up a test later. There must be a way! What about firing in the number which Excel...

Sounds like it's going into Excel as text to me.

So if you remove all display formatting in Excel, what does the field actually contain?

OK, if your table is called t1, this should do it:

with t as (

select distinct ID, Max(Cost) Cost

from T1

group by ID

)

select t1.ID, max(t1.Cost), Max(t1.ItemNumber) from T1

join T on T1.ID =...

If you can use SQL Server to do the work:

Select Convert(Varchar(10) , Cast('12-OCT-2009 18:23:20' as Datetime), 103)

--edit - oops, misread your post. That's not a date datatype 🙁 ignore me.

OK, try

select ID, Max(Cost), Max(ItemNumber)

from ...

Group By ID

If there is more than one item number, as in the case of

2 30 D

2 30 EE

which item number would you want to select? D, EE or does not...

Don't do the deinstall, it won't fix this.

Sounds like an Excel driver 'feature', see here[/url]. You could try the solutions offered there. Or ...

Try adding a column to the right...

Maybe you could add the variables as derived columns in your dataflow and then use a Data Viewer ...

That was what I was trying...