Update: I've found that the underlying code in the DLL uses the STRING data type for the things that take string data... in C#, that holds 2 billion bytes...

ps... I've found the following URL and I'm in the process of reading all the links contained in it...

http://support.microsoft.com/kb/312839

Even if you don't have a better place to look, I sure...

So take one of the solutions already given and use it as a derived table in and aggregate query.

Yep... Sergiy is...

jfbergeron (8/25/2008)

---

Hi,

I have an issue with using openrowSet:

When using on real data, i got several products that with double quotes in the description, and caused me problems.

Here is an example:

ProductID...

jfbergeron (8/20/2008)

---

Finally got it to work! There was an error with my login, it was not in the right order, needed to put 'Sa' as the third paremeter, not the...

bitbucket (8/25/2008)

---

na.netjob - you provided some, just some answer to Jeff Moden's question, but NOT enough to allow someone to really help you.

Unanswered is how do you want...

sql_er (8/25/2008)

---

Thanks for all the suggestions.

I was able to fix the problem without adding an index, but just re-writing the query.

It was strange how a very simple change in the...

If the clustered key is set by date or, perhaps, identity and the identity column is indicative of entry order, then sectional deletes (or insert to archive, delete from source)...

Agh! My bad... I didn't read the original post as well as I should have. Throwing in a partitioned row number along with the a method similar to...

sandeep kumar (8/25/2008)

---

Use of while loop is equivalent of a read only, forward only cursor which won't save anything. SET based approch is the best way to remove the cursor...

Carl Federl (8/25/2008)

---

"could you post a copy of the code that fixed your parameter sniffing problem?"

This application is running under SQL Server 2000 and the analysis consisted of...

skenzie (8/25/2008)

---

And thanks Jeff for spurring me on, even at my age....heh heh. I'm going to apply for the job but making it clear I have no actual qualifications but...

Amit Khanna (8/25/2008)

---

Hi Sg,

WITH C_TEMP AS

(

SELECT T.num,T.OP_Bal,T.quantity,T.OP_Bal + T.quantity AS Closing_Bal

FROM #Temps T

WHERE T.num...

Still doesn't tell me a thing... like I said, tell us exactly what you want by giving us an example of the inputs...