var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Split column
Does any body know how to split a field in a table into two fields
usermaster has 40 users with user id 1 to 40
i want to get data as
Thanks you very much
You would need to count the rows (presumably it won't always be 40!), work out the half-way point, and then divide the data up.
Do you want to do that in pure SQL, or as a program?
It does seem that the only thing you want is to add 20 to the userid.. which would only be doing this in a simple ..select userid, userid+20 .. is that what you want ?
I already did this...what platform are you on?
Thank you Bret Kaiser Thank you