Hello Jeff Good Afternoon,

Can you please assist with above query, how can i see the actual data that is new for that month.

for example May 2021 we have 10 new...

Good Afternoon Jeff,

Thank you very much for detail, it really helps me, i am working on with my data set. I think I can extend this but if there is...

Totally Understand Jeff. I will be careful and follow your valuable guidelines for sure. and i will be extra cautious.

Thank you & Grateful to you!

Thank you very much Jeff. I noticed one thing if there is none changed in the latest month it is not showing any record for the month it would be...

Sorry FUs updated. Jeff.

Please let me know. if you need any further clarification.

Data output is for information what output columns expected etc. may not need to exactly match. but around.

Thank...

there was a comma and a data type issue, i corrected Jeff. please help. Thank you

Please use below Code i executed ran without issues

CREATE TABLE #MYSRC

(

ID_1 VARCHAR(10),

ID_2 int,

ID_3 VARCHAR(10),

Pay1 varchar(6),

Pay2 varchar(6),

Status varchar(10),

FileDate DATE

)

--- SOME MORE detail INFO about data

--- WE HAVE ABOUT 2 YEARS WORTH...

• This reply was modified 3 years, 2 months ago by  asita.
• This reply was modified 3 years, 2 months ago by  asita.

Thank you for trying to help Jeff. I am sorry for this wrong table name in source. I corrected table name in my initial post code.

Also here is example of...

Thank you very much Steve. I am working on it.

Best Regards

ASiti

Hello SCott so you mean the below bold one additon?

Delete from Patient

WHERE

NOT(

(isnull(billamount,0)+isnull(discamount,0)<100

AND

(

domesticpatient = 'Y'

or

invalidaddress = 'Y'

or

invalid SSN = 'Y'

or

invalidpersonname = 'Y'

)

And servicetype = 'OP'

)

Thank you

Asiti

Just to clarify,

in other words let say for example, we have this statement DELETE from Students where CalssName = 'Algebra'

would like to remove all other than algebra so inthis case...

Any other ways or samples please that you aware of this kind of examples? please

Got it. Thank you for the update, I will try this and update you soon.

Thank you very much, this is good.

but we are looking to set up something such as writing to a table so the user can query it and change accordingly.

the reason...

Hello Linden.

Sorry can you please provide some sample what you mean by use where clause?

Thank you

ASita