This was also posted on stackoverflow. http://stackoverflow.com/questions/27232562/issue-with-select-statement-in-a-stored-procedure
Here is the real issue. We can't see your screen, we have no idea what your tables are like and we don't really know what you are trying to do.
Does every user have their own login to the database? I suspect not. That means you have no way of knowing who is logged in to the application because sql server is NOT your application. You would have to capture this in your application and pass it to this procedure as a parameter.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/