I currently have a table with a quantity in it. 

```
ID       Code            Quantity
1        A               1
2        B               3
3        C               2
4        D               1

```

Is there anyway to write a sql statement that would get me

```
ID       Code            Quantity
1        A               1
2        B               1
2        B               1
2        B               1
3        C               1
3        C               1
4        D               1

```

I need to break out the quantity and have that many number of rows 

Thanks