Try a case statement

Something like this:

SELECT Customer,

 SUM(CASE graphname = 'Current Month Collections' THEN do something END) AS 'Current Month Collections'

FROM table

Keep in mind this is for display purposes.

Thanks,

Thanks everyone for your help.  My issue is not with the sproc, but rather with the .NET grid that I purchased.  Apparently it evaluates only checked off items, therefore the...

Thanks for the quick response;  Here is the stored procedure script for the second sproc.  Nothing special:

ALTER     PROCEDURE dbo.Supplyrequest_Updateoktoprocessexceptions

(

@Proposalno INT,

@Requestid INT

)

AS

DECLARE @Error INT

SET NOCOUNT ON

UPDATE Request_for_quote

 SET OKToprocessexp = 1, qtyException...

Hi,

Thanks for your reference snippet.  Worked great.

Have you tried http://www.ASP.NET - that works well. 

I think this forum is the one I used to use for VB6 (not sure) but it looks very familiar: http://www.vbwm.com/

I...

Hi,

This is what I'm trying to accomplish.

The reason why this structure is set this way is because of the MRP methodology in place.  Procurement needs to identify the total available...

Need assistance why my if conditions are failing:

DECLARE @Itemno varchar(32),

 @currentAvailable smallint,

 @AvailableCount smallint,

        @currentDemand float,

 @previousDemand float,

 @currentSupply float,

 @previousSupply float,

 @deliverydate smalldatetime,

        @RunningTotal float

SET @RunningTotal = 0

SELECT @currentAvailable = 0,@previousDemand = 0

DECLARE rt_cursor CURSOR

FOR

SELECT...

Hi This it take two I lost my initial repsonse.  The reason why this structure is set this way is because of the MRP methodology in place.  Procurement needs to...

Have you tried using a LEFT or RIGHT JOIN with a WHERE eliminating all the values where the two table join.  Your resultset would be something like this