By the way, MDevore, very nice formatting you did on your code. Makes for a really easy read. Nicely done!

Heh......

Post what you have for the view already, please.

Strange that something should require a view to work...

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...

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...

shalini_pdi (5/2/2008)

---

Hi Jeff

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...

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...

Heh... NO! 😛

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...

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...

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.

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.

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...

You bet... thanks for the feedback.

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?