From your description it sounds like a solid design.

For your query question, you said you had around 60 meters? So you want a column for every meter? That isn't...

river1 (6/19/2012)

---

and inside the proc 1

proc 2

...

Siten0308 (6/19/2012)

---

Hello Dwain,

maybe you can help me answer my other question, which might solve the problem, i am going to make a temp table, then insert the records I want...

ramadesai108 (6/19/2012)

---

Hello All,

I ended up doing this and it worked:

AND ',' + @EmployeeId + ',' LIKE '%,' + CAST(e.ID AS varchar(10)) + ',%'

Thank you all for...

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