petervdkerk (7/29/2015)

---

This looks awesome! 🙂

2 questions:

1. how can I narrow this query to show only the categorystring for a single product, e.g. "2481445"?

2. If I ever add more levels to...

Peter,

I did manage to find my SQL book in 5 minutes last night, but I then tried to apply it and got lost quickly. This morning, however, I...

petervdkerk (7/28/2015)

---

.

Correct.

If you just have one ultimate parent named "All Categories", you can have a normal hierarchy that can be easily navigated with traditional techniques....

petervdkerk (7/28/2015)

---

Ahhh... okay... If I had my druthers, I'd be setting up a Product table, a Categories table, and then the mapping table would just have a Product ID and...

Andy Hyslop (7/28/2015)

---

Hi Steve

Thanks for the reply

There is a cavieat I forgot to mention..my apologies

Rows are only ever inserted sequentially and never updated and archiving takes place once a...

petervdkerk (7/28/2015)

---

Thanks for your reply.

Actually there's no real overlap as far as I can see, except in the naming of the categories, but the actual categoryid as a node...

petervdkerk (7/28/2015)

---

I did not explain it correctly: the main problem is not creating a comma delimited string, the main problem is how to concatenate data from different levels in a...

gonzalezfa (7/28/2015)

---

First that nothing apologies for my English.

The application in the cell aims to facilitate transcription of the data and minimize manual office transcription errors when reading a form.

Our technical...

Cole.Mietzner (7/28/2015)

---

I have a small set of tables that the stats are becoming stale. This is happening about 3 times a day. The table is about 40 million rows and...

Andy Hyslop (7/28/2015)

---

Hi

I'm curious, has anyone ever had to script fully dynamic partition switching?

To elaborate the process all you would need is to pass in one parameter..a table name...

sqlguy-736318 (7/28/2015)

---

My question is more specific: For a given result set in a temp table, will "select top 1" and "delete top 1" operate on the same row in...

Okay... a quick Google...

YOU have permissions, but that's not the question I asked....

gonzalezfa (7/28/2015)

---

Hi Steve,

the amount of data to synchronize is small, but it should enable work offline application for lack of cell phone coverage. And then synchronize the data similar...

SQLAssAS (7/28/2015)

---

If i run the below code through SQL managament studio.. it works. If I run it through SSIS a data flow task OLEDB Source.. i get the error attached

I...