I am trying to insert multiple rows into table orbus_competitor_accountBase. (relationship between competitors and accounts was created.
I have the competitor id and accountid that i would like to insert. How do I generate the orbus_competitor_accountid field. See attached
*This post is locked for comments
Hi Nicole,
It is not supported to insert record directly into CRM SQL Database.
but even if you want orbus_competitor_accountid id for SQL, you can use
insert into orbus_competitor_accountBase (orbus_competitor_accountid, competitorid, accountId) values (new Guid(), competitorid, accountId)
you can New Guid() to generate orbus_competitor_accountid.
but again this GUID is not sequential GUID, so it might create some issue in performance.
Another option would be you can create one small console application and using CRM SDK you can easily insert multiple rows / create multiple relationships.
Hope this will help..
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (