Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Selecting record by day

 
   Database Help (Home) -> Datamining RSS
Next:  M-I,5.Pe rsecution - ha rassment at wor k  
Author Message
user

External


Since: Jan 07, 2008
Posts: 1



(Msg. 1) Posted: Mon Jan 07, 2008 10:58 pm
Post subject: Selecting record by day
Archived from groups: microsoft>public>sqlserver>datamining (more info?)

My table has a datetime column that says when each record was added. How can I
write a SELECT that gives the last record that was added each day?

 >> Stay informed about: Selecting record by day 
Back to top
Login to vote
Dejan Sarka

External


Since: Mar 18, 2004
Posts: 103



(Msg. 2) Posted: Wed Jan 09, 2008 8:01 am
Post subject: Re: Selecting record by day [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

> My table has a datetime column that says when each record was added. How
> can I write a SELECT that gives the last record that was added each day?

Without create table dll, inserts for sample data and desired result it is
hard to give you a quesry that would work for sure. I suggest you to check
if you can get some idea from here:
http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-...auxilia

--
Dejan Sarka
http://blogs.solidq.com/EN/dsarka/default.aspx

 >> Stay informed about: Selecting record by day 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Collation Problem any help - Hello all : My problem is like the following I have an online databse with a latin collation, this database is using ntext and nvarchar values that was with our previous admin ok the problem is in the data is stored should use another collation (the...

Reprocessing a mining model - I'm currently developing a user registration prototype. The aim is to classify certain types of users. However, after the registration I query a decision tree model in Analysis Services with DMX and I want to send the user data into the warehouse to....

Trying to cut down query times - I have a query that is based on two other queries that are based on tables in a database. All of the queries that are used for this final query use grouping and totals. In the application I am making, I need to choose a date range to select the subset....

Update serial number in database - Hi, I want to update specific fields in a existing table in SQL database as below example: L240100001-LG L240100002-LG *serial number is difficult to update one by one L240100003-LG L240100004-LG L240100005-LG change to L240100001-L L240100002-L..

Newbie question - I have SQL Server 2000. What add-ons do I need to try data mining, and where do I best go for resources/references?
   Database Help (Home) -> Datamining All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]