quote:

---

How would I get the earliest date for each Case_Number with the following query?

SELECT Case_Table.Case_Number, Note_Table.Date_Entered

FROM Case_Table

INNER JOIN Note_Table ON Case_Table.Case_Number =...

My favorite response for these "how do I" questions is always the same: Look for a system stored procedure that does it, then go take it apart. 99.9% of...

You can create a user-defined function that does the compare and returns 1 or 0 depending on found/not found.

Then use the UDF in your WHERE clause

select *

from table

where dbo.UDFComparelist(ColumnToCompare) =...

how about this

declare @one int, @two int

if @test-2=1

begin

@one=1

@two=2

end

etc.

select ...

where Col in (@one, @Two)

This is an example of where a self join can help.

select * from table1 outside

where crdate =

(select min(crdate)

from table1 inside

where datepart(yyyy, outside.crdate) = datepart(yyyy, inside.crdate)

and datepart(MM, outside.crdate) =...

This is an example of where a self join can help.

select * from table1 outside

where crdate =

(select min(crdate)

from table1 inside

where datepart(yyyy, outside.crdate) = datepart(yyyy, inside.crdate)

and datepart(MM, outside.crdate) =...

This is an example of where a self join can help.

select * from table1 outside

where crdate =

(select min(crdate)

from table1 inside

where datepart(yyyy, outside.crdate) = datepart(yyyy, inside.crdate)

and datepart(MM, outside.crdate) =...

This is an example of where a self join can help.

select * from table1 outside

where crdate =

(select min(crdate)

from table1 inside

where datepart(yyyy, outside.crdate) = datepart(yyyy, inside.crdate)

and datepart(MM, outside.crdate) =...

I can see MSDE but not .NET. The focus of this site is SQL Server, not other programming environments. MSDE is a viable platform, it not technically a...

quote:

---

How about some method of indicating that the discussion is complete, or that the questioner has the answer they wanted?

Thanks

Phill Carter

---