Viewing 15 posts - 50,791 through 50,805 (of 59,078 total)
By the way, MDevore, very nice formatting you did on your code. Makes for a really easy read. Nicely done!
May 2, 2008 at 6:43 pm
mdevore (5/2/2008)
HOLY CRAP! :w00t::w00t::w00t::w00t: I rewrote the query based on Jeff's Running Total post, and it went from 8 hours to 6 seconds! Jeff, I bow down before you! THANKS!!!!!!!
Heh......
May 2, 2008 at 2:52 pm
Post what you have for the view already, please.
Strange that something should require a view to work...
May 2, 2008 at 2:44 pm
Part of the problem is that you go back to delete the trailing comma... you basically do something like this...
DECLARE @somestring VARCHAR(8000)
SET @somestring = ''
SELECT...
May 2, 2008 at 8:09 am
And, you need that in a file 100,000 columns wide, right? You trolling here or ??? I ask because you asked for comma delimited in the first post...
May 2, 2008 at 7:39 am
shalini_pdi (5/2/2008)
I m getting error when i get the query based on some condition as i have mentioned in previous post
"I am getting the error as Violation of PRIMARY...
May 2, 2008 at 7:10 am
Obviously, I don't have your data nor the query that calculates the age of the invoices, but if you use the output of that query as a derived table in...
May 2, 2008 at 7:02 am
In SQL Server 2000, the absolute fastest way would be to insert the results of the query on the view into a temp table with an IDENTITY column and read...
May 1, 2008 at 9:10 pm
I very much appreciate the feedback... thanks.
I understand where you're coming from... been there myself... been burned by that very same thing. Now, I assume that all code, no...
May 1, 2008 at 9:00 pm
So, you're happy with the speed of a While loop? Might as well use a "fire hose" cursor if you're gonna do that.
May 1, 2008 at 8:02 pm
It only takes bulk admin privs... if your DBA won't allow you to have it, (s)he can give you privs to run a job that uses a proxy.
May 1, 2008 at 7:59 pm
Actually... no... not using Bulk Insert or BCP... they both require the headers to have the same number of delimiters as the "body" of the file even when you tell...
May 1, 2008 at 7:52 pm
Obviously, you'll need to group by something else other than the invoice number... can't you group by the customer number of something similar that spans invoices?
May 1, 2008 at 7:38 pm
Viewing 15 posts - 50,791 through 50,805 (of 59,078 total)