Set ServerName=ArgObj.Item(0)

should be changed to

ServerName=ArgObj.Item(0)

because in VBScript Set is used to assign objects only, not primitive types.

Hope this helps

Gianluca

END TRAN is not needed, it's not even a valid command.

Transactions begin with BEGIN TRAN and are terminated by a COMMIT or a ROLLBACK command.

Get rid of END TRAN and...

I think char/varchar will suit.

IN doesn't work that way. Every single value must be a variable on its own, so that you can use IN(@value1, @value2, ..., @valueN).

You could use a table variable to...

Thanks, Tom. So, you're a Scot, aren't you?

jcrawf02 (4/20/2010)

---

Gianluca Sartori (4/20/2010)

---

Tom.Thomson (4/19/2010)

---

I haven't been hit by it yet, but I'm supposed to be flyin from...

@Grant, looks a lot like cut'n paste. Would be nice to know the source.

anthony_merriwether (4/19/2010)

---

If the truth be known, I too agree that a person should strive to solve a problem no matter what it is, by due diligence and at the very...

Using Pivot and Unpivot

Your post covers everything and it covers nothing. I suggest sticking to the OP's issue and waiting for more info. I'm sure he will appreciate the effort, but I don't...

You could use the split function I posted in the 2005 forum and do it this way:

DECLARE @temp TABLE (

name VARCHAR(50)

)

INSERT INTO...

I'm doing the quite the same thing with a linked server, but the two databases reside on the same sql cluster and there's no VPN complexity involved.

I like the Web...

You could also use a windowed aggregate with a slight trick:

DECLARE @Recent TABLE (

Link varchar(500),

click int,

vote int

)

INSERT INTO @Recent VALUES('google',1,5)

INSERT INTO @Recent VALUES('google',2,3)

INSERT INTO @Recent VALUES('google',1,2)

INSERT INTO @Recent VALUES('yahoo',3,1)

INSERT INTO...

You could use a subquery:

WITH MyTable AS

(

SELECT TOP(100) Link,COUNT(*) AS num,SUM(click) AS click,SUM(vote)AS vote FROM

Recent

GROUP BY Link

ORDER BY num DESC

)

SELECT *, NUM = (SELECT SUM(num) FROM MyTable)

FROM MyTable

It should translate to this:

SELECT CPU_Util.CPU_SERVER,

CPU_Util.CPU_UTIL,

...