i have data in the format of a date and the key for each day and for each key i have to create 10 values as part of creating test data.
how can i do it using sql server date key 2011-01-01 221 2011-01-01 23232 2011-01-01 234234 2011-01-01 2343 2011-01-01 987 2011-01-01 6602 2011-01-01 787879 2011-01-01 8605578
the output would look like
2011-01-01 221 1 0
2011-01-01 221 2 0
2011-01-01 221 3 0
... so on 10 values
2011-01-01 23232 1 0
2011-01-01 23232 2 0...
so on.
Edited by - sqlservernovice on 12/13/2012 16:48:54
Looping through to create a test data
Posted - 12/13/2012 : 16:26:34
