SGT_squeequal (6/19/2012)

---

Inner join your table on its self on booking_ID next select the columns you want from table a and then concatenate a+b like so

select A.BOOKING_ID ,...

So you would need to create a trigger for insert, update and send an email when you determine it needs to be sent.

It seems you have figured out how to...

I will try this one last time. If you want some help read the article I suggested. You need to post ddl (create table statements), sample data (insert statements) and...

Thomas Abraham (6/19/2012)

---

Sean Lange (6/19/2012)

---

I wish my mind was still on the...

Excellent job posting ddl and sample data. I don't quite understand what you want to happen. Are you looking for an insert/update on a table that will send an email?

Thomas Abraham (6/19/2012)

---

Sean Lange (6/19/2012)

---

I suspect you actually use outer joins far...

duplicate post. Please direct all replies here. http://www.sqlservercentral.com/Forums/Topic1317724-147-1.aspx

Please read the first link in my signature about best practices when posting questions. There simply is not enough information here to provide any help.

Duplicate post. Please direct all replies here. http://www.sqlservercentral.com/Forums/Topic1317828-9-1.aspx

Lucasprss (6/19/2012)

---

The issue is that the sql is coming from an asp form that generates the code on the fly, so I checked the website that my software is from...

I suspect you actually use outer joins far more frequently than you...

That would also work. The entire group will then be executed in a single transaction. There are a couple of considerations if taking this approach.

1) Depending on the speed...

Seriously if you want some help post some details....

Guys the issue is very obvious from the error message posted. The OP has a long comm delimited list in a string.

declare @EmpID varchar(max) = '162638,152866,147997,166881,166882,147979,137371,111381,150385,195020,156623,181321,88895,128844,104505,124932,105633,76845,107936,138734,137327,45637,174646,141378'

Then in the where clause...

ananda.murugesan (6/18/2012)

---

by default installing SQL server 2008 or R2, Database Engine collation SQL_Latin1_General_CP1_CI_AS

Please confirm, can we changed SQL2000 collation at SQL 2008 database? if changed SQL2000 collation then SQL server...