April 29, 2013 at 4:19 pm
Hi Experts,
C_KEY ENTER_DATE
1 2008-12-31 00:00:00.000
2 2008-12-31 00:00:00.000
3 2008-12-31 00:00:00.000
4 2009-12-31 00:00:00.000
5 2009-12-31 00:00:00.000
6 2009-12-31 00:00:00.000
7 2010-12-31 00:00:00.000
8 2010-12-31 00:00:00.000
9 2010-12-31 00:00:00.000
10 2010-12-31 00:00:00.000
can someone help me in finding min and max c_key for all years.
for EG:
YEAR Min C KEY MAX CKEY
2008 1 3
2009 4 6
2010 7 10
April 29, 2013 at 4:21 pm
Slightly confused, does this not work?
SELECT
YEAR( Enter_Date) AS yr,
MIN( C_Key) AS MinKey,
MAX( C_Key) AS MaxKey
FROM
Sometable
GROUP BY
Year( Enter_Date)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 29, 2013 at 9:35 pm
Evil, for us old timies that still work on sql 2005 most of the time, the Year() might not have been the first thing that came to mind. None-the-less, great solution
--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455
April 30, 2013 at 11:49 am
Calibear (4/29/2013)
Evil, for us old timies that still work on sql 2005 most of the time, the Year() might not have been the first thing that came to mind. None-the-less, great solution
Year is available since 2k5. It wasn't available in 2k, where you had to use datepart.
http://msdn.microsoft.com/en-us/library/ms186313(v=sql.90).aspx
So, if you're still in 2k5, it's available! 🙂 I've only switched up to 2k8 in the last 6 months or so professionally.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 30, 2013 at 11:53 am
Well, I'll be, I thought it was 2008. Thanks
--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply