Scripts

Technical Article

Get FirstDate and LastDate of Every month from two Dates

Get FirstDate and LastDate of Every month from two Dates.

Like IF we have @date1='05/02/2015' and @date2= '11/25/2015' then we will get list of first date and last date from month 5 to 11.

SELECT ID,FirstDate,LastDate,Month,Year FROM [GetFLDatelist](@date1,@date2)

2.4 (5)

You rated this post out of 5. Change rating

2015-11-09 (first published: )

1,252 reads

Blogs

How to Run Databases on Kubernetes: An 8-Step Guide

By

In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...

Episode 11 of Simple Talks: Oracle

By

The 11th episode is now live, recorded a few weeks ago at the PASS...

A New Word: Mornden

By

mornden – n. the self-container pajama universe shared by two people on a long...

Read the latest Blogs

Forums

Computer Algebra

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Computer Algebra

Renaming a Database

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Renaming a Database

A First Look at SSMS 21

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A First Look at SSMS...

Visit the forum

Question of the Day

Renaming a Database

If I want to rename the OldSales database to ArchiveSales, how can I do this? (choose 2)  

See possible answers