:blush:

TheSQLGuru (2/25/2015)

---

I think this is just a variant of the "gaps and islands" problem, for which there are many solutions. Binoogle itzik ben-gan gaps and islands to find a...

Solomon Rutzky (3/1/2015)

---

dwain.c (2/24/2015)

---

There's a loan amortization example here: Exploring Recursive CTEs by Example[/url]

It won't be as fast as a QU approach, but the example does handle multiple loans and...

Solomon Rutzky (2/25/2015)

---

Hi Dwain,...

And now for all of you conspiracy buffs:

How crazy am I?

The Spoof[/url]

That is the most fascinating thing I've read in a long, long time.

I concede defeat[/url].

There's a loan amortization example here: Exploring Recursive CTEs by Example[/url]

It won't be as fast as a QU approach, but the example does handle multiple loans and if I recall...

Unless I'm misinterpreting these odd requirements, this is really simple.

It depends on the number of selections you make from the set. So with 12 columns, and if you want...

gary.strange-sqlconsumer (2/24/2015)

---

Morning all,

And thanks for the feedback.

A big concern I had with writing the article was it length. The original article was 30 pages long and I knew I had...

Sounds like a small world.

Jeff Moden (2/23/2015)

---

So, let me ask... do you have an Employee table or an Employees table? Do you have a Company table or a Companies table? Do you...

Phil Parkin (2/24/2015)

---

Nice one Dwain. Interestingly, on my machine (desktop PC running W7 64-bit and SQL Server 2014 Dev), I get different results:

Create the sample data

(1000000 row(s) affected)

Multiple Conversions

SQL Server...

Nice article Gary.

I was wondering if there would be any benefit to making your TVFs schema-bound?

I haven't tried to see if it could be done, just wondering if you've...

Lynn Pettis (2/23/2015)

---

... Mark one off, 4 days on the calendar to go. 4 days on the calendar to go, 4 days to go, ...

And for the geeks out there:

......

create table #page

(

id int,

webpage varchar(max)

)

insert into #page(id,webpage)values(1,'/user/advisory'),

(2,'/user/alerts'),(3,'user/advisory/vv2');

SELECT id,webpage

,s=CASE CHARINDEX('/', c.s) WHEN 0 THEN c.s ELSE LEFT(c.s, CHARINDEX('/', c.s)-1) END

FROM #page a

CROSS APPLY

(

...