Jeff Moden (5/30/2014)

---

Heh... not to worry. I started out by testing the other solutions and then went back to the original solution. I kept looking at it and...

Jeff, you are absolutely right. I was so focused on the single row return that I lost track of the fact that the other bits were set....

ChrisM@Work (5/30/2014)

---

Do they really need to understand how it works in order to use it? I think it’s sufficient to know what it’s used for – “Pivot one or more...

ChrisM@Work (5/30/2014)

---

Hi Steve

That's why it's the second post, and not the first, which I find much easier to figure out than the OP's original code.

FOR XML PATH is now...

clarmatt73 (5/30/2014)

---

Found the issue, the Code.DateParameter part of the formula for the parameter was looking at a Report Property which had the old name in it, once I updated that...

ChrisM,

If the original poster needed an explanation of a fairly simple query, somehow, it just doesn't seem likely that they're going to consider FOR XML PATH as something easier to...

You have to use the word code, surrounded by...

Luis Cazares (5/29/2014)

---

In other words.

This:

WHERE (dbo.TCDaily.Kind <> 'A02') AND (dbo.TCDaily.Kind <> 'J02') AND (dbo.TCDaily.Kind <> 'J04') AND (dbo.TCDaily.Kind <> 'J06')

Is exactly the same as this:

WHERE NOT( (dbo.TCDaily.Kind = 'A02')...

wendy elizabeth (5/29/2014)

---

In existing t-sql 2008, there is the following sql that I am trying to understand so that I can modify it. The field that is called tMask is...

By using OR, you effectively create a series of filters for which ANY ONE comparison being TRUE results in the record passing through into the resultset. Had you...

Yes, you were... We would have had to find you and beat you if you didn't.... ;-)...

Because it's a series of ORs. Your WHERE clause basically says that the Kind...

sku370870 (5/29/2014)

---

Reply to sgmunson - thanks for your reply.

I have to admit I have never got into query plans before ... I pressed Ctrl M before running your code and...

manssourianm (5/29/2014)

---

Thanks for your interest Steve. The reason I changed date to datetime is because I'm actually using SSMS 2005 (sorry I posted in the 2008 section for increased readership).

how...

manssourianm (5/29/2014)

---

Steve,

I tried your code. I had to change it slightly, so I changed the query to:

DECLARE @sql AS varchar(max), @DATES AS varchar(max)

set @sql = ''

set @dates = ''

SELECT...