PackSize field format is varchar (50)
here are my other sample data :
1 ) ;;5000;ml;;
2 ) 65;gm;;;;
3 ) ;;;;120;Capsule
4 ) ;;;;24;Tablet
each semicolons will separate the data into 6 different column. if there is no value between semicolon like this (;;20)....then the data stored into the 1st field and 2nd field will be null but in 3rd field will be 20
blanderk
Last Activity: Nov 27 '08, 09:46 AM
Joined: Nov 27 '08
Location:
-
and actually in my table contain 40K rows of dataLeave a comment:
-
for VolUnit there are 3 types (mg,kg,g)
for VolDnm there are 2 types (cubic inch,ml)
and for packagingUnit there are 3 types (tablets,capsul e,units)
i'm a beginner for sql server. Hope all of you could help me on these.Leave a comment:
-
grab data from 1 column into different column
Dear all,
i need some help here. currently i have 1 table with multiple field.
1 of the field name PackSize contain data like ;;5000;ml;; or ;;;;60;Tablet etc.
So, i want to ask expert out there,how to grab the value inside PackSize into my other field such as field Vol,Volunit,Vol Dnm,VolDnmUnit, Package,Package Unit.
here some example :
Let say ;;5000;ml;;
then...
No activity results to display
Leave a comment: