Viewing 15 posts - 361 through 375 (of 1,183 total)
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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMarch 18, 2011 at 12:33 pm
Without having sample data, this is a "best guess"
SELECT
*
FROM
(SELECT
ROW_NUMBER() OVER (PARTITION BY ae.DM_AuditNurseID ORDER...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMarch 18, 2011 at 12:22 pm
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%.%',...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMarch 18, 2011 at 12:13 pm
joshtheflame (3/17/2011)
Now...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMarch 17, 2011 at 6:29 am
Susan-322874 (3/15/2011)
I have this (below), but it's not working, what am I doing...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMarch 15, 2011 at 12:58 pm
ChazMan (3/8/2011)
be careful how you remove your PK. If you script it with a drop, dropping a clustered index will delete the table.
Sorry, but this is incorrect. 😀
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMarch 8, 2011 at 10:47 am
Whisper9999 (3/8/2011)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMarch 8, 2011 at 10:46 am
GSquared answered your question. 😀
As well as it seems you have the answer in your own signature under "Cross Tabs and Pivots" :hehe:
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMarch 1, 2011 at 1:59 pm
Read up on the CASE statement in Books Online.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMarch 1, 2011 at 1:33 pm
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
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 19, 2011 at 1:25 pm
Read up on GROUP BY and HAVING!
But the answer is something similar to...
SELECT account
FROM yourTable
GROUP BY address
HAVING count(*) > 1
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 19, 2011 at 11:46 am
your second approach seems more effective.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 14, 2010 at 8:51 am
http://www.sqlservercentral.com/articles/Development/2824/
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 14, 2010 at 6:52 am
In the Report Builder, you should have the option to Open from Server. This would have the server's address.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 16, 2010 at 8:48 am
you should have the web interface ....
something like http://<YOUR SERVER NAME>/Reports/Pages/Folder.aspx
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 16, 2010 at 8:27 am
Viewing 15 posts - 361 through 375 (of 1,183 total)