Viewing 15 posts - 1,081 through 1,095 (of 3,543 total)
Ninja's_RGR'us (5/10/2011)
I knew I had missed something ovbious...Tx for the assist.
No worries, I had to read the post a few times to spot it myself 🙂
My only concern is what
Sorry,...
May 10, 2011 at 10:34 am
Ninja's_RGR'us (5/10/2011)
That gives you the result you want but I'm not sure about the way I'm getting there. Test it on your full dataset to confirm plz.
But that will...
May 10, 2011 at 10:28 am
Not quite, you are joining on on one part and filtering with the other
Try this
SELECT a.[ID],a.MACId
FROM dbo.Table_1 a
WHERE NOT EXISTS (SELECT * FROM dbo.Table_2 b WHERE b.[ID]=a.[ID] AND...
May 10, 2011 at 10:17 am
Steven993 (4/28/2011)
David Burrows (4/28/2011)
Steven993 (4/27/2011)
I actually have Date on Database Writings 2000-2006 under my eyes.
Chapter 8, 30 apges is dedicated to that topic.
p127
Definition
A table is normalized - equivalently, it is...
April 28, 2011 at 2:51 am
Steven993 (4/28/2011)
David Burrows (4/28/2011)
Steven993 (4/27/2011)
David Burrows (4/27/2011)
Your example shows violation of Codd's 1NF and is what I understood to be 1NF.
My example, you mean AddressLine table ? It's is not...
April 28, 2011 at 2:50 am
Steven993 (4/27/2011)
I actually have Date on Database Writings 2000-2006 under my eyes.
Chapter 8, 30 apges is dedicated to that topic.
p127
Definition
A table is normalized - equivalently, it is in first normal...
April 28, 2011 at 2:44 am
Steven993 (4/27/2011)
David Burrows (4/27/2011)
Your example shows violation of Codd's 1NF and is what I understood to be 1NF.My example, you mean AddressLine table ? It's is not a 1NF violation..
No...
April 28, 2011 at 2:42 am
Steven993 (4/27/2011)
David Burrows (4/27/2011)
April 27, 2011 at 10:42 am
David Portas (4/27/2011)
GSquared (4/27/2011)
April 27, 2011 at 8:07 am
S Hodkinson (4/27/2011)
April 27, 2011 at 6:41 am
hydbadrose (4/26/2011)
Ok so for the following script how would you change in whole;
As I already stated
Sample data to test with (important especially for ExecuteTime,...
April 26, 2011 at 9:41 am
hydbadrose (4/26/2011)
How about this statement? we were deviding by 3 to get the quarterly data.and DATEPART(MM, B.[ExecuteTime]) = DATEPART(MM, DATEADD(mm, -3, a.[ExecuteTime]))),0)/3.0 AS Data_Usage_Growth
That would give you an AVERAGE monthly...
April 26, 2011 at 8:51 am
Kiara (4/26/2011)
Got any to spare?
It'll rot your gut and make you blind 😛
April 26, 2011 at 5:31 am
hydbadrose (4/25/2011)
I used this script to get the quarterly growth, but I have to modify to get the monthly growth. Can you please help.
Remove the month selection in the WHERE...
April 26, 2011 at 4:37 am
Oh! And BTW I have seen some DBAs I would not like as my last line of defence :w00t:
April 25, 2011 at 6:03 am
Viewing 15 posts - 1,081 through 1,095 (of 3,543 total)