Offhand, I am not entirely sure.  Mark would be a better one to ask, but looking at his code, I'm not sure there is a nice way to match that...

I am working on this, I am just hitting snags.  Think I need to re-think how to solve this.
I have it mostly working until a second COMP shows up....

I think first, I would figure out some way to order the data.
Next, I wouldn't assume that 2 weeks means that it is a new request.  I would assume...

The most interesting project I've worked on recently was building up a dynamic OData web server.  You give it the database name and it grabs all of the tables and...

Your primary key cannot contain nulls.  There is no way around that.

You can join on a table that has no primary key with no problem though.  The hard...

I think your Dataset1 is set up odd.
The way I am reading that error is that your Dataset1 has the text "EXEC dbo.Dataset1", which I imagine is not what...

You have no primary key on any of the tables?  That design looks painful to deal with.   There is no nice way to set up a foreign key constraint...

Running your query with the SUM removed gets you 1 row.  So your sub-query is not working as you expect.

Looking at your data set though, are you sure...

Not sure on the warnings, but it sounds like the objects already exist and you are trying to drop something on top of them.
The error is because on the...

When you say DSN, I am assuming this is an ODBC connection?  If so, those do not store the password for the credentials.  You can verify this by looking at...

That changes things (good thinking Gail!).

The instead of trigger would change how the insert is performed.
I imagine you'd want to disable the trigger, do the insert, enable...