Yup, add a group by... as below - should work I think.

jbalbo (3/7/2014)

---

Thanks for the info

here is what I Have

DO I need a group by ?

SELECT D.*

FROM (

SELECT...

Perhaps not the most elegant solution, but I think it answers the question you're trying to get at...

SELECT D.*

FROM (

SELECT C.Client

, MAX(S.ServiceDate) AS LastServiceDate

FROM CLIENT C

LEFT JOIN SERVICE S

ON C.somecol...

How would I determine my locale settings? I believe it should interpret it as I intended, but want to double check.

Thanks!

It comes in from a flat file and is read in as a string [DT_STR] with length 50.

good to know. Thanks so much - I...

By using a table (and adding a csv list id, and a sequence number) won't I be tripling the size of the data that is required to be stored? ...

Thanks to both of you for your help and ideas - I thought I would be able to do this without subqueries with separate groups, but that may not be...

Not sure how RANK() OR DENSE_RANK() would help in this example. I thought a lot about the functions RANK, DENSE_RANK, and...

I'm not 100% sure what resolved the problem, as I was changing a few things at once.

1 - I moved all of the SQL commands into a single Execute...

I ended up having to create a new connection to the csv file, but then the if statement worked.

Thanks!

Okay - so I can go back into the SSIS package and set that column to a Unicode string with no text qualifier (as the NA's don't have quotes around...

Judging from the current size of the file, and the available room on the harddrive yesterday, there is no way that it could be this big JUST from this temporary...

Sorry if I'm a newb at this, but I'm looking in the properties menu, file page of the database I'm concerned about. And right now, it shows an initial...

Thanks so much for the help.

As for answering some of your questions, I've only got a single hard drive on this machine, but it's big. And I'm...

Thanks! Works in my small example, now I've just got to implement it with everything else!