Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Please help write a database countdown scripts

Status
Not open for further replies.
SkyHigh

SkyHigh

Technical User
May 30, 2002
309
0
0
CA
We are just short of about 5000 orders to complete our 1st 1 million order, and I asked to create a countdown script that should query a table and notify us immediately when the 1 millionth order is placed, there are order placements as we as cancellations, the table that need to be qurried contains only valid order not cancelled ones, I just need the logic that I should use to get the details of 1 millionth order as soon as its placed.

Any suggestions, ideas would be hightly appreciated.

Thanks
Brenda
 
Status
Not open for further replies.

Similar threads

harfri
  • Locked
  • Question
Who can help me with a report in SQL
Replies
1
Views
115
feherke
feherke
dbuxton101
  • Locked
  • Question
Simple way of Exporting and Importing a Table
Replies
0
Views
115
dbuxton101
dbuxton101
wbower34
  • Locked
  • Question
sum hours fields into another table
Replies
0
Views
107
wbower34
wbower34
OJSan
  • Locked
  • Question
On Postgresql 10 i can replace or rename the default Postgresql account?
Replies
0
Views
118
OJSan
OJSan
emotionuk
  • Locked
  • Question
SQL Query/logic help
Replies
0
Views
79
emotionuk
emotionuk

Part and Inventory Search

Sponsor

Back
Top