asked on INSERT INTO using just created ID
I was asked to INSERT records into a couple of tables. Here is what I am trying to do.
I need to take [SQL3].MattersQACCTNOTES.Q
Once I do this I need that newly created TEXT_ID and INSERT it into [SQL3].MattersQACCTNOTES.N
1) Am I using SUBSTRING correctly? Is there a better way to do the same thing?
2) Once I INSERT into the TBM_TEXT table how do I get that ID and INSERT it into [SQL3].MattersQACCTNOTES.N
Please note that there are two different DB's.
I need to take [SQL3].MattersQACCTNOTES.Q
Once I do this I need that newly created TEXT_ID and INSERT it into [SQL3].MattersQACCTNOTES.N
1) Am I using SUBSTRING correctly? Is there a better way to do the same thing?
2) Once I INSERT into the TBM_TEXT table how do I get that ID and INSERT it into [SQL3].MattersQACCTNOTES.N
Please note that there are two different DB's.
INSERT INTO [ADR_LIVE].[dbo].TBM_TEXT
(TEXT_ID, TXT1, TXT2, LAST_MODIFIED)
SELECT NEWID(), SUBSTRING(mqa.QBILLINGNOTES, 1, 250), SUBSTRING(mqa.QBILLINGNOTES, 251, 250), GETDATE()
FROM [ADR_LIVE].[dbo].HBM_MATTER hm
LEFT JOIN [SQL3].MattersQACCTNOTES mqa ON hm._ProLaw_FK = mqa.Matters
JOIN [ADR_LIVE].[dbo].TBM_MATTER tm ON hm.MATTER_UNO = tm.MATTER_UNO
JOIN [ADR_LIVE].[dbo].TBM_TEXT tt ON tm.NAR_TEXT_ID = tt.TEXT_ID
WHERE ((mqa.QBILLINGNOTES IS NOT NULL OR mqa.QBILLINGNOTES <> '') AND tt.txt1 IS NULL)
OR (tt.txt1 + tt.txt2) <> mqa.QBILLINGNOTES)
Microsoft SQL Server 2008SQL
Last Comment
Jacque Scott
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
This question doesn't need to be answered. I found out the fields are not the fields we use.
ASKER
This doesn't need to be answered.
BEFORE:
Table mqa:
mqa.Matters Nar_Text_ID QBillingNotes
555DDD23ILI NULL Client will make payments
22DDD555ILI NULL Bill the family
1222233IIILLI NULL The don't accept bills
Table tt does not have any data for the above
AFTER:
table tt:
tt.TEXT_ID tt.txt1
251 Client will make payments
252 Bill the family
253 The don't accept bills
Table mqa:
mqa.Matters Nar_Text_ID QBillingNotes
555DDD23ILI 251 Client will make payments
22DDD555ILI 252 Bill the family
1222233IIILLI 253 The don't accept bills