Try below query, i have created a temp table with some sample data. you may need to change the order by clause based on the data you want to see.

Try this query, this should work. You can use select clause to check the data to be deleted

DELETE FROM A
--SELECT *
FROM dbo.PinheadTest a

Please give some test data and expected output.
Based on current input you are trying to update parent table (Table1) with child table (Table2). Why do you want to use...

please give some sample data and expected result
My understanding is you want to change first character with 27th, below script should be useful

Declare @txt...

I don't think it is possible at fact table level. can you just update those 2 columns with NULL values for those old financial year, if number of records not...

I would not go for trigger. There are few other option, so can have better control and guaranteed email and logging
1. as soon as application updates the record, it...

Is the remote connection connecting through a link server or app server? in that case you need to check the query timeout setting in link server/ app server connection configuration.

In small organization of course one resource may have to do all the tasks related to SQL. But in my experience I have seen mostly expectation is installing SQL Server,...