Jeff:

Over the last few months, I've lost track of what all of the conditions are to make the UPDATE "pseudocursor" trick work. What I recall is:

...

Plus, whether the plan is in the cache is one thing, and whether it can actually be re-used is an entirely different matter.

Jeff Moden (10/8/2008)

---

I remember... it's a pretty tough task because it's not just quotes that Sergiy has to worry about with the data he showed me. It's data from...

Peso (10/7/2008)

---

Did you find the time to tset my suggestion, ie run the query manually vs the vendor-provided query?

Was there a time difference? Was the plan different?

I believe the query...

Well, it...

Ah. This is a SQL Server 2005 forum. Are you on SQL Server 2005?

Ummm. This statement:

Jason (10/8/2008)

---

These are the options in the Configuration Manager:

...

* SQL Server 2005 Network Configuration (32 bit)

nothing under this node

* SQL Native Client Configuration...

Okay, here is a static example for 50 columns:

/*

Simple Static Pivot/Cross-Tab Example:

*/

--====== Create really cool test data

Select distinct Table_name as [State], Column_name as [City]

Into #Cities

From INFORMATION_SCHEMA.COLUMNS

--====== Static Cross-Tab:

;WITH...

*sigh* Hookay. 50 it...

Glad we could help!

On both the Client Configuration and the Server configuration? (note that there is a separate branch for each in the Configuration Manager).

I wish I could say that's never happened,...

I hope so! 😀

Is that the tough chewy part?

I cannot tell you about your specific script. However, if SSMS works, then SMO is already installed.