Hi,
Aleks Kalynovych wrote:
> I have a couple forms that generate a unique ID based on taking
> the highest
> number in the ID column adding 1 to its value. The problem is that I
> donĂ¢t save that number until the form is submitted. If 2 or more
> persons fill out
> the form at the same time they
Hi,
I don't think you can do that with MS SQL, it doesn't support TRASFORN, I
think that's strictly Access syntax. MS SQL 7 and up does have ROLLUP etc
but that's part of the OLAP service, which you will only get if you have
Enterprise edition (read $$ :)).
The easiest way to get out of this