You shouldn't be told, you're the best person to advise on server allocation, file locations, growth options, security etc etc. If they are just putting databases on servers, are...

If I have read your requirement correctly:

You can have a for each loop container in SSIS and specify a folder and wildcard extension, *.xlsx for example. You can then...

As a rule, I would look at optimising with indexes and the like before contemplating partitioning tables.

Its OK, found I could use a table, just assumed that was for data only!

Fully appreciate and understand why the scripts are handy. It was just very difficult to put in the full script and as stated (if I hacked bits out possibly...

Adi Cohn

I did say that I appreciated a more concise script would be helpful but the full script is a mess really and I was only after pointers in the...

Thank you ever so much, greatly appreciated.

Many thanks, I was trying to simplify the script, appreciate a more concise example would have been a bit more helpful. Is there a way, like having the Person...

No its OK, I left the element in above the attribute line, removing that and hey presto! End tag included. Thank you ever so much, massively appreciated.

However, what...

Kind of, many thanks but I would still need an end tag for Person..

I am getting the following error as the actual query is a little more complex Attribute-centric column...

Essentially, if you use my brief example above then I need to create an Attribute inside some XML. So <Person role="Supplier"> - then some elements under person then, </Person>....

I will ask them the question, I just recalled a few CozyRoc posts on here and thought I would ask.

Brilliant, that is exactly what I need to do. Thank you very much for clearing that up, pleased I was on the right track!

Thanks for the reply, thats what I am looking at admittedly I have never ventured into XML in SQL before bar a coupel of simpel queries.

I have the...

Always looking for more, and I may well do!

Thanks again.