Gsquared / Antonio,

1.

I guess I have to go with the following as this what I intend to do.

set @Vraidd = isnull(@Vraidd, @id)

I will sit & figure out the...

Yes, comparing data b/w Filefit(table1) and from a temp table which holds join data & that would be myTempTable(Vraiid & FlCA)

Tables - Filefit, myTemptable(which happens to be a join here)

columns...

Gsquared -

Yes, you are right in that I missed one ' mark in there.

But the issue is what I intended to create & what I created are two different...

Gsquared / Antonio,

Thanks for being patient wiht me.

Here is what I came up & it is throwing a syntax error. My another question is how do I run this stored...

Gsquared -

Some one gave me this template & wants me to frame my comparision using this. Now the issue that I have is, I can directly refer the first...

Gsquared -

Im trying to declare another table, which happens to be the output of

select bb.Vraiid, pc.FLCA

from blueribbon bb

join pcvar pc on pc.Bbgid = bb.Bbgid

join btiy be on be.Bbgid...

Im not sure either but they are running some kind of statistical analysis on these ... logistical regression analysis..

Gsquared,

That worked & Thanks a bunch !

I guess one cant be careful enough !

Antares686,

The rollup did the trick !!! Thank you very much.

As an addendum to this, how do I find the count(s)? Can it be done ?

Now, how do I sort...

Antares686,

I think your observation is right however, I cannot cut & copy stuff from my app & it was a typo. My mistake that you didnt see = in there....

In line with the previous request, lets say how do I find the percentage, between a.lev1 & b.firstline.

As it is forecasting vis-a-vis, the value can never be greater than...

Gsquared -

This might sound like a cliche but that was a 'great' answer & it just fit the bill.

Can you tell what was wrong with my approach...