That looks like an Azure security error to me, not related to Schema Compare.

Some practical examples of where Python beats standard SQL Server functions would be interesting. Or is this aimed simply at people who prefer writing their code in Python?

Is your question: "How do I create a report in Power BI which looks like my existing Excel solution?"

If so, it looks like a Paginated Report would be the...

Try this:

(DT_DATE)(DT_DBDATE)DATEADD("m", -25, DATEADD("d", -DAY(GETDATE()) + 1, GETDATE()))

What do you mean by 'track', exactly? Insert details of change to an audit table? Use SQL Server's 'Change Tracking'? Send an e-mail alert? Something else?

I suggest you create a query which includes a TRY_CAST to INT of the column of interest.

Use your existing WHERE clause, but add another condition

AND TRY_CAST(Col as INT) IS NULL

This...

Usually, I'd agree with you on explicit vs implicit conversions. But here is a...

The value is actually...

The query I provided returns the result you requested. Why do you think that it is not correct?

You have a VARCHAR column containing string data. Some of the data can be converted to an INT and some cannot. What do you want to see in the cases...

Try this, noting that

a) Varchars should always be declared with an explicit length

b) When inserting literal varchars, surround them with single quotes

DROP TABLE IF EXISTS #test;

CREATE TABLE...

Based on this logic

If the memberid is active can be determined by not having any 'Cancelled' transtype

This is the code I would use

SELECT DISTINCT tm.grouingnum
FROM #testMember tm
WHERE...

Is there any chance that you can provide some sample data (in the usual CREATE TABLE / INSERT form) and simply tell us what you would like to see as...

I had...

I suggest that you do a check on the current datatype of the column and execute the ALTER only where the datatype is not an INT. Here is some sample...

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