Viewing 15 posts - 7,861 through 7,875 (of 10,144 total)
Please fully identify the entity - which you want to use in your WHERE clause - which can have values of 66 or 77. You've referred to it loosely as...
May 26, 2010 at 5:49 am
CirquedeSQLeil (5/25/2010)
Steve Jones - Editor (5/25/2010)
Chris Morris-439714 (5/25/2010)
LOLOAQICI82QB4IPOK, I'm lost again
It's an addiction. He's losing sight of reality 😉
You're a bit behind, Jase.
LOLO = 'ello, ello...
May 25, 2010 at 10:10 am
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 =...
May 25, 2010 at 9:51 am
RBarryYoung (5/25/2010)
Chris Morris-439714 (5/20/2010)
RBarryYoung (5/19/2010)
Chris Morris-439714 (5/19/2010)
Young's modulusYes, 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...
May 25, 2010 at 9:48 am
sing4you (5/24/2010)
Jack Black - that rare sippin' whiskey
Ardbeg 😉
May 25, 2010 at 6:04 am
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...
May 25, 2010 at 3:15 am
Robb Melancon (5/24/2010)
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...
May 24, 2010 at 9:26 am
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...
May 24, 2010 at 8:47 am
Robb, looks straightforward - but can you please edit and if necessary correct correct the line beginning -
So 75006 Daily is...
Cheers
ChrisM
May 24, 2010 at 8:26 am
Pravin Patel-491467 (5/24/2010)
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]...
May 24, 2010 at 8:10 am
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...
May 24, 2010 at 7:44 am
Robb Melancon (5/21/2010)
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...
May 24, 2010 at 4:40 am
Viewing 15 posts - 7,861 through 7,875 (of 10,144 total)