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

Get Running Sum of Query SQL Query

-
 select RequestNo,FileName,PaymentStatus,count(0) as TxnCount,SUM(PaidAmount) as Amount ,SUM(SUM(PaidAmount)) over(Order by RequestNo) as RunningSum from Tbl_T_CommunityPaymentOnline where  IsDeleted is null and RequestNo>=131 and PaymentStatus='Inprocess' group by RequestNo,PaymentStatus,FileName
Read more
-
Image
G H RAISONI INSTITUTE OF BUSINESS MANAGEMENT HAS ORGANISED PINNACLE 2014. THAT INVOLVES PROGRAMS LIKE POSTER PRESENTATION, IT QUIZ , C & C++ PROGRAMMING CONTEST & COMPUTER GAMING COMPITITION.DATE WILL BE ANNOUNCED SOON.
Read more