Chooes the column you want, min or max (or average, if you wish):

DROP TABLE #Sample

CREATE TABLE #Sample (LOG_NUMBER CHAR(3), EVENT_TIME DATETIME)

INSERT INTO #Sample (LOG_NUMBER, EVENT_TIME)

SELECT '002','2011-08-07 20:29:05.787' UNION ALL

SELECT '002','2011-08-07...

As John says, Yes...

How about a little sample data, say 10 rows split across two day boundaries?

Do...

uche_ezeribe (8/9/2011)

---

...

what i get now is

UserName FirstName LastName VacID vacancy Degree

-----------------------------------------------------------

joyr Joy ...

This will show you a way to do it.

-- test table

DROP TABLE #ContainerMemberDefinitions

CREATE TABLE #ContainerMemberDefinitions (ContainerID INT, Expression VARCHAR(MAX))

INSERT INTO #ContainerMemberDefinitions (ContainerID, Expression)

SELECT 15, '#Nodes.Caption LIKE ''%adsl%''' UNION ALL

SELECT 15,...

How do you know the two rows from the first query are ORred and not ANDed?

Do you have any restrictions over how you execute the SQL i.e. can you create...

Of course. Can you post the parts of the statement you wish to create, with a little more explanation?

Same time every day Dan. Have you had your shredded wheat?

Do you mean, construct the WHERE clause programatically client-side?

mickdunde (8/8/2011)

---

Hi there

I've looking for a way how to use result from a select as a where clause to another statement. As an example I have two tables, tblNodes and...

hxkresl (8/5/2011)

---

... I am migrating data into an identity column whose values cannot be wholesale reseeded. I have to maintain the associations between existing rows of information in the...

Cities and states are different entities with different properties. Model them as parent and child tables.

This problem is only the beginning, it will get much worse if you continue...

Malaria

What?!! No, no. Classy mogs go commando.