求一SQL语句(有难度)

[MINDNET]

现有SQL语句是:
SELECT distinct
fabric_bom.body,
fitem.fitem_code,
fabric_bom.color_code,
style_lib.color_code
FROM fabric_bom,
colour,
fitem,
so_link_fbom,
sodtl2,
style_lib
WHERE ( fabric_bom.color_code = colour.color_code ) and
( fitem.fitem_id = fabric_bom.fitem_id ) and
( fabric_bom.fabric_bom_id = so_link_fbom.fabric_bom_id) and
( sodtl2.sodtl2_id = so_link_fbom.sodtl2_id) and
( style_lib.style_lib_id = sodtl2.style_lib_id) and
(( dbo.fabric_bom.so_id = '1501000026' ) AND
(isnull(dbo.fabric_bom.sizespec_code,'') = '' OR
dbo.fabric_bom.sizespec_code = '') )
ORDER BY fabric_bom.body ASC,
style_lib.color_code ASC,
fabric_bom.color_code ASC,
fitem.fitem_code asc
结果是
item color1 color2 body
JJJ00MSCOT6020002830FJB RL1130N RL1130N BIND
JJJ08MSCOT6020002830FJB RL2628 RL2628 BIND
JJJ08MSCOT6020002830FJB RL2636 RL2636 BIND
JJJ00MSCOT6020002830FJB RL2739 RL2739 BIND
JJJ00MSCOT6020002830FJB RL2789 RL2789 BIND
JJJ08MSCOT6020002830FJB RL2806 RL2806 BIND
JJJ00MSCOT6020002830FJB RLM628 RLM628 BODY A
FFDA0COTAY3012012030STR RL1130N RL1130N BODY A
FFDA0COTAY3012012030STR RL2636 RL2636 BIND

现在想按item body分组在后面加一计算列表示组号

item color1 color2 body group
JJJ00MSCOT6020002830FJB RL1130N RL1130N BIND 0
JJJ08MSCOT6020002830FJB RL2628 RL2628 BIND 1
JJJ08MSCOT6020002830FJB RL2636 RL2636 BIND 1
JJJ00MSCOT6020002830FJB RL2739 RL2739 BIND 2
JJJ00MSCOT6020002830FJB RL2789 RL2789 BIND 2
JJJ08MSCOT6020002830FJB RL2806 RL2806 BIND 3
JJJ00MSCOT6020002830FJB RLM628 RLM628 BODY A 4
FFDA0COTAY3012012030STR RL1130N RL1130N BODY A 5
FFDA0COTAY3012012030STR RL2636 RL2636 BIND 5

[nononono]

一句话是不行了。需要用IDENTITY函数，建立一个临时表生成序号，然后联结。