Someone else will have to speak the the specifics of "WHY", but I believe it has something to do with the parser having to evaluate both conditions of the IF.

This...

Use the LEFT command keyword.

...

SET shortColumn = LEFT(longColumn,500)

...

Johan's post should get you pretty much what you are asking for.

SQLKnowItAll (1/11/2012)

---

Jason Selburg (1/11/2012)

---

In order to dynamically name the columns, you would need to use dynamic sql. Search BOL or this site for more details on that.

Otherwise, this gets what...

In order to dynamically name the columns, you would need to use dynamic sql. Search BOL or this site for more details on that.

Otherwise, this gets what you want. ...

But more clearly stated here. 😀

So why don't you "want" to count the seperators? That would be the most direct way to count the codes.

Matthew Orton (1/10/2012)

---

Thanks for the suggestions Jason.

Yes I could create a database from one of the projects and use that as the source to compare against the remaining project using...

What's the question?

Gotcha

I may be way off here, but why not just right click the table in Object Explorer and Script as Insert then manipulate that?

This may not be the optimal solution, but .....

Apply the project to two seperate database's then use Red Gate's SQL Compare on them.

I was gonna say that, but it couldn't be that obvious. 😀

Thanks for all of the compliments everyone.

I ran into this scenario and as it seemed contradictory to common sense to me, I figured I'd see if I was the...

A few notes:

This assumes the [Fail] value is what you want pivoted.

That the value is not to be summed, averaged per [Date] [Region] group.

That their is only one value for...