add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
id LoginId
1 Tata-Motors\Harry9
2 Orian-Analytics\Kartik10
3 adventure-works\Rajashree3
4 Team24\include324
5 Team24\nonum
6 Alpha\nonum
7 Beta\123
8 Gamma\
8 xyz
id LoginId part_1 part_2 part_3 part1_2
1 Tata-Motors\Harry9 Tata-Motors\ Harry 9 Tata-Motors\Harry
2 Orian-Analytics\Kartik10 Orian-Analytics\ Kartik 10 Orian-Analytics\Kartik
3 adventure-works\Rajashree3 adventure-works\ Rajashree 3 adventure-works\Rajashree
4 Team24\include324 Team24\ include 324 Team24\include
5 Team24\nonum Team24\ nonum Team24\nonum
6 Alpha\nonum Alpha\ nonum Alpha\nonum
7 Beta\123 Beta\ 123 Beta\
8 Gamma\ Gamma\ Gamma\
8 xyz xyz xyz
Msg 537 Level 16 State 2 Line 1
Invalid length parameter passed to the LEFT or SUBSTRING function.