I'm finally getting the opportunity to work on this project again. Thank you so much for all your help.

Matt, your pivot explanation helped me understand where I was going...

Your Pivot is doing a grouping by propertyID AND usecode, which is wrecking your "alignment". pull the usecode and price out (leave them in the combined), and I think...

Using the table #data from the earlier post:

with land_cte (PropertyID, Row_Num, UseCode, Price, CombinedData, frontage) as

(select propertyId, segmentNum, useCode, price,

(cast(useCode AS char(4)) + cast(price as char(15))) as CombinedData,...

Steve,

By using the aggregate function on the COMBINED_DATA field, I'm

getting multiple rows per property, rather than one row per property.

Using the table #data Antonio posted earlier, the output...

I really do appreciate these ideas. I'm still working on it, though, but right now I'm not even sure what to ask next. :unsure:

Many thanks for the...

This looks more promising and more efficient than what I had originally set up. And I was getting stuck on the pivot table idea. So, let me get to work...

Thanks for the suggestion. I'll see what I can do with it. (It's taking me a bit to get my head around this, but I'll be sure to post again...

I want to end up with a table that has:

1) Property_ID

2) Sum of front feet of all land segments associated with that property

3) Land use code of first land segment...

After more thinking and googling and researching, I think I see what I need to do now:

1) Create a project that has all my dtsx packages in it. [done]

2) Save...

I tried to add an 'execute package' task earlier, but I couldn't navigate to any of the packages in this project.

But, I was choosing SQL Server as the location...

Can someone point me to a reference on-line for creating a master SSIS package?

I will also accept a simple explanation here. 🙂

SUCCESS! Thank you SOOOO much!!

Joe: Thanks for the link. I'll look into it.

..Gwen..

This didn't exactly work. All the descriptions are listed for each column. For example, if my t_Account table simply had column names of acct, name, & address, and each column...

Running that query gives me an error message I don't understand:

Cannot resolve the collation conflict between "Latin1_General_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.

I first took a look at all...

Thanks, Grant. I'll see what I can do with this!

..Gwen..