Select ColName From TableName Where [IdentityColName] = @@Identity
ColName is the name of the column with the GUID and IdentityColName is your IdentityCOlumn.
Cheers,
Crispin
Something as incredibly simple as
binary still gives you too many options
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!