Option 2

I was making the assumption that "AND"/"OR" values were not in their own column. If I was wrong, here's another option:

WITH

x AS

(

SELECTyt1.c1,

yt1.c2,

yt1.c3,

yt1.c4,

xx =...

Sample DDL is always helpful; I put some together for your this time. I think you are looking for something like this:

-- (1) Sample DDL and Sample data

DECLARE @yourtable TABLE...

Just a quick performance note; when returning a text value from XML, you should specify the text() node for better performance.

For example, this:

[extendedinfo].value('(/ExtendedInfo/Fragmentation)[1]', 'DECIMAL(4,1)') )+'%' AS 'extendedinfo'

should be this:

[extendedinfo].value('(/ExtendedInfo/Fragmentation/text())[1]',...

No prob. Glad to help!

I believe the answer is in the article you posted. under Security Considerations it reads (emphasis mine),

...A login using SQL Server authentication cannot be authenticated outside of the Database Engine....

First you click anywhere on the new tablix. When you do that there is a grey outline, right-click on the top left-hand corner...

Next, click on the Tablix Properties option. Provided...

TheSQLGuru (1/22/2015)

---

pkapas (1/22/2015)

---

I'm a one man team for the whole company, taking care of System Administration, Database Administration, Development, Networking, Implementations, End-User support, etc. Basically everything IT. A jack of...

I am working on a project where we are using asp.net mvc. This may be an option as well. Take a look at:

http://www.codemag.com/Article/1009061

The book that Koen mentioned is my favorite t-sql book and I second his recommendation. Anything by Ben-Gan is worth it's weight in gold Imho. I have not taken the...

Take a look at make_parallel() by Adam Mechanic. I have had a lot of success with it and may be helpful in this situation.

http://sqlblog.com/blogs/adam_machanic/archive/2013/07/11/next-level-parallel-plan-porcing.aspx

Great article! I would add one more thing... Redgate go to Redgate SQL In the City:-P.

Ditto that. Me too!

taylor_benjamin (12/29/2014)

---

This is a really cool exercise. However, it should remain simply that.

SQL is not HTML

HTML is not SQL

I can't believe nobody else has raised a warning flag on...

Sorry if I am repeating what anyone else said - I have not had a chance to read through all the comments. Here's my 2 cents:

Normalize the data as it...

Great article. We'll done sir!

I do, however, disagree a little with this line (emph. mine)...

But HTML is often not well-formed XML. Some tags are "singleton" tags--that do not require end...