There are some code gotcha's in your original query. Looking at the first CTE, and expanding the range of PartID to get a decent sample set for testing, shouldn't this:

SELECT...

Phantom forum post!

Go to this thread

Click on the Quote button

Scroll down to view earlier posts (click on the [+] icon if necessary)

sqlbidev (7/7/2015)

---

Hi,

I have a populated table on my local machine, I have created the linked server and connection is working fine.

I have also created the same table on redshift...

paws

Very fast code! It wouldn't take much tweaking...

Hi Alan, nice job 🙂

Here's a completely different take on the problem, loosely based on some fuzzy matching stuff I've worked on over the years. It looks promising and you...

rs80 (12/23/2015)

---

Sorry, there isn't any source code that I have. It's more of a theoretical question. What's the best way to learn how these functions work behind the scenes?...

Brandie Tarvin (12/23/2015)

---

Thank you, everyone for the sympathy. She's getting her surgical biopsies today and we'll know in a week. The SO is kind of moping around (she's his cat)...

chris92mars (12/22/2015)

---

I tried to add a new record on the linked server but it fail.

The Errror is Column Name or number of supplied values does not match the table...

Brandie Tarvin (12/22/2015)

---

Sorry to interrupt a valuable discussion on posters, but I need some sympathy.

Cancer cat (Formerly had a sarcoma removed) now needs to go back in for some surgical...

Usually, yes

>>>>>------------------->

Something along these lines should do the trick, however I'd recommend you don't do it. If the number you are storing with the date of the visit is of any...

This should get you started:

SELECT *

FROM workorders i

CROSS APPLY (

SELECT *

FROM workorders tc

WHERE tc.JobType = 'TC'

AND tc.AccountNumber = i.AccountNumber

AND tc.ScheduledDate BETWEEN i.ScheduledDate AND DATEADD(DAY,30,i.ScheduledDate)

) x

WHERE i.JobType...

Tallboy (12/17/2015)

---

Hi Chris,

Wow, thank you so much... looks the business!

I had been reading about the Tally Tables but can't claim to understand it!

I copied and pasted you code into...

-- make up some sample data to work with

DROP TABLE #Sample;CREATE TABLE #Sample (NStartDate DATE, ApptTime TIME, Duration SMALLINT, Frequency SMALLINT, ClientID INT, NEndDate DATE)

INSERT INTO #Sample (NStartDate, ApptTime, Duration,...