> HI everyone,
>
> I have an SQL database that tracks workorders for my company. Each
> workorder is ID'ed by a number, i.e.: 1234. The next would be 1235,
> 1236, etc. I need a loop to go through EVERY workorder in the database.
> How do I set a variable = to the largest WorkorderID in the database?
> i.e.: That would be 1500 if there were 1500 workorders in the database.
> Don't worry, there are other checks in place so that it won't always
> loop through every single workorder (I thought about that already).
>
> Thanks in advance,
> Andrew
>
>