From stackoverflow.com:

SELECT SCOPE_IDENTITY();
[download]

From ASP docs:

SELECT CAST(scope_identity() AS int)
[download]

Update:

am using the SELECT statement with the filename and temp_date

I would suggest you use something more unique, like big random int or long string composed of random chars. temp_date might not be precise enough in a higher traffic environment.