Again thank you for all your replies.

One point I must note here, we have only sql server standard, and unless I'm very much mistaken it is limited to 2gb ram...

Well the configurations I mentioned just above are all based on physical disks. I'm pretty certain the server is 32bit technology. FYI this company is excessively tight with money 🙁

For...

Thanks for all your replies, I decided to call this first attempt, a failure, and reverted back to the standalone hardware, I can provide more details about how the system...

You nailed it, perfect, thanks

I sooo missed that, I built the origional query with an order by in the EM, and it automatically puts that statement in...

Awsome, worked a treat. It's a shame that...

I had a go myself, and got the results, however I wonder if anyone has a better way than this.

Marts

Nice,

Intrestingly I had just made that query too, although it still requires trigger intervention when new cols are added (although says to himself: that would probably be needed anyway to...

I do have productfamilies and universal tables which also hold version information

with views to the latest version available

so selecting from the universal view will return the list of available formfactors...

I often do this by sending my data in as a delimited list, eg with commas etc.

Then I have a UDF that is called SplitString, which returns a table from...