>>>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.
Yes.
If it's not broken, fix it until it is.
My Blog