May 9, 2013 at 6:47 am
Hi,
We have fiscal quarters like FY13-Q1,FY13-Q2..
Need to display last 6 quarters (FY12-Q1 to FY13-Q2) and Current quarter (FY13-Q3) in a report and this should be dynamic.
How can we achieve this in Netezza database.
Thanks!
May 9, 2013 at 8:05 am
Hi and welcome to the forums. You might take a look at this link with lots of date routines.
http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/[/url]
If that is not enough help we are going to need a lot more detailed information. Please take a few minutes and read the first article in my signature for best practices when posting questions.
_______________________________________________________________
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/
May 9, 2013 at 8:56 am
This site is for Microsoft SQL Server questions, and does not deal with Netezza.
May 9, 2013 at 9:47 am
How can you get this in sql server?
May 9, 2013 at 10:00 am
Hard to answer with the vague information you have provided.
First, what makes up your fiscal periods (months, quarters, year)?
Second, since we can't see what you see there really isn't anything else we can really answer.
You should read the first article I reference below in my signature block regarding asking for help. It will walk you through what you need to post and how to post it to get better answers than what we can give you now.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply