any good....

SELECT TOP (3) WITH TIES *

FROM ClientRequests

ORDER BY Requests DESC

hmm... Oracle maybe??

http://stackoverflow.com/questions/278189/oracle-string-concatenation-operator

TABLE: ANSWERS

AnswerId int Primary Key

Answers nvarchar(2000)

with a nvarchar answer...how do you...

OK...so are you able to provide the "create table" script please.?

we will then know what datatypes we are dealing with.

good luck

does this work for you

SELECT cast(MEMBER_ACCT.mbr_1st_nam as varchar(50)) +' ' + cast(MEMBER_ACCT.mbr_lst_nam as varchar(50))AS FullName

FROM MEMBER_ACCT

In SSMS....find your table...right click...script table as....create to...new query window

copy and paste results here

Please provide create script for table MEMBER_ACCT and some representative data.

should be easy to solve then

note...7 year old thread

🙂

The total would be 4 codes......

and they are...???

here's a post that may give some ideas (J Moden)

http://www.sqlservercentral.com/Forums/Topic1220939-391-1.aspx#bm1223418

does this help?

http://www.sqlservercentral.com/scripts/T-SQL/67149/

SQL Kiwi (1/8/2012)

---

Well yes, but I do...

ChrisM@home (1/8/2012)

---

No kidding. What Paul's modestly neglected to mention is the 5-fold performance lift provided by removing the table spool from...

Jeff Moden (1/7/2012)

---

Absolutely incredible, Paul. Great bit of research. I've got to find a machine I can make it fail on and then try that fix. Nicely...

as I spawned this thread...thought it only polite to report back

based on my pc (with the memory of a toaster) .......

using traceflag 652=ON.....works every time

using WITH (INDEX(0)) in the cte...works...