Viewing 15 posts - 1,081 through 1,095 (of 3,544 total)
This will give you hours and minutes which you can then format into HH:MM or how you wish.
WITH cte (HH,MM)
AS (SELECT
CAST(LEFT([Data Team],2) as int)+CAST(LEFT([CRM],2) as int)+CAST(LEFT([IM Team],2) as...
Far away is close at hand in the images of elsewhere.
Anon.
May 11, 2011 at 9:49 am
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,...
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
April 28, 2011 at 2:42 am
Steven993 (4/27/2011)
David Burrows (4/27/2011)
Far away is close at hand in the images of elsewhere.
Anon.
April 27, 2011 at 10:42 am
David Portas (4/27/2011)
GSquared (4/27/2011)
Far away is close at hand in the images of elsewhere.
Anon.
April 27, 2011 at 8:07 am
S Hodkinson (4/27/2011)
Far away is close at hand in the images of elsewhere.
Anon.
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,...
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
April 26, 2011 at 8:51 am
Kiara (4/26/2011)
Got any to spare?
It'll rot your gut and make you blind 😛
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
April 26, 2011 at 4:37 am
Viewing 15 posts - 1,081 through 1,095 (of 3,544 total)