I am surprised I've never heard about BIML previously. I wonder if a lot of folks out there use it or is this something new?

I am just starting to learn DAX. Reading my first book on the subject and this article is very timely and informative.

Here is the solution to this problem, which works correctly (credit to Steve Kass: http://stackoverflow.com/users/139164/steve-kass):

WITH cte(CarID,hier) AS (

SELECT CarID, CAST('/'+LTRIM(CarID)+'/' AS varchar(max))

FROM Car

WHERE CarName...

Thank you, but as I said, the Cars and CarParts was used by me simply to illustrate the problem. The actual database has nothing to do with either and...

Yes, that is correct. By "share parts" I mean that they share a part by the same name. That is why my "attempted" recursive query does a JOIN...

Lynn,

Thank you for your reply! The query you listed will return all of the cars and their parts, but this is not what I am after. My goal...

First of all thank you for replying! It's close, but not quite. As I said, I need to get the entire chain Car -> CarPart -> Car ->...

Great "war" story (and very educatonal)! Thank you for sharing.

Great article, thank you!

Thank you for the article! Note that if you are using SQL 2012 there is now a way to invoke SSIS package from T-SQL without having to resort to...

Great article. Thank you! Small typo in the paragraph right before "Conclusion":

The original row had four instances of the (<People> should be <Person>) element, and the...

Lynn,

Thank you very much for such super-fast response. Using the latest Jeff's function totally solved the issue! (not to mention the fact that I was three revisions behind).

You...

Thank you very much for the article! This is a great set of tips. I am currently working on just this kind of scenario -- researching a large...

Thank you for the article, this was very interesting! I think there is a small, but important typo towards the end -- after the list, which shows the order...

Thank you for the great article! .NET world has always been a bit of a mystery to me (as I suspect for many other DB folks), I would only...