Try this one instead.

SELECT DISTINCT

t.name AS Table_Nme,

ept.value AS Table_Desc,

c.name AS Column_Nme,

st.name + '(' + CASE WHEN c.max_length = - 1 THEN 'max'...

Here is a modified version that shows the primary and foreign key names and includes another way to correct the primary key issue the original one had.

SELECT DISTINCT

t.name...

Louis, I think this is what I am looking for. Thank you!

David

There is no aggregated data here. The results from this query would be a 5 rows with 5 columns. I just need to have 1 row with with...

Yep, that seems to be working now. Thank you!

The "Y" value is actually queried from the database and could be either "Y" or "N".

We want to do it in sql and store the average of each ping in a table along with the host name and times tamp.

Ah, that is on the first page. Sorry I missed that. Thank you!

🙂

Spot on my friend. Now, what is the best approach to this? Resources and code examples would be great. Thank you!

The final XML data will be stored in an xml file and sent and fed into another off site 3rd part application.

So is it best to extract relational data in xml format and using another language like c#, apply a style sheet to transform it into the desired format?

Okay. If I were to obtain a style sheet, is there a good source I can reference with code examples? Thank you for your expertise.

I am thinking it is XSLT, but not positive. The file is a .xsd and looks like this:

<xs:element name="Person">

<xs:complexType>

...

Sorry, the data is in relational format, spread across several tables.

True. Sorry... I am using both 2005 and 2008 but this probably should have been in 2005.

David