Add New Fields to a Recordset

I have been put in charge of modifying an existing portal, yet I cannot seem to figure out the SQL statements used to create the recordset.  It's not your standard SQL statement in which you can see what tables the information is being pulled from.  He's using one line in order to activate a SQL statement that is several lines of code.  I've never seen or used this before, but I can understand why it is more efficient on the client side.  I've have found the statement in the SQL Server database, but I still cannot find the actual SQL statement broken down.  I've tried just adding the new records where they need to be, but I keep getting the message that these fields are not included in the recordset.  I would appreciate any help.  I'm running out or time and sanity.  Read More