SQL QUERY For : Fetch the number of Weekends in the current month

-
;WITH CTE AS
(
select DATEFROMPARTS(YEAR(GETDATE()),MONTH(GETDATE()),1) as DtName
union all
select DATEADD(DAY,1,DtName) from CTE where DATEADD(Day,1,DtName) < DATEADD(DAY,1,EOMONTH(GETDATE()))
)select *,FORMAT(DtName,'dddd') as DayName from CTE where FORMAT(DtName,'ddd') in ('sat','sun')

Comments

Post a Comment

Popular posts from this blog

Uploading Image to Sql Server Image Datatype in asp.net using fileupload Control

-
Uploading Image to Sql Server Image Datatype in asp.net using fileupload Control  Byte[] imgbyte = null;  if (FileUpload1.HasFile)             {                 string fileName = Path.GetFileName(FileUpload1.PostedFile.FileName);                 FileUpload1.PostedFile.SaveAs(Server.MapPath("~/UserPhoto/") + DateTime.Now.ToString("_MMddyyyy_HHmmss") + fileName);                 photo = "UserPhoto/" + DateTime.Now.ToString("_MMddyyyy_HHmmss") + fileName;                 string fpathPhoto = Server.MapPath(photo);                 FileInfo fInfo = new FileInfo(fpathPhoto);                 long numBytes = fInfo.Length;                 //Open FileStream to read...
Read more

☀️ New AI Perfects Heliostat Aiming to Boost Solar Tower Power

-
Image
 In a breakthrough that could reshape solar energy, researchers at Spain's Plataforma Solar de Almería (PSA) have developed an AI-powered system that significantly improves how solar mirrors (heliostats) aim at tower receivers. The AI uses reinforcement learning to adjust each mirror’s angle in real time, based on sunlight, cloud cover, temperature, and time of day — all without human intervention. 🧠 Why This Is a Big Deal Traditional heliostat setups rely on fixed aiming points. PSA’s new AI system: Learns from experience using a method called Soft Actor-Critic (SAC) Adjusts mirror positions dynamically for maximum energy efficiency Reduces mechanical wear and tear by minimizing unnecessary movements 🧪 Testing & Results Researchers ran simulations using 114 heliostats at PSA. In three rounds of experiments, the AI strategy: Increased power absorption during midday Extended operation hours in the morning and evening Improved energy output by up to 8.7% a...
Read more

📉 Study: African Women Face Higher Risk of Job Loss to AI in Outsourcing Sector

-
 A recent report reveals that women in Africa’s outsourcing industry are at greater risk than men of losing their jobs to automation and AI by 2030 . The findings were shared at the first-ever Global AI Summit for Africa , held in Kigali, Rwanda, where over 1,000 policymakers, business leaders, and experts gathered to discuss the continent’s digital future. The report, created by Caribou Digital and Genesis Analytics in collaboration with the Mastercard Foundation , highlights a key concern: 🔹 Tasks performed by women are 10% more likely to be automated compared to those performed by men. If not addressed, this could worsen gender inequality in the tech-driven workplace of the future. 📌 Call for Upskilling & Innovation The report urges African workers to enhance their digital and technical skills to adapt to the evolving job market and move into more resilient, higher-value roles. Speaking at the summit, Rwandan President Paul Kagame emphasized the need for: ...
Read more