Dear halifaxdal, I cannot believe, that with visiting SQLServerCentral over 1000 times and accumulating almost 600 points you have never seen the aricle about posting questions... There is a link...

Do you want to send email only if Customer FirstName is changed?

What about Lastname?

What about other details?

If yes to any of the above two, what you email when few details...

Try to post your question as per following: http://www.sqlservercentral.com/articles/Best+Practices/61537/

and it will attract much more attention...

OTF (3/8/2012)

---

Eugene Elutin (3/7/2012)

---

It's not a good design to email from a trigger. You're killing performance of update. If I would be MS i would not allow to call xp_sendmail...

Looks like OP managed to see my withdrawn solution, I wasn't quick enough to hit a button... :hehe:

GilaMonster (3/8/2012)

---

Why is cross join not allowed?

For the comma-delimited list, look in the scripts library here for a string split function. I'd then cross apply the function to the...

Solution withdrawn as per Gail's note:

Give it a try (Books Online has some good resources on recursive CTEs), if you get stuck post your code and we'll help further. Since...

I guess, you will need to draw it yourself. Found...

In order to achieve your requirement you will need to split the comma separated values.

Please read the following and create this very useful udf as per article:

http://www.sqlservercentral.com/articles/Tally+Table/72993/

There is no viable...

It's nightmare for free...

And it's a better...

Sagar Sawant (3/8/2012)

---

Hi,

Thanks for the reply.

So I will post again and here is:

Table "tbl_Reservation" contains below rows.

CREATE TABLE #tbl_Reservation

(

...

Cannot see where exactly you're expecting a dead-lock.

May be if you follow: http://www.sqlservercentral.com/articles/Best+Practices/61537/

we may be more helpfull...

Gianluca Sartori (3/8/2012)

---

You could move those files to a non-system drive and create a junction on the system drive.

That way, the files would appear on both drives, but will physically...

: