Share via

Create the Dynamic SQL Query

  • Article

Create the query string.

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"

Copyright © 2005 Microsoft Corporation.
All rights reserved.