January 31, 2011 at 8:21 am
I have a table that i need to replicate data in certain rows.
example:
ship code class target
carnival 3 4 20
navigator 2 3 20
canival 6 7 NULL
Because of the number of rows and the number of ships i need to write a code that will find a ship and taget then find the emtpy targets and full them in dynamically.
January 31, 2011 at 8:45 am
What defines an "empty target"?
You're giving WAY too little data here to be able to help you on this.
- 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
January 31, 2011 at 8:50 am
GSquared (1/31/2011)
What defines an "empty target"?You're giving WAY too little data here to be able to help you on this.
a "NULL" defines an empty target
February 1, 2011 at 6:57 am
npeters 86796 (1/31/2011)
GSquared (1/31/2011)
What defines an "empty target"?You're giving WAY too little data here to be able to help you on this.
a "NULL" defines an empty target
The way to find null values is "select * from MyTable where MyColumn is Null".
- 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 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply