I extract the data from various places and combine it. Once I'm done, for each invoice I have a row for each cost center (or order or network) that...

Thanks for realizing that I needed that caution!

(I had to test the code that Lowell provided in order to understand that the same address would not be returned for both...

Many thanks Jeff! This is just the kind of thing I need to get me started actually understanding instead of being a perpetual "stumble-my-way-through-it"-er... At this point I...

Thanks Jeff. So I suppose I should use nvarchar(8000) for the column that has never topped 1000 characters, but still am stuck using nvarchar(max) for the column that has...

Thanks. Given that info I will stick with max as I have no need to index by these columns. 😀

Tai

Thanks!

Good point... For the sample data that is definitely smarter. In my actual data I have about 6 fields that are like 'address' in that there could be...

Further confirmation that this is the right way to do it... I just had expected there would be something that did not require two queries and was thus simpler....

Thanks to both of you for the code. And thanks for the tip on posting code to create the sample data.

I am actually already doing it the way you...

My data example was flawed... suppose it is this instead. Then how would the query be written? Thanks.

table A

Name | Address

Tai | #

Mike | #

table B

Name | Address

Tai...

Maybe I should have posted in the 'newbie' forum for this, as my grasp of most things SQL-related is weak I don't understand how that would be implemented.

For clarity, though,...

I don't understand how that would help me... unless I am missing something, I would need to pre-determine the exact order in which my packages will run, and put...