If there is I'd be interested to see it. I've had a similar problem before and used the case statement. You could write a function to do it that accepts...

Just a thought, it looks like you only want to delete the data from FT if it does not have a key in FTR.

You could therefore scan for those entries...

how about just

CREATE PROCEDURE ChartGetRegisteredUsers

 AS

select (SELECT count(DistributorID) from Distributors WHERE approvalstatuscode = 2) as Distributors,

         (SELECT count(ResellerID) from Resellers WHERE approvalstatuscode = 2) as Resellers

GO

It's good to see someone looking at the upsides for a change, I think its human nature to always highlight the downsides and sometimes we forget about the good things.

IT...

Hi,

I'd need more information to be able to comment on this.

1) You get the difference in dev and live - Are the data volumns the same in both environments?

2) Have...