Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
Thread: Need help to build ms sql query
06-11-2009, 06:35 AM #1
- Join Date
- Feb 2009
- Thanked 0 Times in 0 Posts
Need help to build ms sql query
I have created two tables as,
Dashboard_T is master table which will have all the dashboard with all roles which are allowed to this dashboard.
DashboardSettings_T which will have dashboard allocated to the user with his responsible offices, certifying offices & modules assigned to the user.
How i will generate dynamic query to find the count(for no. of records) & no of records for user who is logged in & belongs to the items he is assigned in Dashboard_T & DasboardSettings_T tables using parameters.