Below is the select statement that I am using for my datasource.  I currently have entered a userid (1482) for testing purposes.  This gives me the desired results however I need for the userid to automatically reflect the logged in user's userid. 

Thanks

Select B.CallNo, B.CourseName, D.LocationName, A.StartDate, A.EndDate, A.SectionID From SNP_Sections as A Inner Join SNP_Courses as B on A.CourseID = B.courseid and not exists(Select top 1 c.LearnerID from SNP_OnlineReg as c Where A.sectionID = c.sectionID and c.learnerid = '1482') Inner Join SNP_Locations as D on a.LocationID = D.LocationID where A.openreg = 1 and A.reg_startdate <= getdate() and A.reg_enddate >= getdate() and (select count(sectionID) from SNP_OnlineReg) < a.MaxReg

Dpenny,

You may want to take a look at SQLGridSelectedView module -- a free version exists -- that will allow you to display the a grid based on a defined select statement.  The nice part is the module will allow to access any database you can reference with a Connection String. Also, there are many substitution variables so you can add a condition like

    where [DNN:Userid] > 0

to your select.  SQLGridSelectedView will substitute [DNN:Userid] with the current user's UserID.

You will find the SQLGridSelectView at www.tressleworks.ca  There is also a 60+ page userguide.

Hope this helps
Paul.