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...

You're a bit behind, Jase.

LOLO = 'ello, ello...

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 =...

Huh? But that's why I said to you...

LOLOAQICI82QB4IP

Ardbeg 😉

Polymethylmethacrylate

LOL! More sunshine in three days than 2007 + 2008 + 2009.

It's still sunny here in Leamington Spa but there's a chill in...

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...

Shades 😎

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...

Robb, looks straightforward - but can you please edit and if necessary correct correct the line beginning -

So 75006 Daily is...

Cheers

ChrisM

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]...

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...

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...