Yes, the date field needs to be updated as well if other record matches

It is inserting value in PAS table if the conditions matches or else updating values.

But the value for last_update_DT in stored proc is entered manually 08142016

even though when it matches...

This table was already created and I am not sure if we can change the datatype now.

It was from SQL Server Reports.

I was able to find the information from Standard reports\Configuration Change history in sql server 2012.

The value for deposit comes in form of text file with + in front of the numeric value that is the reason I had it as varchar.

Thank you for your reply.

declare @deposit varchar(10)

set @deposit =+000000007000

select (COALESCE(CAST(NULLIF(ISNUMERIC(@deposit), 1) AS money),

CASE WHEN @deposit LIKE '%.%' THEN @deposit ELSE CAST(@deposit AS money) / 100.00...

I have column with +000000007000 value and data type of column in varchar, I am trying to convert that data column to money\decimal.

Thanks.

Got it. I can just do distinct count.

Thank you.

Thank you this worked.

Other question would be how to find the count of unique values

It didn't work for me.

Also, if the numeric value starting after 0 is of length 8 only I need to split to other column.

Sorry to keep changing requirement:

ColA:

AAAA-AOP/W 00160000

ASSSS-DOU/W00160000

O/OF EEEE 00000000

So, I need to split the column on the criteria that if it starts with 0 then split it to...

How do I split Characters and numbers from sql:

I have this data :DEP-A CALLEJ00025000

Need

cola ...

It is not sometimes it can be

MDL-9054-1

Or It could be like this as well:

TX GMS-7000

Thank you appreciate the help.