I need to update leads with a different owner where the lead is consistent and the owner is different. Bulk - 5,000
Update table set lead_name = 'JohnDoe' where account_name in ('asdef','asdf','asdf,'asdf')
you can't use SQL in Dynamics online. Why don't you export all those leads to Excel, update the owner, and import them back?
Where can I access SQL in Dynamics online?
Do to turnover I exported all the leads and they were "sliced and diced" by sales and re-assigned. I would probably have to load a table of sort in our in house sql server and create an update and then re-import.
Sorry, I guess I was optimistic and thought you had stated why dont you utilize SQL in dynamics. Apologies.
I guess route 2 is the option
Right.. No SQL in the online version. For re-import, you might also look into SSIS + Kingswaysoft (makes things easier sometimes). Or a workflow.. anyway, no SQL.
You can do it, with the help of Skyvia Query. It is Query Builder tool that can help you to build even complex queries visually via drag-and-drop interface without typing a line of code. Whenever necessary, you can switch to SQL editor and tweak the generated SQL code if needed.
Which option do I choose for the reconcile?
Business Applications communities