256e303d   
   From: esquel@sommarskog.se   
      
   Ender Karada? (enkaradag@gmail.com) writes:   
   > wat about: a real table with SESSIONID (int),DEPTNO (int).  for each   
   > connection, connection will insert one row to that two columned real   
   > table,   
   > so view will be like "select w.ID,w.NAME from worker w,mysessions m   
   > where w.DEPARTMENTNO=m.DEPTNO and m.SESSIONID=GET_SESSION_ID (watever   
   > for getcurrentsessionid)   
   >   
   > or again for each connection, connection will insert one row to that   
   > two columned real table, view will be like   
   > "..m.DEPTNO=SOMEFUNCTIONTHATCALCULATESMYSESSIONDEPTNO()"   
      
   Then you need a means to clean them up. (Connections do not always die   
   in an ordered fashion.)   
      
   > or maybe i shall give up thinking about that   
      
   In honesty, I think the solutions you are looking at will give you more   
   headache that what you have now.   
      
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Books Online for SQL Server 2005 at   
   http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx   
   Books Online for SQL Server 2000 at   
   http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)