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...

Lucasprss (6/18/2012)

---

Sorry I did mean a left outer join, I am trying to update these fields with in a view. I really dont see what the issue is, I am...

OK that is what I thought but wanted to make sure I understood.

Lynn Pettis (6/18/2012)

---

Lowell (6/18/2012)

---

left inner join? no such animal exists in SQL, so that's probably not what you meant. it's either a left outer outer or an inner join...

Sean Lange (6/18/2012)

---

komal145 (6/18/2012)

---

select '10704' as entry_id , '2012-05-18 14:17:20.710' as Start_time ,'2012-05-18 14:18:13.957' as End_time ,'test3' as USername

Union all

select '10704' as entry_id , '2012-05-18 14:24:45.057' as Start_time ,'2012-05-18 14:25:14.780'...