patrickmcginnis59 (6/19/2012)

---

pwallis (6/19/2012)

---

Don't worry if you don't understand Sean,patrickmcginnis59 highlighted the issue yesterday and

Stewart "Arturius" Campbell (6/19/2012) hinted that it may be posssible to get the information using a...

OK so the hard part is done then. 😀 Now you just need to send the email. This is actually fairly easy. You can send email directly from sql server....

Thanks for the ddl and sample data. What is the desired output from your sample data?

pwalter83 (6/19/2012)

---

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

Ok so taking your entire ddl and sample data see if this helps.

declare @temp table

(

[id] [int] IDENTITY(1,1) NOT NULL,

[Dag] [datetime],

[Locatie] [NVARCHAR] (MAX),

[Temperatuur] [int]

)

insert @temp ([Dag], [Locatie], [Temperatuur])

VALUES('20111112','Rotterdam','12');

insert @temp ([Dag], [Locatie],...

SGT_squeequal (6/19/2012)

---

@sean-2 Lange

It all depends on the task in hand, so in answer to this thread i gave some example SQL to help with his question, up to the user...

pwallis (6/19/2012)

---

Don't worry if you don't understand Sean,patrickmcginnis59 highlighted the issue yesterday and

Stewart "Arturius" Campbell (6/19/2012) hinted that it may be posssible to get the information using a join...hopefully...

marginalster (6/19/2012)

---

Well I'm confused about insert and update. The data (Temp.) is already inside and its not going to be updated.

So I guess the only thing i would need...

ramadesai108 (6/19/2012)

---

I am passing a string of comma delimited Ints to the stored procedure. Now I need to see whether e.Id is IN those INTs.

From the response I got from...

You basically just stated that you always prefer to get dirty reads at the cost of data integrity. I would HIGHLY recommend that you not...

ananda.murugesan (6/19/2012)

---

Sean Lange (6/19/2012)

---

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

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