I have some update queries that are running in Access, but they're consuming an incredible amount of CPU. I'd love to run them directly on the SQL Server, but don't know how. Is anyone able to point me in the right direction? I don't know if I need to set something up with transact SQL, a stored procedure, a function, or something else. The queries are pretty straightforward.
Thanks in advance for your help!
Thanks in advance for your help!