t-sql column split to another column
Hello good Day to every one, i have a question in T-sql since im a newbie
i hope you can help me with my struggle. this is the input
fld_Detail
Saved dollar rate, gold volume as: 42.61, 1663.40
312000000000083: Saved as GENT'S RING, , 18K, 11.20, 0.00
312000000000083: Saved as GENT'S RING, , 18K, 11.20, 0.00
312000000000104: Saved as NECKLACE W/ CONT. PENDANT GOLD, , 14K, 8.90, 0.00
312000000000064: 350
312000000000080: 340
312000000000082: 340
How can i change or split this set of records in order to achieve this
kind of output
fld_DetailNumbers
312000000000083
312000000000104
312000000000064
312000000000080
312000000000082
in short i want to retrieve the distinct Numbers on the left of ':' based
on the first records any tips or codes? i do not know how to split a whole
row and retrieve its distinct values any kind of help would be very much
appreciated thank you.
No comments:
Post a Comment