My guess would be that it's normal. The process by which the multiprocessor uses it's available cores is quite complex (I won't even pretend to know)

But I would assume it's...

Without having sample data, this is a "best guess"

SELECT

*

FROM

(SELECT

ROW_NUMBER() OVER (PARTITION BY ae.DM_AuditNurseID ORDER...

HMMM.....

Works fine for me.

DECLARE @f TABLE (ndex INT IDENTITY(1,1), pattern VARCHAR(90), fileType VARCHAR(256))

DECLARE

@fileVAR VARCHAR(99)

,@fileVar2 VARCHAR(99)

INSERT @f

SELECT 'a%.%',...

joshtheflame (3/17/2011)

---

I have the following stored procedure which is doing a perfect job and creating a matrix style output of 41 items and showing data day wise like [1]..........[31]

Now...

Susan-322874 (3/15/2011)

---

I need to modify a job that is on multiple servers and includes the servername in the job.

I have this (below), but it's not working, what am I doing...

Sorry, but this is incorrect. 😀

Whisper9999 (3/8/2011)

---

Thx. Out of curiosity, can I ask why they get rebuilt 3X? I assume one is when readd the PK it will rebuild them and then in...

GSquared answered your question. 😀

As well as it seems you have the answer in your own signature under "Cross Tabs and Pivots" :hehe:

Read up on the CASE statement in Books Online.

You're close. It's all in the placement of the parenthesis.

SELECT

Salesrep_Customerid

,SUM(PaymentAmount) - (SUM(Totalshippingcost) + SUM(Salestax1)) AS [Weekly Total]

FROM

...

Read up on GROUP BY and HAVING!

But the answer is something similar to...

SELECT account

FROM yourTable

GROUP BY address

HAVING count(*) > 1

your second approach seems more effective.

http://www.sqlservercentral.com/articles/Development/2824/

In the Report Builder, you should have the option to Open from Server. This would have the server's address.

you should have the web interface ....

something like http://<YOUR SERVER NAME>/Reports/Pages/Folder.aspx