Phil, Robert -

If I understand Robert's comment, then the opposite must be true, too. There may be no beer at all and so your sum is 2. I...

So, like this?

/ss:Workbook/ss:Worksheet[@ss:Name="Form C - Data Form"]/ss:Table/ss:Row/ss:Cell[ss:NamedCell[@ss:Name="Annual.Part_time"]]/ssata

(sorry to seem dense, I've never used XPath)

Alright - that sounds good. Now, I'm not an expert in XPath. Does this sound right (if I name a range of cells "Annual.Part_time"):

Cell[NamedCell[@ss:Name="Annual.Part_time"]]/Data

Have you worked in the SSIS...

Ok, the spreadsheet has multiple pages; each worksheet has a different "form". The idea is that folks would be able to distribute the file to companies to fill out....

anyone?

Here's my more complete version. I've dropped use of the lookup table, and combined it with the district codes for joining. My speed is greatly improved, but only...

They 'union all' seemed useful, but it's hard to measure. As for not using a 'between', the trouble is, I'm trying to compare within a month, so I have...

I'm trying to do something similar, and I'm searching the forums for suggestions. I don't understand the purpose of the cross join in these posts. Could someone break...

Vladan, When most people call a column 'date', it's usually a date datatype. In this case, it appears I don't have time, but the logic should work either way....

Yes, that's one I tried, too. The trouble is, the one key and date aren't unique; when I join on them, I return too many rows. And, if...

Yes, a LEFT would work if every question was answered. As it is, the LEFT causes a "A NULL 0" to be added for each question.

Well, I'm not sure what benefits that would give, nor do I really understand what you're doing. But the pivot seems to work just fine, and is only .15%...

Actually, it looks like the links in this post are just about perfect. Specifically the link to Manipulating Hierarchies with UDFs; the sample code looks like I...

You're right, I don't understand it. But when I copy it, and put in those modified inserts (with three tiers), it doesn't display them in the expected order.

Except:

grandparent-1, 17-Jan-05

parent-1, 18-Jan-05

grandparent-2, 19-Jan-05

parent-1, 19-Jan-05

grandparent-3, 20-Jan-05

child-1, 20-Jan-05

parent-2, 20-Jan-05

The order really needs to be 'topic, child-of, date'. It's the middle...