Help updating table - SQL Server Forums

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.

All Forums

General SQL Server Forums

Database Design and Application Architecture

Help updating table

Author

Topic

weirdg
Starting Member

4 Posts

Posted - 2009-09-03 : 05:25:57

Hi,
I have a problem that will probably be simple to solve but I just can't see it. I have an Access table mostly populated but one field partly populated but includes Null values. I cannot simply use an Insert Into query as the Null value has to be different on every occasion with up to 130 consecutive additions of 16 in the column. Also the Query then has to reset for the next record null. There are 137 records to be updated with varying lengths. This affects some 12,000 odd individual records to be updated. Can someone suggest how to structure this query.
I can attach a spreadsheet if it makes it easier.
Thanks in advance.

KISS(Keep It Simple Stupid) is my motto!

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-09-03 : 05:32:41

First: You want to update an access-table?
Second: It would be more clear if you could provide:
table structure
sampe data
wanted result in relation to your sample data

No, you're never too old to Yak'n'Roll if you're too young to die.

weirdg
Starting Member

4 Posts

Posted - 2009-09-03 : 06:09:31

Hi,
Table structure flat with no key fields.

Sample data below. There are 9 records to display that are connected with Null for 5 values to be inserted. The full table consists of another 136 sets of similarly structured info with varying lenths from 9 to 130.

CDC90050 A SCM70001 8 0 0 R 32
CDC90050 A SCM70001 8 8 0 R 1
CDC90050 A SCM70001 8 16 0 R 1
CDC90050 A SCM70001 8 24 0 R 9
CDC90050 A SCM70001 16 0 R 9C5
CDC90050 A SCM70001 16 0 R 9C6
CDC90050 A SCM70001 16 0 R 9C7
CDC90050 A SCM70001 16 0 R 9C8
CDC90050 A SCM70001 16 0 R 9C9

I want to replace the Null with 24 + 16 for first then keep on adding 16 to next row Null.

hope that makes it clearer.

KISS(Keep It Simple Stupid) is my motto!

weirdg
Starting Member

4 Posts

Posted - 2009-09-03 : 06:14:46

Hi,
Table structure flat with no key fields.

Sample data below. There are 9 records to display that are connected with Null for 5 values to be inserted. The full table consists of another 136 sets of similarly structured info with varying lenths from 9 to 130.

CDC90050 A SCM70001 8 0 0 R 32
CDC90050 A SCM70001 8 8 0 R 1
CDC90050 A SCM70001 8 16 0 R 1
CDC90050 A SCM70001 8 24 0 R 9
CDC90050 A SCM70001 16 Null 0 R 9C5
CDC90050 A SCM70001 16 Null 0 R 9C6
CDC90050 A SCM70001 16 Null 0 R 9C7
CDC90050 A SCM70001 16 Null 0 R 9C8
CDC90050 A SCM70001 16 Null 0 R 9C9

I want to replace the Null with 24 + 16 for first then keep on adding 16 to next row Null.

hope that makes it clearer.

KISS(Keep It Simple Stupid) is my motto!

KISS(Keep It Simple Stupid) is my motto!

ScottWhigham
Starting Member

49 Posts

Posted - 2009-09-03 : 09:48:12

I doubt it would help but FYI: you posted this in a SQL Server forum. There is only a percentage of us who use Access. You might want to either post this in the Access forum (http://www.sqlteam.com/forums/forum.asp?FORUM_ID=3) or on the MSDN Access forums.

Just trying to help :)

========================================================

I have about 1,000 video tutorials on SQL Server 2008, 2005, and 2000 over at http://www.learnitfirst.com/Database-Professionals.aspx

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources