EXEC (@CMD)

I'll take Ray's suggestion 1 step further... Don't let the developer's even see the production database... create a developer's database as a "snapshot" of production, give them dbo privs to...

Dunno how it works in 2k5, but in 2k, you could open Enterprise Manager, right click on a table and select "Design Table"... the "Description" for each column is where...

SQL Server doesn't know how to spell "mapped drive"... you're stuck with the UNC approach... which isn't so bad... don't have to worry about the drive letter ever changing

Sorry I'm late with this reply...

The answer is...

.... rewrite sp_OA_portfolio_earnings to handle more than one row at a time.

Also (to add to what's already been said), you have a large number of implicit conversions that may slow things down... 1 (in code) is an implicit INT but you're columns...

Yes... I think you've done it the correct way for the right reason(s).  And such "partioning" of data is a tried and true method (although I don't care much for...

That number is correct... check in Books Online under "specifications-SQL Server objects"

Click on the Windows START button... open "ALL PROGRAMS" or some such.  Find the Microsoft SQL Server folder and click on it... find the QUERY ANALYZER icon and click on...

Please tell me you didn't add a dollar sign to some numeric data and store it as a varchar...

Gotta love embedded SQL... and not trying to be a snit about this... check out the discussing beginning to unfold at the following URL... it's similar to many other discussions...

Found another good reason not to use "parameterized scripts" as embedded SQL... see the following recent URL about the wrong execution plan being created...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=373799

"Precisely"

Going back to the basics, why not just create a linked server to the Access database and use SELECT/INTO?  Will create the table and copy the data rather "automagically"...

Heh... no... they only paid me the big bucks to round UP your minutes