Viewing 15 posts - 56,131 through 56,145 (of 59,078 total)
Sorry I'm late with this reply...
The answer is...
.... rewrite sp_OA_portfolio_earnings to handle more than one row at a time. ![]()
June 14, 2007 at 6:35 pm
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...
June 14, 2007 at 6:26 pm
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...
June 14, 2007 at 6:04 pm
That number is correct... check in Books Online under "specifications-SQL Server objects"
June 14, 2007 at 5:25 pm
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...
June 14, 2007 at 5:19 pm
Please tell me you didn't add a dollar sign to some numeric data and store it as a varchar...
June 14, 2007 at 5:11 pm
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...
June 14, 2007 at 6:41 am
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
June 14, 2007 at 6:38 am
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"...
June 13, 2007 at 8:39 pm
Heh... no... they only paid me the big bucks to round UP your minutes ![]()
June 13, 2007 at 8:26 pm
Why can't you change it? Because it's 3rd party???? or ????
June 13, 2007 at 12:07 pm
You're saying the format of a given text file changes a lot??? Do the text files have header information on the first line of the file?
June 13, 2007 at 12:03 pm
Nope... can't be done in EM... open the view code in Query Analyzer first... save the old code... copy the code to EM... experiment with changes... copy/type the changes into Query...
June 13, 2007 at 11:59 am
That's cool... do you know if table variables still have the same fault of not being able to use statisics and not be alterable once formed?
June 13, 2007 at 11:51 am
Viewing 15 posts - 56,131 through 56,145 (of 59,078 total)