ChrisM@Work

Forum Replies Created

Viewing 15 posts - 7,861 through 7,875 (of 10,143 total)

RE: Are the posted questions getting worse?

CirquedeSQLeil (5/25/2010)
Steve Jones - Editor (5/25/2010)
Chris Morris-439714 (5/25/2010)
LOLOAQICI82QB4IP
OK, I'm lost again
It's an addiction. He's losing sight of reality 😉
You're a bit behind, Jase.
LOLO = 'ello, ello...
^{“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

May 25, 2010 at 10:10 am

#1172209
RE: Interesting problem for the "Running Total/Quirky Update" method of removing cursors

Hi Robb, here's some stuff for you to play with. Note that the join to the recursive part in the rCTE is critical.
DROP TABLE #Numbers
SELECT TOP 1000000 --000
n =...
^{“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

May 25, 2010 at 9:51 am

#1172193
RE: Today's Random Word!

RBarryYoung (5/25/2010)
Chris Morris-439714 (5/20/2010)
RBarryYoung (5/19/2010)
Chris Morris-439714 (5/19/2010)
Young's modulus
Yes, and I'd appreciate your returning it too. 😛
:-D:-D
And not all bent-up like last time!
:w00t:
Huh? But that's why I said to 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

May 25, 2010 at 9:48 am

#1172191
RE: Are the posted questions getting worse?

LOLOAQICI82QB4IP
^{“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

May 25, 2010 at 8:58 am

#1172135
RE: Today's Random Word!

sing4you (5/24/2010)
Jack Black - that rare sippin' whiskey
Ardbeg 😉
^{“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

May 25, 2010 at 6:04 am

#1172004
RE: Today's Random Word!

Polymethylmethacrylate
^{“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

May 25, 2010 at 6:04 am

#1172003
RE: Are the posted questions getting worse?

Dave Ballantyne (5/25/2010)
UK Summer came and went yesterday.
LOL! More sunshine in three days than 2007 + 2008 + 2009.
It's still sunny here in Leamington Spa but there's a chill in...
^{“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

May 25, 2010 at 3:15 am

#1171941
RE: Interesting problem for the "Running Total/Quirky Update" method of removing cursors

Robb Melancon (5/24/2010)
So I'm running into the following:
The statement terminated. The maximum recursion 100 has been exhausted before statement completion
And looks like the max is 32,000, did you run this...
^{“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

May 24, 2010 at 9:26 am

#1171629
RE: Today's Random Word!

Shades 😎
^{“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

May 24, 2010 at 8:49 am

#1171607
RE: Interesting problem for the "Running Total/Quirky Update" method of removing cursors

Hi Robb
There were some performance comparisons posted here earlier in the year. IIRC the running totals update did a million rows in about 6 seconds, the rCTE method took a...
^{“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

May 24, 2010 at 8:47 am

#1171603
RE: Interesting problem for the "Running Total/Quirky Update" method of removing cursors

Robb, looks straightforward - but can you please edit and if necessary correct correct the line beginning -
So 75006 Daily is...
Cheers
ChrisM
^{“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

May 24, 2010 at 8:26 am

#1171589
RE: Calculation in group by query.

Pravin Patel-491467 (5/24/2010)
Hi Friends,
I have one result set which is as below.
--------------------Run below script in your query window.--------------------
GO
CREATE TABLE [dbo].[Child](
[Order_No] [int] NULL,
[Party] [varchar](50) NULL,
[Shipped_Cnt] [int] NULL
) ON [PRIMARY]
GO
Insert into [master]...
^{“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

May 24, 2010 at 8:10 am

#1171580
RE: Merging Resultsets

DROP table #t1
DROP table #t2
create table #t1 (catid int, orgid varchar(10))
create table #t2 (catid int)
insert into #t1 values (1,'PETER')
insert into #t1 values (2,'a01')
insert into #t1 values (3,'*')
insert into #t1 values...
^{“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

May 24, 2010 at 7:44 am

#1171561
RE: Interesting problem for the "Running Total/Quirky Update" method of removing cursors

Robb Melancon (5/21/2010)
Running SQL2008
Also Ten Centuries, your solution violates the rules of using the "Quirky Update" by using a Join. I'll add a link to the article on "Quirky...
^{“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

May 24, 2010 at 4:40 am

#1171457
RE: How to indicate rows with identical values in certain column

;with testcte (ID, PatientID, Drug, DatePrescribed, rnum)
as
(
select *,
row_number () over(partition by convert(varchar,DatePrescribed,101) order by DatePrescribed) as rnum
from #Prescriptions
)
select f.*,
case when coalesce(s.rnum, t.rnum) is not null then 'PossibleDrugSeeker' else...
^{“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

May 21, 2010 at 9:39 am

#1170922

Viewing 15 posts - 7,861 through 7,875 (of 10,143 total)