The pivot works but the output needs to be dynamic. This is why I suggested using the dynamic cross tab, and you get the bonus of a cross tab being...

PugMaster (2/18/2014)

---

Hi

Many thanks for the reply, one thing i did not demonstrate in my sample (sorry, me being stupid) is that the parent or child could appear in either column,...

nickwrenchster (2/17/2014)

---

Hi, can anyone help me; I need a function/procedure where I can pass it a table name, column name and delimiter and have the column split into as many...

Then I noticed this. "dbo.Projectforfolder(@topFolderID)". We need to have enough definition of this to know what it is doing too since the value from that is returned in the final...

Yeah we can convert to an iTVF. Can you put together ddl for the table and a few rows of sample data. With CREATE TABLE and a few INSERTS I...

jerryw 5810 (2/17/2014)

---

Luis,

I was hoping to have a seperate Stored Procedure to give me just the folder names that I would be able to use in other areas. I...

Another option might be to convert sp_FoldersOfFile into an inline table valued function.

BTW, you should not name your procs with the sp_ prefix. That is reserved for system procs. I...

Can you provide some ddl and sample data? It sounds like your origin and destination columns are derived? If your pattern of data is consistent maybe you can just a...

Something like this?

Insert TableB (col1, col2, col3, col4)

select col1, col2, col3, ROW_NUMBER() over (order by newid()) + (select MAX(col4) from tableb)

from tablea

--edit--

Looks like Russel was typing almost the exact same...

Glad...

What part are you struggling with? It looks like you changed a couple of columns in the query that I posted last week. You should have all the data as...

You have your join condition backwards on the recursive portion of your cte.

ON cteTxH.ComponentID = TC.pkTransactionID

mattech06 (2/15/2014)

---

Wrong place to post this I know but I couldn't find the appropriate forum.

How do I add an image from my pc to a post? Clicking on the image...

Yes. The article I referenced will explain not only how to build one but also how to use one....

I was hoping you would say no. It is much easier to do date math with actual dates.

I...