ChrisM@Work

Forum Replies Created

Viewing 15 posts - 7,081 through 7,095 (of 10,143 total)

RE: Today's Random Word!

Ray K (11/10/2010)
Chris Morris-439714 (11/10/2010)
Ray K (11/10/2010)
morning
Mornin' Ray. Smoke?
Not I. Never touch the stuff.
Drink, on the other hand . . .
At this time of the morning? :unsure: ok then...
^{“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

November 10, 2010 at 7:55 am

#1248892
RE: Help with SELECT query between certain time-frame

andrewd.smith (11/10/2010)
Either of these will work and stand a chance of using an index (if such an index exists) on the OrderDate column:
SELECT *
FROM dbo.ZNodeOrder NO
...
^{“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

November 10, 2010 at 7:51 am

#1248887
RE: Today's Random Word!

RichardDouglas (11/9/2010)
Banzai
Richard put the knife down, and the user 😀
^{“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

November 10, 2010 at 7:03 am

#1248843
RE: Today's Random Word!

Ray K (11/10/2010)
morning
Mornin' Ray. Smoke?
^{“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

November 10, 2010 at 7:02 am

#1248842
RE: Converting minutes into HH:MM

SELECT
OriginalMinutes= Minutes,
INTHours= Minutes/60,
INTRemainingMinutes = Minutes%60,
CHARHours= REPLACE(STR(Minutes/60,2), ' ', '0'),
CHARRemainingMinutes = REPLACE(STR(Minutes%60,2), ' ', '0'),
HoursAndMinutes= REPLACE(STR(Minutes/60,2), ' ', '0') + ':' + REPLACE(STR(Minutes%60,2), ' ', '0')
FROM (
SELECT 25...
^{“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

November 10, 2010 at 6:59 am

#1248840
RE: Help with SELECT query between certain time-frame

El Gato (11/10/2010)
Hi guys, our developer is not in today and I need help to generate the following query in a dynamic fashion:
SELECT *
FROM dbo.ZNodeOrder NO
INNER JOIN dbo.ZNodeOrderLineItem NOLI
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

November 10, 2010 at 6:13 am

#1248792
RE: Insert Statement not recognizing an existing field

sdabiri881 (11/10/2010)
Sorry, I have added the #Staging Table that the #Results table is pulling from for the OrganizationName field. Hope this makes sense. Thank you for your assistance...
^{“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

November 10, 2010 at 4:47 am

#1248763
RE: Trying to get counts with grouping

c-davifetr (11/9/2010)
Unfortunately I can’t put the data out. Too sensitive
Wise move - but you could make some up.
^{“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

November 9, 2010 at 8:20 am

#1248328
RE: Are the posted questions getting worse?

Alvin Ramard (11/9/2010)
Alvin Ramard (11/9/2010)
Chris Morris-439714 (11/9/2010)
[-- link deleted --] I know there are interested folks here - you can now buy one.
What a useless write up that was. ...
^{“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

November 9, 2010 at 8:00 am

#1248311
RE: Are the posted questions getting worse?

Alvin Ramard (11/9/2010)
Chris Morris-439714 (11/9/2010)
Steve you need to whack the quoted link too.
Done.
Thanks Alvin.
^{“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

November 9, 2010 at 7:54 am

#1248307
RE: Are the posted questions getting worse?

Steve you need to whack the quoted link too.
^{“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

November 9, 2010 at 7:45 am

#1248301
RE: Trying to get counts with grouping

c-davifetr (11/9/2010)
This seems to be close. I need to group on t.Web_Desc. Notice I have 4 Out-of-State Offender
45ArmstrongLifetime Offender1
NULLArmstrongOut-of-State Offender1
4ArmstrongOut-of-State Offender1
NULLArmstrongOut-of-State Offender1
14ArmstrongOut-of-State Offender 1
NULLArmstrongSexual Violent Predator1
18ArmstrongTen Year Offender1
Sorry, don't...
^{“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

November 9, 2010 at 7:38 am

#1248293
RE: Today's Random Word!

Daniel Bowlin (11/9/2010)
mbricker-600840 (11/9/2010)
payola
The $64,000 Question. (A bit of US TV trivia)
A bit? You're so lucky - it's all we ever get!
^{“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

November 9, 2010 at 7:14 am

#1248272
RE: Are the posted questions getting worse?

Colour Ereader announced (newscientist.com). I know there are interested folks here - you can now buy one.
^{“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

November 9, 2010 at 7:02 am

#1248255
RE: Trying to get counts with grouping

Award-winningly sketchy spec, but here goes:
SELECT
offenders = Agg.OffendersOfThisTypeInThisCounty,
m.County_Name,
m.Web_Desc,
'1' AS 'Address_Type'
FROM (
SELECT c.County_Code, c.County_Name, t.Offender_Type_LKP_ID, t.Web_Desc
FROM SPGlobalLookups.dbo.County_LKP c
CROSS JOIN dbo.Offender_Type_LKP t
) m
LEFT JOIN (
SELECT o.Offender_Type_LKP_ID, a.County_Code, OffendersOfThisTypeInThisCounty = COUNT(*)
FROM...
^{“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

November 9, 2010 at 6:55 am

#1248249

Viewing 15 posts - 7,081 through 7,095 (of 10,143 total)