Not really, it might look...

You didn't post any expected results.

However, here are two options you could use depending on what you want.

DECLARE @BookRef char(100) = 'ABCDE'

SELECT strFiPaxName_FD

,STUFF((SELECT '/' + LTRIM(RTRIM(strFiTktNo_FD))

FROM #Items x

WHERE x.strFiPaxName_FD =...

I could...

I suggest that all answers should be posted on the other thread.

Noting that you're on 2005 (as you noted in the other thread), you could use the DENSE_RANK function.

Update dbo.voters

Set rec_num = DENSE_RANK() OVER( ORDER BY part_no)

from dbo.voters

with...

You posted in 2 different forums for 2 different versions, please define which one would you like to consider. The other post is this one: http://www.sqlservercentral.com/Forums/Topic1551279-65-1.aspx

Your code seems to do...

You posted in 2 different forums for 2 different versions, please define which one would you like to consider. The other post is this one: http://www.sqlservercentral.com/Forums/Topic1551281-391-1.aspx

Your code seems to do...

Can you post your sample data and expected results in the form of DDL and INSERT statements?

It looks like you need something like this: http://www.sqlservercentral.com/articles/comma+separated+list/71700/

But if you post your data...

You can take a look at cross tabs in this article: http://www.sqlservercentral.com/articles/T-SQL/63681/

And here's an example:

SELECT ID

,MAX(CASE WHEN field = 'LastName' THEN FieldValue END) AS LastName

...

With out the spaces added to both sides of the words, the string 'the foreign institute of comics' would become 'feign institute comics', just to give an example.

Just to keep it safer, here's a modification to Sean's option.

DECLARE @str varchar(100) = 'the foreign institute of comics'

select @str = REPLACE(' ' + @str + ' ', ' '...

Actually, you don't have to create and drop the calendar table. Calendar tables are meant to make date calculations easier and should be permanent tables. With the proper indexing, they...

That's good to know (that it worked not the bad data).

Now the question is, do you understand how does it work?

This article [/url]might give you a lot of information on...

I'm sorry, but I can't help you a lot right now. I'm busy at my job and can't examine carefully your information.

There are two possible reasons for this error. You...

I would like to help you (as well as others in this site), however, due to the differences between Oracle and SQL Server, I'm not sure that I can suggest...