Hi: I need update stored procedure to add one to the maximum value of nvarchar column.
My table name is Sections.
My column names are SectionNumber, HierarchicalNumber
The data stored this way:
In my case , I already have SectionNumber 5 and also, I have the father HierarchicalNumber which is in this case = 001/005/007.
I need to have 001/005/007/004 in the Blank HierarchicalNumber of SectionNumber 5.
Here is another example:
In my case , I already have SectionNumber 70154 and also, I have the father HierarchicalNumber which is in this case = 109/905/048.
I need to have 109/905/048/763 in the Blank HierarchicalNumber of SectionNumber 70154.
Anyone can help me please!
Thanks in advance