Understand the SQL, especially on SQL Server, works best as a set-manipulation language, not as a procedural language. The standard approach to this type of problem is NOT to...

Well, the total IO is understandable, since you are updating every row in the table as well as every entry in 3 indexes, what surprises me is that the Writes...

Blair Dee (8/19/2008)

---

no i am not using the view designer - not even sure how to get into that....

No, both sys.tables and sys.objects are better than sysobjects.

Wait a minute,... you aren't using the View Designer, are you?

Could you please select your entire query window and post it, unedited here?

I don't know what to tell you. If you are using my code verbatim, then there is no way that you should be getting a CURSOR error.

All you need to do is modify the DECLARE statment:

Declare @sql AS varchar(max)

Set @sql = 'Update T

Set '

Select @sql = @sql

+ CASE When ORDINAL_POSITION = 1 Then '...

Yes, it does matter, and yes you should have mentioned that before. In...

blnbmv (8/18/2008)

---

I have a cursor and in the declaration of the cursor there is a join and I want to stop further opening the cursor if there are any non...

OK, you might want this modification then:

Declare @sql varchar(max)

Set @sql = 'Update T

Set '

Select @sql = @sql

+ CASE When ORDINAL_POSITION = 1 Then ' ' Else ', '...

Glad I could help.

This should work:

Declare @sql varchar(max)

Set @sql = 'Update T

Set '

Select @sql = @sql

+ CASE When ORDINAL_POSITION = 1 Then ' ' Else ', ' End

+ '['+COLUMN_NAME+'] = Replace(['+COLUMN_NAME+'],...

Are they really all string fields?

Try this:

Select Key, Quantity1 as [Quantity] From tbl

Union All Select Key, Quantity2 as [Quantity] From tbl

Union All Select Key, Quantity3...