Glad that worked for you. More importantly, do you understand why that worked?

M Joomun (8/5/2013)

---

Hello All,

I'm using the procedure to return results to an Access 2010 .adp:

I would like to return a result if the user enters the following:

The search criteria SubjectNumber...

Duplicate post. direct replies here. http://www.sqlservercentral.com/Forums/Topic1480760-3077-1.aspx

It really isn't that complex. You could instead choose to not use...

riya_dave (8/2/2013)

---

IF YOU EXECUTING IT SECOND TIME it moves all the values to scondition

also if there is duplicate example

id pcondition scondition

1 sa ...

Did you actually notice what happens when you do that? It updates the base table. 🙂

So turn the select into an update. 😉

;with SortedData as

(

select cc.*, s.SortOrder, ROW_NUMBER()...

Thanks! That makes it so that those of us helping have enough information to work with. I took the liberty of turning your sort logic into a table too so...

heh I forgot the semicolon in my post. Alan you don't need to do this with a subselect, just a simple query works.

SELECT cEmail + ';'

FROM #people

FOR XML PATH('')

If you don't need any grouping and just simply want all emails from that table into a single column you can do that like this.

select People.cEmail

from dbo.People

for xml path('')

If...

Why do you find it so difficult to read the article about best practices? Why is it so difficult to take a few...

rocky_498 (8/2/2013)

---

Yes I got it. Sorry or confusion, Thanks Guys.

Yes you guys are right good idea to change D.Type.

Sometime not a good idea to argue with Manager about...

rocky_498 (8/2/2013)

---

Luiz thank you for your help, however that sql is just for one e.g. How I can use your sql on one column?

Year could be 2013 or 2012 or...

taigovinda (8/2/2013)

---

Good point... For the sample data that is definitely smarter. In my actual data I have about 6 fields that are like 'address' in that there could...

No need to...