Help with a New Data Query

[squaredev1]

i'm needing a Query that grabs the lastest "newest" data from generated from the query Below and Display them in a result from another query or places the Newest data into the Historical table

SELECT FloatTable.DateAndTime, FloatTable.TagIndex AS FloatTable_TagIndex, FloatTable.Val, TagTable.TagName, TagTable.TagIndex AS TagTable_TagIndex
FROM FloatTable INNER JOIN TagTable ON FloatTable.[TagIndex] = TagTable.[TagIndex];

[June7]

Why save this data to a table? It can be calculated when needed.

[squaredev1]

Yeah i suppose i could but what is the query going to look like to just show me the newest data of those 5 Table Values shown in TagTable i am going to have this query or stored procedure run every day at 11:59:00 PM

[June7]

Several ways to go, depending on what you want.

Do you want the 'Newest' record from FloatTable for each TagIndex/TagName?

For one possible method, review http://allenbrowne.com/subquery-01.html#TopN

[squaredev1]

o.k, err this database gets populated every 23 Hr's "Fire's Once" then i am wanting the newest data from the 'Newest' record from FloatTable for each TagIndex/TagName? yes

i was thinking of Maybe letting the data Get into the Float-Table > then grab it "it's going into Excel" . then move that data into the Historical for Historical backup reasons ,"flush out the Float Tasble" then use the Historical Table When needed

If i flush the Float table after grabbing it then i havent got to worry about grabbing the latest data it will be the Only 5 Values Available to get that would be New data , i would worry about that when wanting to grab that data from the historical Table

so in that respect maybe a query to move the 5 values to the Historical table , and flush the Float-table

Does that make since to everyone ,

Several ways to go, depending on what you want.

Do you want the 'Newest' record from FloatTable for each TagIndex/TagName?

For one possible method, review http://allenbrowne.com/subquery-01.html#TopN