Posted: Thu Sep 08, 2011 5:11 pm Post subject: year matching query
Please find below is the existing query running in the system
FROM PROC_TABLE T24
LEFT OUTER JOIN
ON T16.IN_LOC = T24.IN_LOC
AND T16.PART_NO = T24.PART_NO
AND T16.PART_DES= T24.PART_DES
AND T24.IN_LOC ='ARCANSA'
AND T24.PART_DES ='MATERIAL'
AND T24.CALEN_YEAR IN ('2011','2012','2013')
In the PROC_TABLE having CALEN_YEAR CHAR(4) values such as 2005 to 2014
In the DEV_TABLE having T16.EFF_DT DATE (10) values such as 2005-01-01 to 2013-12-31
My query need to compare the value of EFF_DT year filed to CALEN_YEAR ,If the EFF_DT year
having 2011 and before means that record should display CALEN_YEAR value 2011 rows
If the EFF_DT year
having 2012 means that record should display CALEN_YEAR value 2012 rows
If the EFF_DT year
having 2013 means that record should display CALEN_YEAR value 2013 rows
We should do match with CALEN_YEAR value and EFF_DT year value
My query should return the values like
CALEN_YEAR IN_LOC PART_NO PART_DES EFF_DT
2011 ARCANSA PART1111 MATERIAL 28-02-2008
2011 ARCANSA PART1111 MATERIAL 28-02-2009
2011 ARCANSA PART1111 MATERIAL 28-02-2010
2011 ARCANSA PART1111 MATERIAL 28-02-2011
2012 ARCANSA PART1111 MATERIAL 12-12-2012
2012 ARCANSA PART1111 MATERIAL 31-12-2012
2013 ARCANSA PART1111 MATERIAL 01-04-2013
2013 ARCANSA PART1111 MATERIAL 11-09-2013
Posted: Thu Oct 13, 2011 12:39 pm Post subject: Grey’s Anatomy Seasons 1-7: Brilliant Drama!
The seventh season of Grey's Anatomy DVD fresh breath on the medical drama, with characters and connections suddenly come to life again. The music was fun and I think we can determine who can sing and who can not sing so Callie almost every song, Bones DVD basically. No romance, backstabbing the hospital, pain and hope - and lots of heart, as the best seasons of Grey. A dominant theme is an important test for the blind designed by McDreamy (Patrick Dempsey) to a possible treatment for Alzheimer’s disease, The Big Bang Theory DVD which is based on two Meredith (Ellen Pompeo), whose mother died of the disease, and head (James Pickens Jr.), whose wife may be symptomatic. Meanwhile, Callie, heartbroken by the split with Arizona (Jessica Capshaw), is the newest member sends you reeling. The L Word DVD New characters are introduced, including Rachael Taylor as Lucy, a new Foxy obstetrics and gynecology, including Alex (Justin Chambers) is watching. Coming into this season after the way they finished the season 6 would be a challenge but I think she was treated beautifully. Curb Your Enthusiasm DVD Spoilers before: I know many people criticized story line early in the season of Christina, but it was my favorite.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum