Answer to Question #33607 in Databases | SQL | Oracle | MS Access for Pranali

Question #33607
I have three table CMS_MenuMaster ID MenuName MenuDesc ParentID DisplayOrder 1 Product -- 0 1 2 ABC -- 1 2 3 DEF -- 1 3 4 Home -- 0 2 5 Service -- 0 3 EE_RightMaster RightID RightCode RightDesc 1 Product 1 2 Home 4 3 Service 5 EE_GroupRights GroupRightID GroupID RightID 1 3 1 Create Procedure SpGetAllMenus @GroupID int as begin select t3.ID, t3.MenuName, t3.DisplayOrder, t3.Disable, t3.MenuDesc,t3.ParentID, (select IsNull(MenuName,'') from CMS_MenuMaster where ID = t3.ParentID) as ParentMenu, from EE_GroupRights t1 inner join EE_RightMaster t2 on t1.RightID = t2.RightID inner join CMS_MenuMaster t3 on t3.ID = cast(t2.RightDesc as int) where t1.GroupID = @GroupID end for groupid 3 it giv
Expert's answer


Dear visitor
Unfortunately, the statement of your question is a bit confusing.
What do you need to be done? Please, give us the details so we could help you

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be first!

Leave a comment

Ask Your question

LATEST TUTORIALS
New on Blog
APPROVED BY CLIENTS
paypal