We are using a custom contacts database created using Data Viwer. We need to insert personalized dynamic data but I'm not sure how to do this using our custom database. I've created dynamic inserts but I'm not sure how I can specify the contact in the SQL query. 

Select ArrivalDate from dbo.crmExecuTech where ?

I am stumped at ?. What can I compare that will return the current contact's information. The recipients SQL query executes fine so is there a way to compare against information returned in that query?

Here is a sample of a SQL Statement using these tokens:
SELECT dbo.Roles.RoleName, dbo.UserRoles.ExpiryDate, dbo.UserRoles.UserID
FROM dbo.UserRoles INNER JOIN
dbo.Roles ON dbo.UserRoles.RoleID = dbo.Roles.RoleID
WHERE (dbo.UserRoles.UserID = [USR-USERID])

The token [USR-USERID] is used in the sample SQL Statement above. This statement returns the recipients current DotNetNuke Roles they belong to and displays the expiration date.

Valid Personalized Tokens are:
• [USR-LASTNAME] - This token will be replaced with the users last name.
• [USR-FIRSTNAME] - This token will be replaced with the users first name.
• [USR-FULLNAME] - This token will be replaced with the users full name.
• [USR-EMAIL] - This token will be replaced with the users email address.
• [USR-AFFILIATEID] - This token will be replaced with the users Affiliate ID.
• [USR-USERID] - This token will be replaced with the users User ID in DNN.
• [USR-USERNAME] - This token will be replaced with the users user name.

In your "Inserts" you can use [USR-EMAIL] token in your SQL to get information based on that recipient.  That token will give you the email address of the current recipient going out, if the user is registered then the other User tokens will also be popuplated but the email token will always be populated.