i know its not the vpn because in my home network where i have the server a pc running excel is also running slow requesting data so i assume its...

lost on this one

lost on this one

err no not really very new at sql queries

the time is in seconds

yes thats what I have in my code

I was after when sql finds the min or max bidprice to bring through the dstotal on that record

Thank you guys so much, my knowledge on sql is very small right now,you have a been great help, and I dont want to push it, but i am calling this statement...

select ESDSTotal from DEMANDSPREAD WHERE TIMESTAMP=(SELECT MAX(TIMESTAMP)FROM DEMANDSPREAD) to (SELECT MAX(TIMESTAMP-00:01:00)FROM DEMANDSPREAD)

ESDStotal(int) and Timestamp(datetime) are in my table

thats what i am trying so far to get the time at least