SQLServerCentral.com / Administering / SQL Server 2005 / For development/Application DBA's- Pls suggest , I need to filter data according to customer group(CustomerID) for each login / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 31 Mar 2015 12:38:56 GMT20RE: For development/Application DBA's- Pls suggest , I need to filter data according to customer group(CustomerID) for each loginhttp://www.sqlservercentral.com/Forums/Topic539175-146-1.aspxYou have two choices: Somehow figure out how to filter in C#.net or, bite the bullet and modify the stored procs. My opinion would favor modifying the stored procs. Script them out, use copy/paste to get the new join in there, where applicable. To me, the stored procs are responsible for passing the [b]correct[/b] data to the presentation layer (.net). Simply my opinion.Why would it not be feasible to modify the stored procs? Lack of experience in SQL? Lack of personnel? Or the shear number of procs? Just curious.Edit - Watch which forum you post in (this is for SQL2005). Usually you'll receive quicker, [b]more accurate [/b]answers by posting under the right platform....Wed, 23 Jul 2008 06:53:40 GMT tosscrosbyRE: For development/Application DBA's- Pls suggest , I need to filter data according to customer group(CustomerID) for each loginhttp://www.sqlservercentral.com/Forums/Topic539175-146-1.aspxHire a DBA / database architect?Without knowing the structure of every table/query this needs done to, not much I can help you. But the general steps would be to identify where it all has to be done first, then individually look at all those stored procedures, views, functions, dynamic SQL code that needs it done. Could be a rough project depending on your code base....Wed, 23 Jul 2008 06:49:50 GMTAnders PedersenFor development/Application DBA's- Pls suggest , I need to filter data according to customer group(CustomerID) for each loginhttp://www.sqlservercentral.com/Forums/Topic539175-146-1.aspxWe are using C#.net and SQL Server 2000. The data shown in application needs to be filtered according to the customer group. Now when the application is fully functional for years , making changes in joins (to include customerId,wherever misisng) in various SP's may not be feasible. Can anyone pls suggest a workaround for the same so that for every login into application(concurrent sessions active) the users are able to see the data for their particular group only.Thanks in advance.Regards,ansz5 Wed, 23 Jul 2008 06:21:53 GMTansz5