OK, but it's a massive thing. Since it's an Access query, it uses sum queries instead of subqueries. All of the subqueries simply (right....) add up budgets or expenses by...

I'm really impressed you'd offer. Thank you so much...but....

The query summarizes budgets and expenses for projects, equipment, and category. There may be projects with expenses and no budgets, budgets with...

I used SSMA to create the SS2k5 database. I do refresh it every week or so as I go about modifying queries and forms in the Front End to be...

Wow, guys, this is exactly what I needed...an actual objective that required me to learn some new stuff. Unfortunately, my client is still on SS2005, so I was stuck using...

@ninja -- It'll take alot to flush my frustrations. I am enjoying learning, and I appreciate your help. Thank you.

@3 -- I tried a dataflow task using full...

@ninja -- I'm an old guy. Be nice to me.

My issue is with scope. I lose the SS variables when the query is executed. What's the strategy...

Perfect, the execute statements work.

Now, I need to execute the "drop... " statements, then the "truncate" statements, then upload the data from Access, then execute the "Add constraint" table...

Just tried that. Exceeds nvarchar(max) limit....

Probly need to execute one at a time.

On second thought. It simply didn't print the whole command. Maybe it's a limitation of the print command....?

OK, I've been focusing on having it totally automated...taking the output from the FK query and executing those commands immediately, rather than cust/paste. Lemme rescope....

Thanks.

Sorry, this is my first foray into SQL generates SQL. I have the query that creates two temp tables. At the end of the query, it simply selects all the...

@nacarls: That's not a horrible idea, but I'm using A2007, have 103 tables, over 100 forms, over 100 queries, etc. I don't use unique A2007 data structures, but...

Oops, sorry. I figured that one out. I was asking about the script to remove and replace the FKs. It produces two tables, one after the other. Do I make...

Wow, you responded to my first message before I could flounder my way into opening up VS2008 and starting up a "package". When I did that, I found your "Execute...

Thank you so much....

OK, I finally got around to copying that script over to my client's development machine, and then over to my client's SQL Server machine (dedicated to my...

That would be great, except a worker can have multiple timesheet entries (with possibly different Labor Rates) on the same day. In fact, the whole labor rate thing revolves around...