Wednesday, 2 October 2013

how to increment value of a column up to specific range for values in other column?

how to increment value of a column up to specific range for values in
other column?

The existing table is like:
tmc speed
ABC 55
DEF 55
I want to create a table like the following one using the existing table
in SQL Server 2008:
tmc speed
ABC 55
ABC 56
ABC 57
ABC 58
ABC 59
ABC 60
DEF 55
DEF 56
DEF 57
DEF 58
DEF 59
DEF 60
The code I developed is not showing me the exact result I want. Any help
will be highly appreciated.

No comments:

Post a Comment