ChrisM@Work

Forum Replies Created

Viewing 15 posts - 2,116 through 2,130 (of 10,143 total)

RE: Are the posted questions getting worse?

Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Oh, and maple beer - yuck.
This made me spill my ESB all over the Pub...
^{“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

October 1, 2015 at 8:09 am

#1830778
RE: Are the posted questions getting worse?

Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Oh, and maple beer - yuck.
This made me spill my ESB all over the Pub lunch
😎
Where have you...
^{“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

October 1, 2015 at 7:46 am

#1830762
RE: Are the posted questions getting worse?

David Burrows (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Oh, and maple beer - yuck.
This made me spill my ESB all over the Pub lunch
😎
Where have you found ESB on draught?
Many many moons...
^{“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

October 1, 2015 at 7:26 am

#1830752
RE: Like Statement With Parameters

Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
Here is a quick solution that fits nicely for simple usage.
😎
Your plan shows a seek for a double-wildcarded parameter...must play with this at home. Thanks...
^{“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

October 1, 2015 at 7:25 am

#1830751
RE: Are the posted questions getting worse?

Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Oh, and maple beer - yuck.
This made me spill my ESB all over the Pub lunch
😎
Where have you found ESB 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

October 1, 2015 at 7:20 am

#1830749
RE: Syntax question

It might be more efficient to aggregate just the data you need to:
select --distinct
'On-Demand' as 'Business Line',
o.OrderID as 'Order #',
isnull(d.DisplayCode,'UNK') as Hub,
isnull(rz.RouteID,'UNK') as 'Default Route',
'On-Demand' as 'Assigned Route',
o.DestAddress,
o.DestZip,
C.LocalName,
C.CustID,
DATENAME(dw,o.OrderDate) as 'DoW',
DATENAME(ww,o.OrderDate)...
^{“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

October 1, 2015 at 7:03 am

#1830741
RE: Are the posted questions getting worse?

BWFC (10/1/2015)
ChrisM@Work (10/1/2015)
jasona.work (10/1/2015)
BL0B_EATER (10/1/2015)
Talking about pork products, any one understand Sausage with Maple? I don't..
I do...
Mmmm...
Sausage (breakfast sausages) with syrup on them is goooddd.
As for a maple ale /...
^{“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

October 1, 2015 at 6:45 am

#1830726
RE: Are the posted questions getting worse?

Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Oh, and maple beer - yuck.
This made me spill my ESB all over the Pub lunch
😎
Where have you found ESB on draught?
The Ale&Pie ...
^{“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

October 1, 2015 at 6:41 am

#1830723
RE: Are the posted questions getting worse?

Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Oh, and maple beer - yuck.
This made me spill my ESB all over the Pub lunch
😎
Where have you found ESB on draught?
^{“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

October 1, 2015 at 6:19 am

#1830716
RE: Are the posted questions getting worse?

jasona.work (10/1/2015)
BL0B_EATER (10/1/2015)
Talking about pork products, any one understand Sausage with Maple? I don't..
I do...
Mmmm...
Sausage (breakfast sausages) with syrup on them is goooddd.
As for a maple ale / beer, I...
^{“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

October 1, 2015 at 6:00 am

#1830710
RE: Left join vs Exists

mihir.nasikkar 40164 (10/1/2015)
SELECT DISTINCT mv.meetID,
mv.FundID,
CASE WHEN vcv.vote IS NULL
THEN mv.VoteFlag
ELSE (CASE WHEN vcv.vote IN ('<Unknown>','Refer','','Did Not Vote','None') 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

October 1, 2015 at 5:51 am

#1830706
RE: Like Statement With Parameters

Eirikur Eiriksson (10/1/2015)
Here is a quick solution that fits nicely for simple usage.
😎
Your plan shows a seek for a double-wildcarded parameter...must play with this at home. Thanks for posting, Eirikur.
^{“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

October 1, 2015 at 5:35 am

#1830702
RE: Are the posted questions getting worse?

Brandie Tarvin (10/1/2015)
BrainDonor (10/1/2015)
BL0B_EATER (10/1/2015)
Talking about pork products, any one understand Sausage with Maple? I don't..
I've been to Canada more times than I can recall - maple with pretty much...
^{“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

October 1, 2015 at 5:12 am

#1830698
RE: Adding zeros into date column

zedtec (10/1/2015)
Hi,
I have a date column (not datetime) in SQL Server and the dates are in the format yyyy-mm-dd
I need to replace the date values with zero's so it looks...
^{“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

October 1, 2015 at 4:41 am

#1830691
RE: Are the posted questions getting worse?

BL0B_EATER (10/1/2015)
Talking about pork products, any one understand Sausage with Maple? I don't..
It's surely what you are used to? Pork & apple in the UK. Never tried sausages & maple...
^{“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

October 1, 2015 at 4:13 am

#1830685

Viewing 15 posts - 2,116 through 2,130 (of 10,143 total)