>
> Can scope_identity() be used to get identities in a query
> such as the piece I have below? I tried using Select
> Scope_Identity() AS emailID but my query kept complaining
> that emailID didn't exist.
You're within a SET NOCOUNT ON, so it won't be output to the query
Make sure you do the SELECT @field AS NewID outside of the NOCOUNT block
and all should be well
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
