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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-10-04 : 07:40:28
|
| Mohammed writes "Dearactually i wanted to store records based on company levelif level 1 company then display all records which belong to that company plus the user logged in company recordsand while creating records select 4 modes to assign for each record for saving, that is to display the particular record on intranet,website,all intranet sites, all websites.and in company table company level is stored as primary or secondaryand another table visibilitys are stored with visibility idsfor each company and these visibilityids are selected as 4 modes while creating recordsif you understood the explanation then what i want isnow after login i have my companyid and those which are in primary position company ids but not secondary ones.and i also have those visibility ids for the now selected companyidsso now i want to search in records table for those values which match now selected companyids and whose visibility ids match now selected visibility idsin the table of records i am storing for each record its visibility ids like ,1,2,3,if you have understood the query the can u suggest me how to write a query to fetch those only records which match as said criteriayour suggesstion are highly appreciatedthanks" |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
|
|
|
|
|
SQL Query 