ChrisM@Work

Forum Replies Created

Viewing 15 posts - 7,756 through 7,770 (of 10,143 total)

RE: Today's Random Word!

Ben & Jerry's
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 24, 2010 at 7:29 am

#1184486
RE: Today's Random Word!

lagniappe
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 24, 2010 at 6:44 am

#1184463
RE: Expression for converting a string variable represnting time to minutes

da-zero (6/24/2010)
arik_beri (6/24/2010)
Thanks Chris, it sure looks much more simple that way.
But yet it still doesn't work. When I copied this expression to the expression column in the SSIS edit...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 24, 2010 at 6:27 am

#1184456
RE: Expression for converting a string variable represnting time to minutes

Have you tried using datetime functions for this?
SELECT DATEDIFF(mi, '1900-01-01 00:00', '1900-01-01 ' + '00:45')
SELECT DATEDIFF(mi, '1900-01-01 00:00', '1900-01-01 ' + '01:00')
SELECT DATEDIFF(mi, '1900-01-01 00:00', '1900-01-01 ' + '01:01')
SELECT DATEDIFF(mi,...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 24, 2010 at 5:02 am

#1184422
RE: Problem with Group by clause

It's still a little unclear what you are trying to do, but I think it's a filter.
So,
WHEN @timespan = 'YTD'
you want to return data within...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 24, 2010 at 4:33 am

#1184419
RE: Problem with Group by clause

Shintu (6/24/2010)
Still it is giving the same error .
Is there any problem in the group by clause ?
Subhro
Yes
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 24, 2010 at 4:09 am

#1184409
RE: Are the posted questions getting worse?

Steve Jones - Editor (6/23/2010)
Is this soccer stuff over today?
England vs Slovenia is in progress.
Perhaps that should have read Slovenly vs Slovenia 😀
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 23, 2010 at 8:37 am

#1183985
RE: Today's Random Word!

Ray K (6/23/2010)
Harpoon
(more the beer than the weapon)
Tactical Nuclear Penguin
(more of a weapon than a beer) 😀
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 23, 2010 at 8:14 am

#1183955
RE: Get Calender Days

Vinay Theethira (6/23/2010)
I have got MailDate with me. I just need to check the condition weather MailDate>=CalenderDays. Please help me out.
If the column 'CalendarDays' isn't in the table which contains...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 23, 2010 at 7:55 am

#1183930
RE: Problem in Stored Procedure

The choices in your CASE resolve to constants.
-- WHEN @sortby = 'YTD'
GROUP BY cp.Device_Type_Code, c.Perfect_Journey_Tech_Exception_Flag, 2010
-- WHEN @sortby = 'Q2 2010'
GROUP BY cp.Device_Type_Code, c.Perfect_Journey_Tech_Exception_Flag, 2
-- WHEN @sortby = 'June 2010'
GROUP...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 23, 2010 at 7:27 am

#1183910
RE: Today's Random Word!

CirquedeSQLeil (6/21/2010)
Trey Staker (6/21/2010)
dbowlin (6/21/2010)
Like they say....it's not the heat, it's the humidity.
So true, I also spent 2 weeks in Huston in August in 90 degree weather and it felt...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 22, 2010 at 2:11 am

#1183132
RE: SQL Server 2005 Query View

The date filter in the WHERE clause will work much more efficiently if the date can be compared directly to a lower and upper bound without any transformation. The expression...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 21, 2010 at 7:36 am

#1182726
RE: Basic Script Help!

Looks like an UPDATE to me.
UPDATE docsadm.shellorganisation
SET [disabled] = 'y'
WHERE docsadm.shellorganisation.org_name LIKE 'do not use%'
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 21, 2010 at 3:07 am

#1182607
RE: Basic Script Help!

What are you trying to do here? Insert new rows into shellorganisation, or update existing rows?
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 21, 2010 at 2:56 am

#1182600
RE: Are the posted questions getting worse?

Gianluca Sartori (6/21/2010)
CirquedeSQLeil (6/20/2010)
.....
Haha - maybe I should have made a few bets this last week.:-D
Horrible match. Looks like the "world champions" have disappeared.
Just a few notes:
1. Killen should...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 21, 2010 at 2:45 am

#1182588

Viewing 15 posts - 7,756 through 7,770 (of 10,143 total)