Extract the data based on the present quarter and last quarter

Question

Post reply

Extract the data based on the present quarter and last quarter

Smash125

Hall of Fame

Points: 3562
More actions
December 16, 2013 at 10:44 am

#302455

How to
Extract the data based on the present quarter and last quarter in SQL
Please let me know
Regards,
Praveen

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Luis Cazares SSC Guru Points: 183706 More actions · Answer 1

There's not enough information to help you.

Please post DDL, sample data and expected results as explained on the article linked in my signature.

We're willing to help but we can't see what you see.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Ed Wagner SSC Guru Points: 287026 More actions · Answer 2

You're going to need to use the DATEPART function to determine the quarter for the date on which you're basing the distribution. http://msdn.microsoft.com/en-us/library/ms174420%28v=sql.100%29.aspx. Other than that, Luis is right - we don't know anything about your table structure or what you're trying to do. Please post DDL, DML to populate sample data and what you've tried so far.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Sean Lange SSC Guru Points: 286590 More actions · Answer 3

Here are some excellent ways to get a number of different datetime values. http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/[/url]

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 4

Smash125 (12/16/2013)
How to
Extract the data based on the present quarter and last quarter in SQL
Please let me know
Regards,
Praveen

SELECT TheData

FROM dbo.SomeTable

WHERE SomeDateColumn >= DATEADD(qq,DATEDIFF(qq,0,GETDATE())-1,0)

;

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)