Tags » SQL DateTime

SQL SERVER - List the Name of the Months Between Date Ranges - Part 2

Last week I wrote a blog post about SQL SERVER – List the Name of the Months Between Date Ranges. It was written in the response to the question – How to list the name of the months between two date ranges? 190 more words

SQL Authority

SQL SERVER - List the Name of the Months Between Date Ranges - Correction

Earlier I wrote a blog post about SQL SERVER – List the Name of the Months Between Date Ranges. It was written in the response to the question – How to list the name of the months between two date ranges? 190 more words

SQL Authority

SQL SERVER - List the Name of the Months Between Date Ranges

Here is another interesting question, I received the other day.

“How to list the name of the months between two date ranges?”

Very interesting question. I had no script ready for it so I asked my friend who used to my co-worker earlier and he has sent me the script which is listed below.

112 more words
SQL Authority

SQL SERVER - Finding if Current Week is Odd or Even - Script

Here is an interesting question I received from my friend who is working in Bank as a DBA.

“Pinal,

We have a requirement in bank that every 2nd and 4th week we keep more cash in our bank where as we can keep less cash on other weeks. 145 more words

SQL Authority