--Using the spliter I mentioned
declare @stringtosplit varchar(100) = 'NAZARE|DEV|T||Current~NAZARE|DEV|T||Previous'
select 
 max(case when itemnumber = 1 then Item end) as FirstValue 
,max(case when itemnumber = 2 then Item...

Show what you have done so far and what you are stuck on, what works, what doesn't work etc.

Also why the requirement to use substring and charindex, it would be...

DECLARE @CardSwipes TABLE (Initials VARCHAR(5), RFID INT, SwipeTime DATETIME, Flag TINYINT)

INSERT INTO @CardSwipes VALUES
('GA',4321,'2021-09-01 09:00',1),
('AG',1234,'2021-09-07 08:00',1),
('AG',1234,'2021-09-07 09:00',2),
('AG',1234,'2021-09-07 10:00',1),
('JS',5678,'2021-09-07 20:00',1)

;WITH CardSwipeCTE AS (
SELECT ROW_NUMBER() OVER (PARTITION BY RFID...

Try patching SSRS first, download the latest 2017 SSRS installer and run that over the top, there was something in Feb 2020 about a a release for it then so...

Speak to fellow DBA's / send a mass mail around asking, there is no way to know without going asking people in the business what they where kept around for.

That would be up to the application which is inserting the data, it is sending the wrong date to SQL to store so it needs to be tackled at the...

declare @datetable2 table (somedate datetime)
insert into @datetable2 values ('2021-03-09'),('2021-06-09')
select datename(month,somedate), somedate from @datetable2

Thats a negative I'm afraid, those dates are March and June, the way SQL formats dates in the output is always YMD, not YDM as you can see from this...

You have no data for today in the screenshot you have provided.

The script Des gave will give you data for today only, since you have none you get a empty...

Only the time?  Do you not have the date also?

What happens at the end of the day, does the table wipe itself and start again?

How do you differentiate a swipe...

Increase your screen resolution.

The server properties window cannot be shrunk past a certain size, so if its to small on screen you need to change your resolution.

This is as small...

Speak to your licensing provider, they will know all the T&C's with your agreement to Microsoft as to what you do need to pay for or not as each agreement...

Yes all replicas in the full subnet need to have their IP changed to the new subnet.

Issues would be routing, firewalls, any application reconfiguration you need to do.

Usual stuff for...

Yeah the listener configuration needs to be in the same subnet as the nodes

You need to set the backup preference and backup priority of the availability group so that the secondary is higher than primary, then Ola's scripts will see the preferred replica...