Writing the SQL Query
Create a standard SQL query to return the wanted information.
Step 1
SQL Query =
"SELECT top 25 UserId rcp_guid, DateCreated, DateRegistered, Email rcp_email,
FirstName, LastName, TelephoneNumber, UserTitle, UserType
FROM RegisteredUser
WHERE (DateRegistered >= '03/01/2000' AND DateRegistered <=
'03/30/2000') AND UserType = 1 AND Email is not Null
ORDER BY rcp_email ASC"