How to Group the partial records -t-sql

See more:

SQL

server

Hi,

I want to write t-sql query for the below scnerio.

there 40000 records are there.

How to group the partial matching in - t-sql


Consider this is my table.

description	Code	Remarks
Some Desc.	100	
Some Desc.1	100.0	Some Desc Left
Some Desc.1	100.1	Some Desc Right
Some Desc.1	100.2	Some Desc Right Some Desc
Some Desc.1	100.3	Some Desc Left Some Desc
Some Desc.2	100.00	Some Desc with Two digit Left
Some Desc.2	100.01	Some Desc with Two digit right
Some Desc.2	100.02	Some Desc with Two digit Middle
Some Desc.2	100.03	Some Desc with Two digit Upper
Some Desc.3	100.000	Left Some Desc with Three digit 
Some Desc.3	100.001	right Some Desc with Three digit 
Some Desc.3	100.002	Middle Some Desc with Three digit
Some Desc.3	100.003	Upper Some Desc with Three digit

Output should be
================

Category	Sub Category	code	Desc	               Sub Desc
Some Desc.		        100		
Some Desc.	Some Desc.1	100.0	Some Desc 	        Left
Some Desc.	Some Desc.1	100.1		                Right
Some Desc.	Some Desc.1	100.2		                Right Some Desc
Some Desc.	Some Desc.1	100.3		                Left some Desc
Some Desc.	Some Desc.2	100.00	Some Desc with Two digit Left
Some Desc.	Some Desc.2	100.01		                right
Some Desc.	Some Desc.2	100.02		                Middle
Some Desc.	Some Desc.2	100.03		                Upper
Some Desc.	Some Desc.3	100.000	Left 	                Some Desc with Three digit 
Some Desc.	Some Desc.3	100.001	right	
Some Desc.	Some Desc.3	100.002	Middle	
Some Desc.	Some Desc.3	100.003	Upper