>>Hello all
>>
>>Not having much experience working with temp tables on the SQL server, I'm wondering if it is possible to build a temp table name similarly to how we do in VFP?
>>
>>Or, does the server recognize that a temp table name (say #TestFile) coming from User #1 is different from User #2's #TestFile?
>
>Temp tables in SQL Server that start with the # are created per session, so they will be different for each user. Temp tables starting with ## are global and visible to all sessions which are created after the session which created that table.

Just to make sure I'm reading this correctly -

If I were to create a table before a testing session (20-180 students taking an Adaptive Test) that contained all records meeting certain criteria (all in Subbank 6) and named it ##Subbank6, all users of the application would see it until it was destroyed after the testing session was finished.

And each individual Student could have a temp table #EAPCalc and #InfoCalc and the server would know which went with which.

That's just what I need.