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 1 year, 11 months ago by Phil Parkin.

Ah, you mean the SAME employee number ... not just...

Your image is inconsistent. For example

RequestNo 12002 and RequestNo 12011 both have three NON NULL REAN columns, yet you have given them different roles.

Here is the solution, based on your...

Why not create an SSISDB? Takes just a few minutes. Deploy the packages there and you get a whole load of error logging 'for free', which might help you diagnose...