getCalendarQTR

The script returns the quarter and year of a date submitted in the form of '105' - first quarter of 2005 - and is useful for grouping data by calendar quarter. Easy to modify for fiscal quarters.

2005-04-07 (first published: )

81 reads

Blogs

Containers: Create a Custom Container

By

Creating a custom container is where things get truly exciting. There’s actually a ton...

Mini-Rant: Spoofed Phone Numbers and Trust

By

I’ve seen this more and more over the last year: I receive a phone...

Speaking at SQL Saturday Dallas

By

Speaking at SQLSaturday Dallas! I’m proud to announce that I will be speaking at SQL...

Read the latest Blogs

Forums

The Change Failure Rate

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Change Failure Rate

insert and update

By girl_bj

Hi, need some advice. I have more than 20 columns and more than 50k...

How to map the table data while inserting into another table in sql

By nagaraj

  table1 id   value 2    20 3    30 4    40 5 ...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers