How would you configure bitbucket if 2 or more developers are working on the same SSIS project? My vision is for developers working on separate packages and then committing...

Yes I am, exactly right.

This is awful!

But it can be decomposed.

1. If ContractNumber is NULL, then PaidLossAmount
2. If PaidLossAmount and CaseReserveAmount are both NULL, then NULL
3. Otherwise (PaidLossAmount + CaseReserveAmount) (with NULLs in either...

So, speaking of formatting tools, I just got a complaint because I formatted the code from the stored procedure that I worked on and that generated too many differences...

You should be able to do it all in a single statement, and therefore won't need an explicit transaction. Something like this.

INSERT EtiquetasKLC.dbo.etiquetas
(
    nome_posto
...

Sounds like you should...

If you have a large volume of data to compare and your chosen solution is very slow, please post back.

The CallEnded time 12:14:30 appears in your desired output example, but does not appear in the source data. Why is that?

From the tables above, how can you tell that it was Jim who missed the call?

What is the logic behind the Answered and CallEnded grouping window? Where does 12.14:30 come...

• This reply was modified 7 years ago by Phil Parkin.

A materialised view, in my experience, is a view which has been saved/persisted to a table. This is often for reasons of performance, but could also be because the data...

Thanks for your help. But will this query partition the resultset by City? Meaning will I be able to see all of the Cities and Companies? Or will it...

What result are you aiming for, here?

This was a bit of a logic mind-bender! Try this and see whether it's any quicker:

SELECT *
FROM #TAttrib ta
WHERE ta.ClinicID IS NULL
     ...

I use both, but honestly, I have found SSDT (well insofar as I need it to make SSIS packages) really annoying to use. So much is embedded in cryptic...

Can you...