Views in SQL Server 8 (are instances required)

[SonOfZeus]

I'm trying to create a view that will be used with Crystal Reports, in conjunction with other tables. The table the view is based on is the HR table, with user name and location. If I create the view:

select user_name, loc where SYSTEM_USER = user_name

This returns the correct result for the current user using the view, but what happens if multiple people are accessing this view, it could change the loc for the first request if it's still running when the second comes in?

 

[mrdenny]

Calls to a view the independant of each other. Each user will get there specific data. I have done this before and it works well.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com