Hari Sharma

Function to calculate Month End Date

This function will return you the month-end date. Input parameter may be any date of that month for which you want to calculate month-end.Example:Input: '2-20-2004'      Output: '2-29-2004'Input: '2-15-2004'      Output: '2-29-2004'Input: '3-20-2004'      Output: '3-31-2004'Input: '3-30-2004'      Output: '3-31-2004'

3.2 (5)

2007-05-08 (first published: )

1,305 reads

Blogs

Using Erik Darling’s sp_pressure_detector to resolve CPU issues

By

Last Friday I spent my lunch break going through some links I had marked...

How to Resolve Remove-AzKeyVaultKey : Operation returned an invalid status code ‘Forbidden’ Error

By

I’ve come across another error message in my seemingly never-ending battle with Azure Key...

Continuous integration and delivery (CI/CD) in Azure Data Factory using DevOps and GitHub - Part 2

By

(2020-Jan-28) This blog post is a followup to my previous post about DevOps (CI/CD) for...

Read the latest Blogs

Forums

Insert New Rows in sql based on difference between 2 dates

By PSB

Hi,   I want to create a new records based on the difference between...

COHESITY for Backup/Restore?

By daniel.dolan

Any one have any experience with using Cohesity as the backup/restore platform instead of...

View runs slower

By sathwik.em91

I have the following query SELECT DateADD(day,9-DATEPART(dw,cdata .call_datetime ),cast(cdata .call_datetime as date) ) as...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers