If you are interested about the answer:

Embedding SQL Server Express into Custom Applications

(Until MSDE 2.0 it was handled with merge modules.)

😉

Do you think these comments are helpful?

Start here[/url]

@Lynn:

Congratulation for 7k points! 🙂

Notice, more than 800 points.

I'm curious about what you mean with "display", Trigger?

😉

Flo

john.arnott (5/26/2009)

---

Flo already gave a great solution with "cross apply", so I won't bother messing about with a CTE that searches out the max() and min() from a UNION of...

Pieter,

did you try the CLR function?

Greets

Flo

Hi Tim

I'm sorry but I think I cannot help any more at this point. I'm a developer, not a DBA.

The server monitoring is written by our DBAs. They use Perl...

Tim

I didn't recognize your last post. If you need the FIELD of the row with the MAX(DATEOUT) the solution is a bit different. I would use a CROSS APPLY in...

You can either use a CASE statement or a second CTE which combines the #TEMP1 with #TEMP and call the "min_max" on this.

Here the CASE approach:

; WITH

min_max (FieldId, Field, MinIn,...

We have tables which contain all names of the servers. A central process runs continuously every five minutes and checks if new mails are available. If a new mail is...

We use "Hello" messages. The server monitoring generates mails independent if there is an error or not. If there is no error the server just sends a mail with subject...

Hi Tim

First: Thanks for the really helpful sample data and the desired result! 🙂

I would use a CTE which returns your MIN/MAX dates. I'm just not sure about the logic...

Use MAX or MIN. This also works for VARCHAR.

Glad that we could help 🙂