You are welcome. I am glad you got it working to suit your needs. I guess at the end of it you went with a static cross tab instead of...

Ideally you should leave the formatting to the front end instead of pulling it from sql. If you look at BOL you will find many formats for convert to format...

Mark Gorelik (8/14/2013)

---

Thank you Luis !

I tested your solution on real data and for some reason it does not work . ID incremented for field1 value='H' .The rest script...

dwayne.hofstetter (8/14/2013)

---

If manually did a sql backup (example, right clicking on the database name, Tasks, Backup) is there any way to capture this so I can either create a sql...

Excellent. My first thought would be pretty much the query you posted in your original post. However you said you want to return only 1 of them. Which one would...

I am pretty swamped at the moment. What you need here is called a dynamic cross tab. You might try checking out the...

Hi and welcome to the forums. In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form...

skb 44459 (8/14/2013)

---

I am not aware of CLR Procs at all. But I am open to any good solutions.

I want to write a Stored Procedure which will

- Open a...

Maybe instead of taking code you found in a 6 year old thread here on ssc and asking us to convert it to t-sql you can tell us what you...

OK.

Why do you want to do this in t-sql? It is the wrong tool for the job. A...

Why do you want to do this in t-sql? It is the wrong tool for the job. A CLR proc, SSIS or even an application would be a much better...

OK so now if I understand your requirements you are wanting a result set with a dynamic number of columns?

Something like pyEventID, ProviderName1, ProviderNumber1 [repeat Name and Number for however...

GTJohnson73 (8/13/2013)

---

My apologies for any confusion, again this area of SQL is new to me and I feel as if my brain is short circuiting...I actually do need a cross...

Jeff Moden (8/13/2013)

---

Sean Lange (8/13/2013)

---

I am confused. Are you typing in a query or using the Edit top 200 menu option? I would urge you to write your queries instead...

adonetok (8/13/2013)

---

richard.noordam, I just use your way but I am tired to change 200 every time.

I just want to find a way to modify SQL server setting to make job...