Sounds like standard org chart recursion.

Have a gander on the intertubes for 'Recursive CTE'. That'll handle most of your question.

If you'd like some tested code, please check out the...

GilaMonster (12/9/2010)

---

Read my last post.

I do not recommend this approach. Take a look at the method on my...

Warm Beer.

Yes, partitioning is actually your best bet here, but you have to partition on the date column in the table...

... which leads me back to a different issue. When...

Just drop it to a variable and use it from there:

CREATE TABLE #tmp ( tID INT IDENTITY( 1, 1), tValue VARCHAR(10))

Declare @LastID INT

INSERT INTO #tmp (tValue) VALUES ( 'Oscar')

SET @LastID...

Aaron Prohaska (12/9/2010)

---

OK, that did solve the problem though I'm now realizing there is more to this that I have to figure out.

Can you please explain how this query works?...

LutzM (12/9/2010)

---

The only question that remains from my side regarding those two columns: Why do you have a SurrogateKey and a BusinessKey? If you'd have PortfolioCode only (as a natural...

GilaMonster (12/9/2010)

---

It's complaining because dso has used double quotes (") instead of two single quotes (') and quoted identifiers is likely on, meaning that "01/01/2010" is interpreted as a column...

Sorry, swung in, saw that the sample data wasn't consumable (do read that link, it explains why), meant to come back and forgot. Btw, the second set of sample...

Gail as usual is more thorough than I am. 🙂

Can you do me a flavor, and the one where it says 'date' isn't a column name, just commment out the...

G'dang... that Lookup component is QUICK. It almost keeps up with the import itself. (175k rows/file, * 6 files, under 2 minutes)

Great recommendation, that's one headache out of...

dso808 (12/9/2010)

---

Thanks Craig! That's taken care of now. But when I execute the stored procedure to test like so (just trying to get ALL records from the table):

--...

dso808 (12/9/2010)

---

Hi Craig and thanks for the speedy response. The [ProbTicketDate] field is a DateTime field. An example of what's stored in the table - '1/4/2010 12:00:00 AM'....

dso808 (12/9/2010)

---

OK, I guess this is what you meant by this part:

"Note: you might have to do some conversion for the date fields if required nad >= nad <= condtion...

Stefan Krzywicki (12/9/2010)

---

What about someone who's been in the industry a long time and knows a wide variety of technologies to a decent depth if not "guru" level and a...