I've taken a bit of the mystery out of the plan costs by converting the tally table used in my first solution to this one.

;WITH Nbrs_2 (n) AS (SELECT 1...

I know and have seen cases where the plan cost...

Mea culpa! I missed your comment about the 0 based tally table. Works fine when I fix that although my comment about the query plan cost holds.

Not sure what I did wrong but I ran this (same test data table @abc):

;WITH Nbrs_2 (n) AS (SELECT 1 UNION SELECT 0)

,Nbrs_1 (n) AS (SELECT 1 FROM Nbrs_2 n1...

Jeff Moden (4/30/2012)

---

Perhaps a more direct approach... pick your favorite zero-based "Tally Table" method.

WITH

cteCount AS

(

SELECT...

I'm beginning to remember why I tried to slip that one past you.

Surely you can't be suggesting something like this (using my simulated Calendar table). While it works, I'm...

Thought I could slip one past old Eagle Eye! Guess I was wrong.

Mark,

It is always nice to see someone with obvious experience weigh in on a thread like this. Your initial algorithm looks pretty complex and I'll need to study it...

facturan.antonio (4/30/2012)

---

Hello guys.

I try to somehow copy what dwain.c did in his query. I was just wondering if there's a possibility that the orig lat and long would be...

Jeff Moden (4/30/2012)

---

dwain.c (4/30/2012)

---

Writing articles ain't that difficult. Look at me. Just over 400 points and I have one published and another accepted/awaiting publication.

The trick is to find...

vinu512 (4/30/2012)

---

dwain.c (4/30/2012)

---

vinu512 (4/30/2012)

---

From what I understand, the first two requirements are not Trigger requirements at all. You can do the following for your requirements:

1. If there is no...

ChrisM@Work (4/30/2012)

---

dwain.c (4/29/2012)

---

...Actually I like writing them because I figure the more I do the better I'll understand them. I did say it wouldn't perform as well (I tested)...

vinu512 (4/30/2012)

---

From what I understand, the first two requirements are not Trigger requirements at all. You can do the following for your requirements:

1. If there is no @ symbol...

Anytime you start asking questions about performance, it helps to have some test data.

So I created a table of Airports from the attachment. It's not a very good table...

For the above, assuming no INSERT should occur if they're not...