Im not sure if I understand your goal, however what ever results you are looking at seem to make sense to me if you to show all the months seperately....

Sorry, I was away & I just saw this.

Remove "B.CodigoAcceso" from the query and re-run and you should now only see 174 rows.

I would have to take a bit of diversion (only a little bit) and use a Join here because what I found so far is that "IN" seems to be...

ML,

Cant agree with you more on this one !!! It certainly makes me walk home tall that evening when I successfully sort out issues on my own.

Thanks anyways.

Kumar.

ML,

I got this sorted out a while ago but I never kept up with this forum as such. Actually, I used cast & rolled sa_ss to INT & then it...

Gsquared -

Thanks a bunch !!!

Gsquared -

Import manager is throwing some kind of "SSIS" errors & when I took up to the infra team, they said, they need to re-install & that may take...

Bledu,

You have noticed the correct thing but it is in its place & what I did to over come this problem is to create a derived table and then do...

I think I finally got it... & here it is .... Thanks a lot 'Bledu' & 'Cbaker'

SELECT MIN(Table_Name) AS Table_Name, beenumber, nacdate, ConsultantPromDt, TeamLeadPromDt

FROM

(

SELECT 'Table A' AS...

Bledu,

I followed your advice & threw in bunch of validations & here is where Im struck at now...

SELECT 'Table B' AS Table_Name, b.sa_ss as beenumber, cl1 as nacdate, cl2 as...

I prettty much pasted everything that I was seeing & that was that. Anyway, I got this sorted out by creating a derived table after grouping them.

Thanks one & All...

Matt,

I guess what ever you are saying, isnt echoing me the result that I look for.

However I got what I needed by writing another outer query & calling the Query3...

Matt,

When I added 'OR ea.totalPROM is null', it is fetching me 95 rows now.

I'm completely clueless !

Matt,

Thanks for the heads up on the 'where' clause.

So when I delete the totalprom != 0.0, I get almost 2898 rows which once again looks like a cross join...