If it is a table variable being passed in, then it is a User Defined Table Type. In SSMS, open Programmability then Types under the particular database

Phil,

that's brilliant even though it feels dirty 😉

those are just ways to categorize the jobs, but a proc is T-SQL

SQL Agent should be pretty straight forward.  In the schedules section you can select the interval to run it in

Sameer,

the difference between yours and Steve's is that the output statement will give you the IDs you updated.  The one you wrote could possibly return more records on the second...

Sameer,

if you post some DDL and sample data, it would be easier to show you in a query. The simple answer is yes, you can avoid a cursor by joining...

• This reply was modified 4 years, 2 months ago by  Mike01.

Your statement looks right, but if it multiplies by 0, then it will always be 0.  So why not something a little cleaner

Sum(CASE WHEN P.gm_cd in (1105, 2123, 2124, 2150, 2152,...

Yes, open solution in VSTS2017.  Then go to Project.Properties.  In project Settings, you can change target platform.  You'll probably have to open the script tasks and rebuild them, but it...

THROW 52000, 'Here''s a Bubbler', 1;

Phil, In MA we call that a Bubbla

Can you go into the EE and filter out what you don't want?

Begin try
select 1/1
begin try
select 1/0
end try
begin catch
;Throw 51000, 'inner catch', 127
end catch
end try
begin catch
;Throw 51000, 'outer catch', 127
end catch

• This reply was modified 4 years, 3 months ago by  Mike01.

I thought SQLNCLI was for SQL Server not MySQL?  Have you checked you connection strings?

https://www.connectionstrings.com/mysql/

How many clients are you talking about?  it could get unwieldy pretty quickly.  Why did the multi-tenant db not work?

you are hitting application.dbo.claims_log_v2 alot in this query.   Looks like everything is using a join on claim_number.  Can you put that hit into a cte, then join to it?  Something...

• This reply was modified 4 years, 4 months ago by  Mike01.

How often does the data get modified?  Wondering if you could materialize the view and then update when the data is updated