Server assigned id as input for SQL Statement

dunski

Is it possible to use a server assigned identity column in a SQL statement generator?

For example, I have an Account table with a primary key AccountId which is an autoassigned identity column. That same table has an AccountNumber column.

I want to use the following SQL statement generator to populate AccountNumber:
SELECT fn_GenerateAccountNumber(AccountId);

Thanks!

dunski

Nevermind... Solved this with a simple trigger