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.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 table alignment question

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
Go to Top of Page
   

- Advertisement -