You can do this using the PIVOT operator. See this BOL link for details.

-- see how this starts off with a table and data in it?

-- if you had provided...

This link provides some information that might help you out.

Jack Corbett (3/24/2010)

---

I had problems with FF 3.5 so got off of it into Chrome. I don't even have FF installed now. I do use IE especially for...

It depends. Are there any non-clustered indexes on that table?

Jack Corbett (3/24/2010)

---

I would think that might work for development, but administration of different platforms is very different, at least in my understanding. I have only been a DBA...

ronaldkrex (3/24/2010)

---

I have been running the query below. For some reason I can type a value for name that I know is in the Name Field and I don't get...

Using a function on the field being searched is going to negate any...

How does this work?

exec ('declare @cnt int;select @cnt=count(*) from ' + @nome + 'sys.objects where name = ''sp_actualizaaut'';if @cnt > 0 select ''ola'' else select ''no ola''')

I think this will do it for you.

-- see how the test data can be put into a table? It sure helps others to not have to do this!

declare @test-2...

Based on the single row of test data you supplied, and assuming that all other rows are in the same exact format, this will work:

declare @test-2 table (MixedData varchar(50))

insert into...

This looks interesting, and I'd like to help you out, but there just isn't enough information to begin. So, to start off, please read the first link in my signature...

nwoolls (3/24/2010)

---

Thanks for the response Paul. I had actually broken the statement into two, as you suggested, as a work around for now.

A little background on that syntax: we used...

I knew I had seen this, but I thought it was on this site. Thanks for the links.

Paul White NZ (3/24/2010)

---

No, because you never know when someone else might find the question or discussion interesting and make another...

Very nice. I didn't know about this.

It seems that you can only have one web tab open though... it would be REALLY nice if you could open up multiple tabs.

Then...