Getting first record of the day

[HallMonitor89]

I need help getting the right SQL statement . I would like to grab the
first record of the day (records have a date entry and a time entry
associated with them.

I know it is going to be a select statement, but the right syntax eludes
me (these late nights and early mornings makes the brain a little
foggy).

Any help would be appreciated.


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Ray at]

What kind of database?

Ray at work

"HallMonitor89" <nospam@novirus.com> wrote in message
news:O241UANwDHA.2472@TK2MSFTNGP09.phx.gbl...

>
>
> I need help getting the right SQL statement . I would like to grab the
> first record of the day (records have a date entry and a time entry
> associated with them.
>
> I know it is going to be a select statement, but the right syntax eludes
> me (these late nights and early mornings makes the brain a little
> foggy).
>
> Any help would be appreciated.
>
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!

[Turkbear]

On Fri, 12 Dec 2003 12:54:08 -0500, "Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote:

>What kind of database?
>
>Ray at work
>
>"HallMonitor89" <nospam@novirus.com> wrote in message
>news:O241UANwDHA.2472@TK2MSFTNGP09.phx.gbl...

>>
>>
>> I need help getting the right SQL statement . I would like to grab the
>> first record of the day (records have a date entry and a time entry
>> associated with them.
>>
>> I know it is going to be a select statement, but the right syntax eludes
>> me (these late nights and early mornings makes the brain a little
>> foggy).
>>
>> Any help would be appreciated.
>>
>>
>> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
>> Don't just participate in USENET...get rewarded for it!

>

In general:
( Sql varies between databases, so this will work on Oracle - altho it may be different for some versions-, for
instance, but may not work in Access or SqlServer )

select * from table where date_entry = sysdate and time_entry = (select min(time_entry) from table where date_entry =
sysdate);

The idea is to get today's records and then test for the earliest time..

hth,

[HallMonitor89]

Database is Access 2k. Contains 1 table. Very Simple Database.
Columns are CustName, Date, Time, OrderID

*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Ray at]

You have separate columns for date and time? Hmm. In that case:

SELECT TOP 1 [CustName],[Date],[Time],[OrderID] FROM Table1 WHERE
[Date]=Date() ORDER BY [Time]

If you had just one column that had date and time,

SELECT TOP 1 Custname,EntryTime,OrderID FROM Table1 WHERE
DateDiff('d',EntryTime,Date()) = 0 ORDER BY EntryTime

Ray at work






"HallMonitor89" <nospam@novirus.com> wrote in message
news:uSp%23M4NwDHA.3416@tk2msftngp13.phx.gbl...

>
>
> Database is Access 2k. Contains 1 table. Very Simple Database.
> Columns are CustName, Date, Time, OrderID
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!

[HallMonitor89]

That works, thanks.

I know it would be more ideal to have the date and time in the same
column (it sure would help with other programming aspects).


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Ray at]

"HallMonitor89" <nospam@novirus.com> wrote in message
news:uppDnZOwDHA.1744@TK2MSFTNGP12.phx.gbl...

> I know it would be more ideal to have the date and time in the same
> column (it sure would help with other programming aspects).
>

There's plusses and minuses to both ways, I'd say. This is something you
should be more aware of though:
[url]http://www.aspfaq.com/show.asp?id=2080[/url]

Ray at work

[Aaron Bertrand [MVP]]

> I know it would be more ideal to have the date and time in the same

> column

And in some databases, you don't have much choice.
[url]http://www.aspfaq.com/2206[/url]

> (it sure would help with other programming aspects).

So why not add a column with the combined information?

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]

>
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!