Thanks for the feed back, JJ.

OK, sure.

First case:

jmclain (8/1/2008)

---

(almost)Solution 1 (that currently doesn't work):

...

CREATE PROCEDURE [dbo].[POXML](

@strXML VARCHAR(2000)

)

...

EXEC sp_xml_preparedocument @XMLDocPointer OUTPUT, @strXML

BEGIN TRANSACTION

INSERT INTO PO(PO_ID, PO_DATE, CUST_PO_NBR, po_rcvd_dttm)

SELECT '1', podate,...

Please, explain?

Try this instead:

With cteServers as (

Select PC.PC

,PC.PC_DomainName

, Disks.Disk_Desc

, Row_Number() Over(Partition by Disks.Disk_Desc order by Disks.Disk_Desc) as N

From PC

LEFT JOIN...

dbaker (8/4/2008)

---

firstly the usp_databases.txt in author's "Resources:" is ugly with cursors and dynamic-SQL

- better solution (for SQL200x) might have been

...

exec sp_MSforeachdb 'use[?];

...

Question: are you using CHAR or VARCHAR? I ask because RTRIM and LTRIM probably do not work the way you expect for CHAR. Remember, they're not variable in...

Right. The resource hit to do this in the database is not usually significant, however, it does "uglify" the code and lead to secondary costs as Jeff W pointed...

For many years I worked as a Capacity Planning Consultant, first for Digital, then later on my own. Capacity planning is a lost art now, but was pretty big...

Heh, right. The section with the cursor is not necessary, just delete it.

This should do it:

;With cteServers as (

Select server

, logical_disk

, Row_Number() Over(Partition by server, order by logical_disk) as N

From Servers

)

Select...

Oh yeah, I remember that one from way back. Heh.

Actually, after re-reading your original post, I think that I misunderstood what you were asking for and that Jeff is right.

Oops, sorry. Didn't see this until now. Well, glad you worked it out...

Try this:

--====== Change Cursor to Temp table

Select Identity() as ID

, *

--move all of the temp variables here too

, Coalesce((SELECT MSALESNBR

FROM USER_STAGE.dbo.BOOKING_FACT_EXT_CUSTOMER

WHERE MSALESNBR = TMSalesNbr

), 0) as TMTo1Flag

,...

What's the maximum number of logical drives per server?