ChrisM@Work

Forum Replies Created

Viewing 15 posts - 9,961 through 9,975 (of 10,143 total)

RE: SUM divided by COUNT Issue

Try this, Ryan:
SELECT "Agent Group (Name & #)",
"Application (Name & #)",
"Agent (Name & #)",
"Total Calls",
"Total Talk" / "Total Calls" AS "Average Talk",
"Total Hold" / "Total Calls" AS "Average...
^{“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

February 29, 2008 at 4:31 am

#783670
RE: Please add a custom 404 page in maintenance mode

Confirmed. Can't remember what the message was, but it suggested that something had changed in our firewall!
Funny thing is, each of the three forums (fora?) I spend most time on...
^{“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

February 27, 2008 at 8:12 am

#782545
RE: Matching names & addresses between tables

antonio.collins (2/14/2008)
With that many addresses, you might want to look into the USPS address matching system. With it, you can cleanup and standardize mailing addresses, city, state, zips. ...
^{“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

February 14, 2008 at 1:59 pm

#778583
RE: Matching names & addresses between tables

of course, and the best approach I've seen yet in terms of both accuracy and speed is QA batch. But not everybody is prepared to pay for it....
^{“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

February 14, 2008 at 12:31 pm

#778543
RE: Case statement

Simple CASE:
CASE SalesProb WHEN 0 THEN...
Searched CASE:
CASE WHEN SalesProb = 0 THEN...
Searched CASE is more expensive than simple CASE.
Either way you will need a column assignment:
,NewColumn = CASE...END
or
,CASE...END...
^{“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

February 13, 2008 at 9:56 am

#777934
RE: Converting Getdate() To Varchar

D'oh!:blush:
^{“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

February 6, 2008 at 10:22 am

#775706
RE: Converting Getdate() To Varchar

Here's a couple of ideas.
DECLARE @Now DATETIME
SET @Now = GETDATE()
SELECT @Now
SELECT CAST(datepart(yy, @Now) AS CHAR(4)) +
RIGHT('0'+LTRIM(cast(datepart(mm, @Now) as VARCHAR(2))), 2) +
RIGHT('0'+LTRIM(cast(datepart(dd, @Now) as VARCHAR(2))), 2) +
RIGHT('0'+LTRIM(cast(datepart(hh, @Now)...
^{“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

February 6, 2008 at 10:21 am

#775705
RE: need help with this query please?

Blair
Two minuses like this flags the rest of the line as a comment.
Peso's solution is a perfect and extremely elegant solution to the problem as originally described - does...
^{“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

February 6, 2008 at 9:02 am

#775656
RE: ISOLATION LEVELS and LOCKS

Karthik
No locks will be held.
Until you do something. What do you want to do with the tables? SELECT? UPDATE? INSERT?
Enter "Isolation level" (without the double quotes) into the search tab...
^{“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

February 6, 2008 at 8:58 am

#775652
RE: Get DATE part of the DATETIME

jcrawf02 (2/6/2008)
Because we just have to be different. I'm going to go get my 'twelve barley-corns, round and dried' to measure something now . . .
Nah, pretty sure it...
^{“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

February 6, 2008 at 8:07 am

#775611
RE: Get DATE part of the DATETIME

jcrawf02 (2/6/2008)
why am I getting times in the result for all of these, when I want only the date portion?
Curious - can you post what you've tried, with the results?
^{“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

February 6, 2008 at 7:16 am

#775569
RE: need help with this query please?

If not, this will help:
http://www.sqlservercentral.com/Forums/Topic424213-338-1.aspx
😀
^{“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

February 5, 2008 at 11:30 am

#775262
RE: need help with this query please?

Blair Dee (2/5/2008)
no, trust me, its not homework - i wish it was. it is for my job - a healthcare facility that uses another area hospital's pharmacy services...
^{“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

February 5, 2008 at 10:56 am

#775247
RE: need help with this query please?

So you're looking to match, one for one, your sales & refunds, and examine what's left?
^{“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

February 5, 2008 at 10:52 am

#775246
RE: need help with this query please?

This looks suspiciously like homework to me! However...here's half of what you need...
DROP TABLE #Widgets
CREATE TABLE #Widgets (TranDate DATETIME, Product VARCHAR(10), quantity INT, value MONEY)
INSERT INTO #Widgets (TranDate, Product, quantity,...
^{“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

February 5, 2008 at 10:43 am

#775239

Viewing 15 posts - 9,961 through 9,975 (of 10,143 total)