Hello all I am a newbie to SQL admin (our dba got a better offer), and I have been stuck in the temp position of DBA/software developer. So now you know a little bit about my background here is my question:

I have a table that will have records inserted into it from several PDA's (CSV file import) the first col. of the file has the D/L request id (unique int from the db) the third col. has the PDA's index for the record. As we have several PDA's I want the take the D/L request id * 100 and add it to the PDA's index to create a unique index in the SQL database. I know this can be done using an insert trigger, what I want to know is can it be built into the db in any other way?

why don't you just set the unique key to the two fields
d/l request id and PDA index?

no trigger or other code required