No I am not missing values I am getting the exact results what I am expecting, I tested.

This is the custom case statement that I used

case when (units - floor(units)) < 0.49 then round(units,2)

when (units...

Hi all, Thank you for the answers but I figured out that using a case statements for custom rounding is the best way and it worked out

This worked perfect. Thanks A lOT!!!:-)

THank You

But I do not want to use .net since I am not a .net person.I want to use only sql server and ssis package.

Can anyone help me out in...

Hi,

We are using the pitney bowes scanner to scan the documents.

The codes we use are for Benchmark,BOC,EOC,SAF

It would be very helpfull if you can provide with the location as to...

Thank You

Will try this out.

Thanks a lot.

It worked perfectly!!!

There no error in code since if i add the script as dataset my report is running perfect without any errors

only when i select dataset as sp and running the...

I got the solution.

It is just that I had to add more of inner join and left join and no need of any temp tables.

Is there a pk -fk link between table

Below is the sample code

now my question is where do I add the above code so that this sp will return the col supervisor

ALTER PROCEDURE [dbo].[mc_selClientsActiveNoService]

-- Add the...

Hi my condition is that I already have a sp and I have to add this code and modify the sp so that it returns a column supervisor which...