I couldn't say for sure, but Yeah, I would think that you could.

Thanks, Grant. I guess I'll download RC0 then.

Perry Whittle (8/6/2008)

---

i would have thought judging by your avatar you would say

"i...

OK, got it:

Select TOP 99999999 devices.Name

, CIM_LogicalDisk.Description

, CIM_LogicalDisk.WIN32_Size

, CIM_LogicalDisk.dc_SpaceUsed

, Identity(int) as ID

, Cast(0 as int) as N

Into #Serverstemp5

From devices

...

Bill; one of the rules is "No Loops". "WHILE..." is a loop.

Arrgh! Sorry, bug in my script. Please re-execute with this script.

Select top 8

'INSERT Into dbo.devices Select '

, DeviceKey

, ', '''+Name+'''' +', '

, ProductType

, ', '''+ProductTypeStr+''''

, ', '''+ProductName+''''

From...

"INNER JOIN" is an Abelian operator, meaning that like addition and multiplication, you get the same result no matter what order they are done.

OUTER Joins are NOT, however, so order...

Thanks Greg. Glad you liked the article.

I really need some sample data, to see what's going on for you. Please execute the following commands...

We're going to need the table defs and some sample data to take this any further. Please see this article for guidelines on providing this:http://www.sqlservercentral.com/articles/Best+Practices/61537/

Q: How many Jeff Moden's does it take to change a light bulb?

A: One. Any more would obviously be RBAR.

Q: How many lightbulbs does Jeff Moden take to change...

When you adapt the code to your table defs (which I haven't seen), you need to make sure that you keep the name changes straight. Try this:

Update s

Set...

Undetailed, unhelpful reply that duplicates previous reply.

Jeff Moden (8/5/2008)

---

Heh... couldn't resist, Barry.

Hey! Are you going to PASS this year? Sure would like to do some 12 oz. curls with ya someday. Bring your...

ROTFL!

You definitely have too much time on your hands, Jeff.