Awesome man....Thanks a lot:-)

I am using getdate() function for create_date column, so whenever i will execute my ETL create date will set to get date, but i need first create_date to be...

Thanks man...it worked 🙂

Thanks guys for your help, somehow i managed to find the optimized solution for finding maximum value on column level. The code which is used is as follows:

select max(MAXValue)

...

select the table data on design window then go to properties menu and you will find font and other properties so you can set it from there

There is one more issue comes into picture when we use isnull and replacing null with 0 and not null with 1 in denominator. If suppose we have nulls in...

But do you think this solution is making our query more expensive because if have more number of columns then using case and isnull in denominator is challenge. And also...

Thanks a lot UDP Broadcaster 🙂

This solutions is working fine and i am getting results.

Thank you all guys for your valuable inputs.

No its still giving 0, i mean when i changed the syntax and made it sign(isnull(col1,0)), it is still not calculating it 🙁

Thanks a lot for reply man, but it is returning average as 0 when i am using Sign function.

Congratulations . A thanks for such an valuable information.