I would use a split function to split the 'Quarter' values into a table variable and then rank them on the value (without the 'Q') converted to int.  Search this...

I don't believe that it does.  Just curious though, who told you not to use bcp and why?

Please do not cross-post.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=318391

I've used Lumigent's Log Explorer (trial version) on a user database.  You should be able to get yourself a free trial. 

Are you using multiple database files/filegroups for your database?  Is your DB set to autogrow?  Can you update/insert into some tables but not others?

The only way to do this, outside of a restore, would be if you have some sort of transaction log reader tool.  There are a few tools like this out...

Just because you've decided not to go the cursor route does not necessarily mean that you need to use a table variable or temp table.  Odds are, there's a set...

I noticed that you've updated your initial post with a query using derived tables.  That is how I would have done it also.  If this is giving you the correct...

Right, I kind of got that part, but how do you know if they have not completed training?  A record in the log without a training date?

What tells you whether the training has been completed or not?

From what you've shown, there is still no reason why this needs to be dynamic.  Why can't you simply use the query SELECT @ok = 'true' FROM @MyVariableTable WHERE .....?

Again, can you give a little more info on what you are trying to accomplish?  Why do you think you need to use Dynamic SQL?

You can't pass the table variable, you must include the entire DECLARE @table table....INSERT INTO @table.... code into sp_executeSQL so that the scope of the table variable declaration is withing...

It is kind of difficult to give you a good example of this when I really do not know what you are trying to accomplish.  Can you give us more...

Then you must declare and populate your table variable within the scope of the dynamic sql call using sp_executeSQL and parameters.  Look up sp_ExecuteSQL in BOL.