update problem - 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

SQL Server 2000 Forums

Transact-SQL (2000)

update problem

Author

Topic

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2006-11-02 : 07:07:25

i have the table G4_Ar_Cust_Ageing_Fifo_Final_Tab_dcb

Structure :
-----------

Ageing_As_On_Date
company_no
invoice_locn
order_locn
cust_No
cust_name
Bucket_no_1
Bucket_no_2
Bucket_no_3
Bucket_no_4
Bucket_no_5
Bucket_no_6
Bucket_no_7
Bucket_no_Oth
Total_Balance
sp_id
Due_Days

i want to update the bucket no's (Bucket_no_1-7) based on the due_days .
The due days range is bellow

Bucket_no_1 0 30
Bucket_no_2 31 60
Bucket_no_3 61 90
Bucket_no_4 91 180
Bucket_no_5 181 270
Bucket_no_6 271 365
Bucket_no_7 366 2000

how can i update the same..?
Can any one please help me

Krishna

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-11-02 : 07:20:44

Where do you want to store the two integer limits?

Peter Larsson
Helsingborg, Sweden

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2006-11-02 : 07:27:25

quote:
Originally posted by Peso

Where do you want to store the two integer limits?

Peter Larsson
Helsingborg, Sweden

Sorry Peter I Didn't Get U

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-11-02 : 08:06:03

For Bucket_no_1, you want to store two integer, 0 and 30. In which columns do you want to store these values?
Also, the table has Bucket_no_1 to Bucket_no_7 as columns. What is the purpose of those?

Peter Larsson
Helsingborg, Sweden

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources