Posts

Showing posts from February, 2025

How to Create Function For Getting Financial Year From Date.

 For Creating Function For Getting Financial Year From Date Copy Below Query and Paste in SQL Server Management Studio and execute.after successful close SQL Server Management Studio and reopen.You will find function under Database→Programmability→Functions. CREATE FUNCTION [dbo].[FinYear] (@input Datetime) returns varchar(20) as  begin DECLARE @FinYear VARCHAR(20) select @FinYear=(CASE      WHEN (MONTH(@input)) <= 3      THEN CONVERT(VARCHAR(4), YEAR(@input) - 1) + '-' + CONVERT(VARCHAR(4), YEAR(@input) % 100)     ELSE CONVERT(VARCHAR(4), YEAR(@input)) + '-' + CONVERT(VARCHAR(4), (YEAR(@input) % 100) + 1) end) RETURN @FinYear end USE ABOVE FUNCTION IN QUERY TYPE SELECT COMMAND AS PER BELOW                                                  select dbo.FinYear('01-Apr-2020')

How to bypass the internet requirement during Windows 11 setup

  You can run the OOBE BypassNRO command to bypass the internet requirements. To bypass the internet requirement. 1. Begin the Windows 11 setup process 2. When you reach the “Let’s connect you to a network” screen with the grayed-out Next button, press Shift + F10 to launch a command prompt 3. In the command prompt, run the following command:  oobe\BypassNR O  This will execute the OOBE BypassNRO command, bypassing the network requirement during Windows 11 setup