Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
tfgconsultant
Starting Member
7 Posts |
Posted - 2012-11-15 : 20:00:29
|
Hi everyone,I'm still a newbie to SQL and SQL scripting. I need help and I will do my best to explain my situation. We have a table called "Curriculum" in our DB. We have users that we granted permission to have access to see the curriculum from the UI. One of the users went in there and when attempted to view the curriculum, she got this returned message "Teacher Not Found" and "No Curriculum." I checked and verified that the teacher existed in the DB and have access to view curriculum. I think the problem is curriculum alignment mismatched. I don't know the structure well to explain further. I'd like to see if someone could assist in helping me writing a very simple script to check curriculum alignment for a particular user ID.Thanks in advance |
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-11-16 : 06:50:05
|
Hard to suggest what might be wrong without seeing more information about the tables, sample data and how you are querying it. Take a look at this blog, and that might help you articulate the question with sufficient detail: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
|
|
|
|
|