SQL Query For Batch Creation

See more:

SQL

Hello,

I want to create batches for below kind of records.
Wanted To Create Batches In Such a way like, It should split RowID into Batches but FamilyID Should Not Split Across Batches.

+-------+----------+
| RowID | FamilyID |
+-------+----------+
|     1 |     2296 |
|     2 |     2242 |
|     3 |     2247 |
|     4 |     2243 |
|     5 |     2310 |
|     6 |     2310 |
|     7 |     2310 |
|     8 |     2310 |
|     9 |     2311 |
|    10 |     2311 |
+-------+----------+

+--------------+-------+
|    Batch     | Range |
+--------------+-------+
| Batch1       | 1-8   |
| Batch2       | 9-10  |
+--------------+-------+

Note: Records For Same Family Should Not Split To Other Batch.

i.e Single Family Record ex: 2310 in above example should be in one batch only.
Is there any help ? how can i create query for above criteria ?

Thanks