[help] mssql query

[sinner231_100]

mga sir/madam patulong po ulit about sa sql statement...
bale ganito po yung table ko.


View attachment 209599

gusto ko po sanang mangyari sa barcode na column eh maicombine yung category, subcategory tas magiincrement yung last six digit base sa
category and subcategory through UPDATE STATEMENT....


maraming salamat po sa tutulong....

 

[doorbreaker]

mga sir/madam patulong po ulit about sa sql statement...
bale ganito po yung table ko.


View attachment 1019779

gusto ko po sanang mangyari sa barcode na column eh maicombine yung category, subcategory tas magiincrement yung last six digit base sa
category and subcategory through UPDATE STATEMENT....


maraming salamat po sa tutulong....

create table testable(id nvarchar(3),cat nvarchar(6),subcat nvarchar(6),barcod nvarchar(18))
insert into testable
select 'c01','000100','0010',null
union all
select 'c02','000100','0010',null
union all
select 'c03','000200','0020',null

declare @table as table (ID nvarchar(3),barcod nvarchar(18))
insert into @table 
select id,  cat  + subcat + right(REPLICATE('0',6) + cast(row_number () over (partition by cat,subcat order by cat,subcat) as nvarchar(4)),6)
from testable

update testable
set barcod = (select barcod from @table where id = testable.id)

select *
from testable

drop table testable