Very nice! Thank you!

Thank you. This is exactly what I needed.

We have a system that has something similar. It a database that stores Appliance Efficiency data. There is an ApplianceTypeColumns table that stores the Column Names and data type. There...

Thank you. I will give this a try and let you know the results.

Well I was hoping for a quick response but that didn't happen so I decided on a solution.

I am going to go the SSRS Subscription route. I saw a video...

The cost threshold for parallelism is set to 5 on both, Optimize for Ad-Hoc is set to false on both, memory both set to 12287, and cpus both 2. I...

This thread can be closed now. Lynn's ingenious solution worked extremely well and the performance is awesome as well.

With his solution I was able to convert a CLR procedure that...

Thanks Lowell, I only prefer Lynn's over yours due to not having the maintenance on the view when adding more entries to the main table. But both were excellent solutions....

Wow Lynn, your code seems to have worked for me. I need to do a little more checking but it looks very promising so far.

Thank you

David

I am really sorry guys that my post was not very clear or Flimsy as someone put it.

I have created a simple script that you can run to create a...

Its actually available in the SQL Server Express with Advanced Options for free

Jared,

My idea was that the ASP.NET form would have a grid that would have the property name and the propertyID and ApplianceID in hidden fields.

When the user adds a property...

Jared, you are correct that there could be different implications for adding a new appliance versus just updating. I would say adding a new appliance is a rare thing for...

I would say 99% of the time there will be no joining on any of the property value columns but there will be comparisons made to them (i.e. [value] >...

Jason, that is an outstanding design you have suggested. I think that will work very well. I think it also handles Chris' concern over limiting to 40 properties. Each appliance...