|
|
-
Guenter Initial Review 1 Years ago through Puzzles
1. Split all data into only one columnw with recuiive CTE.
2.Parse fields to two columns,Qty and Part.
3.Calculate the two row numbers.
4.Get the record with minimal rownumber for same ID, and rownumber
5.Join the table for 4 times, get the result.
|
-
Guenter Initial Review 1 Years ago through Puzzles
The challenge idea is taken from a problem discussed in the MSDN TSQL forum.
The database field contains long string with data for Quantity and Parts.
The challenge is to parse the data into separate (Quantity and Parts) fields for displaying in a report
|
|
|
|
|
|
|
-
lyqandgdp Solved 1 Years ago through Puzzles
1. Split all data into only one columnw with recuiive CTE.
2.Parse fields to two columns,Qty and Part.
3.Calculate the two row numbers.
4.Get the record with minimal rownumber for same ID, and rownumber
5.Join the table for 4 times, get the result.
|
-
lyqandgdp Commented 1 Years ago through Puzzles
1. Split all data into only one columnw with recuiive CTE.
2.Parse fields to two columns,Qty and Part.
3.Calculate the two row numbers.
4.Get the record with minimal rownumber for same ID, and rownumber
5.Join the table for 4 times, get the result.
|
-
bertin Logic Testing Passed 1 Years ago through Puzzles
So much for my first submission.
This is a better one.
Bertin
|
|
|
-
Zibi Logic Testing Passed 1 Years ago through Puzzles
The challenge idea is taken from a problem discussed in the MSDN TSQL forum.
The database field contains long string with data for Quantity and Parts.
The challenge is to parse the data into separate (Quantity and Parts) fields for displaying in a report
|