Single line code

[aamkumar]

Can any one suggest some single line code for this instead of multiple lines

(({Month}= "DECEMBER" and 
 {YearNumber} = 2004)

 or ({Month}= "JANUARY" and 
{YearNumber} = 2005)

or ({Month}= "FEBRUARY" and 
{YearNumber}= 2005)


or ({Month}= "MARCH" and 
{YearNumber}= 2005))

 

[SQLDenis]

YearNumber= 2005
and Month In( 'DECEMBER','JANUARY','FEBRUARY','MARCH' )

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
Google Interview Questions

 

[aamkumar]

But I have year 2004 also and it is for December only for 2004

 

[gmmastros]

How about this...

Year * 100 + Month Between 200412 And 200503


-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[aamkumar]

What do you mean when you do "year*100"

 

[r937]

Year*100+Month won't work if Month is a name (srting)

how about this --

Month+Yearnumber in ('DECEMBER2004','JANUARY2005','FEBRUARY2005','MARCH2005')

r937.com | rudy.ca