SQL SCRIPT By Beily using ms sql create squence number with in a group,for example,given the group id the sql statement will create the squence number according to a key,