Thanks for the suggestions gents, very much appreciated. 🙂

I am going to try both approaches and see if there are any performance benefits.

Certainly,

What the proc does is assemble a config for a device. Some of the config items are in a table called SiteConfig.

Sites belong to nodes in the system and have...

Hi Chris,

In the real-world system which I am building this for, the max recursion level will never exceed 10 and will on most occasions be 3 or 4.

Each level will...

Hi Dixie,

Thanks for the example you sent. I've been trying it out but it's not giving me exactly what I need.

In the example, the returned resultset is

idfruit ...

Great.

I've implemented a solution in the interim that uses a sub-query to provide the first non-null value for each column but I'm still hoping that there's a better way to...

I've now uploaded a script to create a test db with some data.

I've also uploaded an Excel sheet showing the result set currently returned by my procedure and what I...

Thanks guys.

I guess I'll have to live with the seven joins.

The only other option would be to de-normalise the data from Table B into Table A.

Chris

Chris Morris-439714 (9/28/2010)

---

If the seven foreign key fields from any row of Table A reference seven different rows in Table B, then yes you will need to join Table B...

Unfortunately, it's not quite that simple.

I also need to be able to show periods of less than 18 weeks so a start and end date are required to allow the...

Hi All,

Thank you very much for the replies.

I would very much like to use the C# solution but unfortunately I have to fix this particular issue in SSIS.

I have now...

Dave,

Nice solution. With a couple of tweaks to show the fields I need in the resultsret, that works perfectly.

Thanks very much for your assistance. 🙂

In the end, I found the task I was trying to accomplish was easier done server-side in a stored procedure.

Using this approach I was able to obtain a list of...

I've found a solution.

Instead of writing out the data to a table, I assign the values to variables and then get the trigger to send the mail without running a...

Hi There,

Thanks for you reply.

As per your suggestion I have done a bit of tinkering with Service Broker on our test server.

Although I have successfully created all the componenets Message...

Thanks for the reply.

I have tried removing the TRUNCATE statement from the second trigger and yet it still causes the same lock when it executes.

I have also tried moving the...