Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mathmath
Starting Member
13 Posts |
 Posted - 2009-07-06 : 10:44:30
|
| Hi, All I encounter this problem when I am trying to insert some data manually for my project.Example:LA-R1, LA-R2 , LA-R5 , LA-R8 ….. [The Rs are Already in the Original Data]Simply put, my Goal is to fill in the gaps between the Rs. So, the result will be like :P = Parent, C=ChildPL CLLA-R1 LA-2LA-RI LA-R2LA-R2 LA-3LA-R2 LA-4LA-R2 LA-5LA-R2 LA-R5LA-R5 LA-6LA-R5 LA-7LA-R5 LA-8LA-R5 LA-R8LA-R8………….[b]I hope I explain well enough this time.I know I can declare a counter to update the data. However to insert new rows of data, im not sure how I can do that. Please Help.Thanks very much. |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
mathmath
Starting Member
13 Posts |
Posted - 2009-07-07 : 03:39:54
|
quote:
Originally posted by X002548
fill in with what?Just empty rows with a key?Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam
I am sorry for the confusion , because it is very complicated to me.Example:ID NUMBERS1 22 43 74 9All I am trying to do is: Fill in the Gaps between the numbers.Result will be : ID Numbers 1 22 33 44 55 66 77 88 9If this makes sense. Thanks again. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-08 : 12:05:00
|
| do you want id value to change as per correct order of numbers also? |
|
|
|
|
|
|
Insert New Data with Counters