Thank you Sergiy and DesNorton for the help!

DesNorton code solve all my problem i just change a little bit.

Thanks again!

Thanks for the answer DesNorton & Sergiy

I already test your code DesNorton and it's working when generating all alpha numeric, but the current process or insert is one at a...

Thanks for the question Jeff.

For now we only have, 6x3,6x4,6x5 and 8x5 and 8x6.

So the MAX is F6 and F8 and the Z6 will not happen.

Thanks Matthew Darwin! i see how it is construct.

@cadavre

thanks! just using CEILING and some tweaks and it work!

right now,im working on the actual value of the quantity. 😀

@Mark-101232

Hi! This topic is old, just want to add another question.

If it's not exact multiple of split_value, how can i get the remaining split id?

For example

DECLARE @table1 TABLE(id INT,prodname...

Thanks for the quick answer Mark-101232.

I forgot to use Tally Table, which i already know! lol!

The article is very good...i just keep it in my mind that if i have...

thanks Jeff!

sorry for late reply,your code is advance that i cannot understand all of it.:D,especially the modolu(%3) you said.

Well,i already done with my problem(offcourse it's because of you),i just...

hi to all guys!wow!you have many feedback regarding my comment.

thank you very much,especially to Jeff.i haven't test your code yet.

i will give a feedback immediately.thanks again!:D

hi!well i cannot do it.i hope all of you can help me again.

About jason post,he give a site wherein there's a code

on how to split a string(http://www.sqlservercentral.com/scripts/Miscellaneous/31913/)

,its ok,but its not...

thank you very much.i ask again if i can't do it right.

any help from this forum very much appreciated.

thanks

hi,i think my question is not clear,sorry for that.

the value of remaks is:

remarks(text):123-01,EX,2600,123-02,EX,2600

i have to manipulate this characters in remarks,

so the output will be:

table_new

ID t_no type Part

1 123-01 EX...