sql query question
I have tableA and I want the values of groupid2 to be updated as shown in Tableb CONSIDERING max of yr
ID groupid1 yr groupid2
100 10 1
101 10 2010 1
102 10 100
104 30 2009 22
105 30 34
106 30 2004 34
ID groupid1 yr groupid2
100 10 1
101 10 2010 1
102 10 1
104 30 2009 22
105 30 22
106 30 2004 22
May 23rd, 2011 10:35pm
This is not the Right Forum for this Question.Rakesh M J
Free Windows Admin Tool Kit Click here and download it now
May 23rd, 2011 11:27pm