Viewing 7 posts - 1 through 7 (of 7 total)
Hello Sean
What i mean to say that user have maximum right to perform addition/deletion/substitution.Assuming I/you have all access and now request came to add/delete/substitute user in...
September 26, 2012 at 1:01 pm
Hello Sean,
Here is the DDL statment and sample data
DECLARE @sys_user TABLE
(UserId bigint
,FRST_NM varchar(100)
,LST_NM varchar(100)
,APROV_ID bigint)
Insert into @sys_user
Select 800000000, 'Dave', 'Smith', NULL
UNION Select 810000000, 'Michael', 'Chak',800000000
UNION Select 811000000, 'David',...
September 26, 2012 at 12:26 pm
Hello Sean
Thank you for response.I completely agree what you are saying.If you see the above Jason response where he created temp table and show the hierarchy.In same table I need...
September 26, 2012 at 11:59 am
Hello All, I have already provided the Cursor(sort of DDL) which are creating the tree view. Also i tried to provide the tree view result of cursor.Thank you re write...
September 26, 2012 at 8:19 am
Thank you all for response. Now my next question is how to handle new user addition / substitution if any user is on leave. My thought is replace temp user...
September 26, 2012 at 5:33 am
Thank you all for quick response.
Regards
Rohit
July 31, 2012 at 2:50 pm
Thanks for response, I am getting require result but few row in my table do not have both indicator value like
Orderid cost ...
July 31, 2012 at 10:10 am
Viewing 7 posts - 1 through 7 (of 7 total)