hi
thanks for response
ok will try post it better
he is the two tables i am actually working of
CREATE TABLE dbo.IRBT
(
MOODYSRATE CHAR (10) NOT NULL,
SNPRATE CHAR (10) NOT NULL,
FITCHRATE CHAR (10) NOT NULL,
IRBRATINGnumeric (4) NOT NULL,
CONSTRAINT IRBTPK
PRIMARY KEY CLUSTERED (MOODYSRATE)
)
LOCK ALLPAGES
go
IF OBJECT_ID('dbo.IRBT') IS NOT NULL
PRINT '<<< CREATED TABLE dbo.IRBT >>>'
ELSE
PRINT '<<< FAILED CREATING TABLE dbo.IRBT >>>'
go
GRANT DELETE ON dbo.IRBT TO OPXGRP
go
GRANT DELETE ON dbo.IRBT TO FIRECALL
go
GRANT INSERT ON dbo.IRBT TO OPXGRP
go
GRANT INSERT ON dbo.IRBT TO FIRECALL
go
GRANT REFERENCES ON dbo.IRBT TO OPXGRP
go
GRANT REFERENCES ON dbo.IRBT TO FIRECALL
go
GRANT SELECT ON dbo.IRBT TO DEVL
go
GRANT SELECT ON dbo.IRBT TO OPXGRP
go
GRANT SELECT ON dbo.IRBT TO FIRECALL
go
GRANT UPDATE ON dbo.IRBT TO OPXGRP
go
GRANT UPDATE ON dbo.IRBT TO FIRECALL
go
table 2
CREATE TABLE dbo.ACRT
(
CNO CHAR (50) NOT NULL,
MOODYSRATE CHAR (10) NOT NULL,
SNPRATE CHAR (10) NOT NULL,
FITCHRATE CHAR (10) NOT NULL,
MOODYSIRB numeric (4) NULL,
SPIRB numeric (4) NULL,
FITCHIRB numeric (4) NULL,
MOODYSWATCH bit DEFAULT 0 NOT NULL,
SPWATCH bit DEFAULT 0 NOT NULL,
FITCHWATCH bit DEFAULT 0 NOT NULL,
NEGWATCH bit DEFAULT 0 NOT NULL,
)
LOCK ALLPAGES
go
IF OBJECT_ID('dbo.ACRT') IS NOT NULL
PRINT '<<< CREATED TABLE dbo.ACRT >>>'
ELSE
PRINT '<<< FAILED CREATING TABLE dbo.ACRT >>>'
go
GRANT DELETE ON dbo.ACRT TO OPXGRP
go
GRANT DELETE ON dbo.ACRT TO FIRECALL
go
GRANT INSERT ON dbo.ACRT TO OPXGRP
go
GRANT INSERT ON dbo.ACRT TO FIRECALL
go
GRANT REFERENCES ON dbo.ACRT TO OPXGRP
go
GRANT REFERENCES ON dbo.ACRT TO FIRECALL
go
GRANT SELECT ON dbo.ACRT TO DEVL
go
GRANT SELECT ON dbo.ACRT TO OPXGRP
go
GRANT SELECT ON dbo.ACRT TO FIRECALL
go
GRANT UPDATE ON dbo.ACRT TO OPXGRP
go
GRANT UPDATE ON dbo.ACRT TO FIRECALL
Go
insert for table 1
INSERT INTO IRBT VALUES ("AAA","AAA","AAA","2")
INSERT INTO IRBT VALUES ("AA1","AA+","AA+","3")
INSERT INTO IRBT VALUES ("AA2","AA","AA","4")
INSERT INTO IRBT VALUES ("AA3","AA-","AA-","5")
INSERT INTO IRBT VALUES ("A1","A+","A+","6")
INSERT INTO IRBT VALUES ("A2","A","A","7")
INSERT INTO IRBT VALUES ("A3","A-","A-","8")
INSERT INTO IRBT VALUES ("BAA1","BBB+","BBB+","9")
INSERT INTO IRBT VALUES ("BAA2","BBB","BBB","10")
INSERT INTO IRBT VALUES ("BAA3","BBB-","BBB-","11")
INSERT INTO IRBT VALUES ("BA1","BB+","BB+","12")
INSERT INTO IRBT VALUES ("BA2","BB","BB","16")
INSERT INTO IRBT VALUES ("BA3","BB-","BB-","20")
INSERT INTO IRBT VALUES ("B1","B+","B+","22")
INSERT INTO IRBT VALUES ("B2","B","B","23")
INSERT INTO IRBT VALUES ("B3","B-","B-","24")
INSERT INTO IRBT VALUES ("CAA1","CCC+","CCC+","24")
INSERT INTO IRBT VALUES ("CAA2","CCC","CCC","24")
INSERT INTO IRBT VALUES ("CAA3","CCC-","CCC-","24")
INSERT INTO IRBT VALUES ("CA","CC","CC","24")
INSERT INTO IRBT VALUES ("C","C","C","24")
INSERT INTO IRBT VALUES ("D","D","D","25")
insert for table 2
INSERT INTO ACRT VALUES ("ALLIANCE & LEICESTER BS","11292" ,"A2-", "NR" ,"NR", "0.00","0.00","0.00","1","0","0","MOODYS","A2-","2.00","1")
INSERT INTO ACRT VALUES ("PRS 2005 2X A2A MBS (XS0234203684)","120577","AA2","A+" ,"AAA","4.00","6.00","2.00","0","0","0","MOODYS","AA2" ,"16.00","1")
so what im trying to do is if in the acrt table or table 2 if the NEGWATCH =1 then for MIDIRB in the acrt table or table 2 i want to add the next value from irbt or table 1.
so
say negwatch =1 and midird before this update is 16 then when update is done and from the irtb table or table 1 the midirb = 20 as the next number in the irbt table after 16 is 20
hope this is better explained but not so sure