Sean Lange (3/14/2011)

---

Just my 2¢, but I would remove it and fix the VB code that is referencing it. If you still have code that is using it you run...

Sean Lange (3/14/2011)

---

Nice job posting your ddl and data in a consumable format. KUDOS!!!!!!!!!

insert ProductCategory

select ID, CategoryID from product

Is that what you are looking for? Also i assume you...

Funny thing happened to me today...

This afternoon I installed a couple of updates on our SQL Server and after it rebooted... lo and behold.... IntelliSense is working. I guess...

ya... that's all the stuff I found on Google. No go. I'll sort it out later. No big deal. Thanks again.

Wow again! I'll defnitely be using that. Thanks for breaking it down so I can see exactly what that statement is doing. I'm a 1 man band...

I have to admit that I don't quite get his explaination, but I also haven't got a chance to play with that code yet. I'll be using the example...

Thanks. I went to Books Online and read the specs, and then I came back to this site and looked for some articles on where and when they can...

BTW, I've never used STUFF either. I'm reading up.

Now I just have to try to translate this to my real data which has many more relationships. I don't...

I'm a dope...

YES! That works. I'm reading BOL about Common Table Expressions. I've never used them before. What is the general purpose of a CTE? ...

Wow... fast response. Thank you.

I've been working with sql for a while, but I don't understand that query. I posted it in a query window and get an...

Yes, there is a relationship (it is in the example, sorry I didn't mention it).