December 9, 2010 at 9:29 am
hi all,
i have a scenario that i need to insert many rows dynamically into a table. but only two coloumns
will change in all rows,the other coloumns are common in all rows.
Example:
seq.no date name sname
1 21-dec-2010 ghg bvc
2 31-dec-2010 ghg bvc
and so..on
Can anyone suggest me --what can i use the best--
loop concept or
cursors or
xml............
December 9, 2010 at 10:04 am
Where is the changeable data coming from ? How is it determined ?
December 9, 2010 at 11:11 am
If you're inserting from a tabular source, you could cross join it to a single row of the static data.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 9, 2010 at 10:23 pm
hi,
the changeable data is calculated--one coloumnand the other coloumn is auto-generated sequence.
can u help me with this!!!!
thanks!!
December 10, 2010 at 6:22 am
Calculated from what? A text file? An Excel file? Data entry through an application or web page?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply