The code I provided creates a csv list. You'll have to modify it to concatenate your notes into a single field. Perhaps using a blank (space) instead of...

Hopefully this helps you move in the right direction.

WITH CTE AS

(

SELECT DISTINCT

NoteId,

object_id

FROM...

Brandie Tarvin (6/15/2012)

---

Craig, I read the "Devil" comment to refer to the evil commenters who make people post things like "please don't flame" and "put me over the whipping stool"....

The only way I can think of is if you had auditing setup. After the fact, I don't think you are going to have much luck.

Going out on a limb here, but I'm pretty sure you can't use a MERGE statement in a derived table.

What exactly are you trying to accomplish here?

If I may, I am wondering why you are even using sp_executesql to run your select statement. From what I am seeing, it isn't necessary.

If you are looking for an answer, look here.

dwain.c (6/15/2012)

---

Lynn Pettis (6/15/2012)

Not running your code, but what do you return if the mobility indicator is not 1? The OP indicated that it should be blank.

Plus, I find...

First of all, what you posted as a query isn't, it is just a part of the query. We really need to see the whole query to be able...

vinu512 (6/15/2012)

---

Are the two tables related??....If yes then which are the fields which relate Table1 to Table2. You need to provide some more info like this for us to understand...

dwain.c (6/15/2012)

---

Jeez Kingston, you've let the cat out of the bag!!

Actually you don't need to do a JOIN of any sort.

create table #studentSchoolHistory (studentID varchar(12),scode int, iSchoolYearcode int)

insert into #studentSchoolHistory...

Okay, here is my solution:

create table dbo.student (

studentID varchar(12),

Firstname varchar(12),

LastName varchar(12)

);

insert into dbo.student values ('003412581','steve','marnet');

insert into dbo.student values...

Kingston Dhasian (6/15/2012)

---

Lynn Pettis (6/15/2012)

---

Kingston Dhasian (6/15/2012)

---

surma.sql (6/14/2012)

---

Thanks for reply. but please help me.

i need...

Kingston Dhasian (6/15/2012)

---

surma.sql (6/14/2012)

---

Thanks for reply. but please help me.

i need help, thats why i...

dwain.c (6/15/2012)

---

I was going to say the same thing but I think Sony was assuming there might be duplicated...