Yeehaw, it's Rudy to the rescue!
At 05:25 PM 1/22/2004, you wrote:
> Any ideas? Thanks.
you sure that's sql server, not access?
when did sql server start using autoincrement? isn't it identity?
You're right, but I always create the tables in SQL Enterprise Manager so
I'd forgotten the syntax.
> Any ideas? Thanks.
you sure that's sql server, not access?
when did sql server start using autoincrement? isn't it identity?
as far as the syntax is concerned, i can see what you're trying to do in the
subquery, you've got "um" as a correlation variable in there, and yet you
are trying to do
Sorry about the double post -- I'd forgotten that my list settings were to
not receive my own messages and I was sitting here going, what's wrong with
the list?? :)
Anyway, I realize that the following statement works, but it's really kind
of a kludge and I was hoping for something better:
SEL