Re: [GENERAL] SQL Query Help Please !

On 7/6/2010 3:06 AM, GrGsM wrote: Hi all I am using the following query for data to be displayed in crosstab : SELECT closedate,status, SUM (CASE WHEN empcode = 'NT-028' THEN 1 ELSE 0 END) AS NT028, SUM (CASE WHEN empcode = 'NT-031' THEN 1 ELSE 0 END) AS NT031,

Re: [GENERAL] SQL Query Help Please !

On Tue, Jul 06, 2010 at 12:06:06AM -0700, GrGsM wrote: > SELECT closedate,status, >SUM (CASE WHEN empcode = 'NT-028' THEN 1 ELSE 0 END) AS NT028, >SUM (CASE WHEN empcode = 'NT-031' THEN 1 ELSE 0 END) AS NT031, >SUM (CASE WHEN empcode = 'NT-050' THEN 1 ELSE 0

Re: [GENERAL] SQL Query Help Please !

GrGsM, 06.07.2010 09:06: Now i need a column in the same result of the query which shows the difference between the two columns . For Example : the result shoud be Closedate , status , NT028, NT031, NT050,NT062 , NT028-NT031 Please note the last column in bold, i need the difference . Alr

[GENERAL] SQL Query Help Please !

Hi all I am using the following query for data to be displayed in crosstab : SELECT closedate,status, SUM (CASE WHEN empcode = 'NT-028' THEN 1 ELSE 0 END) AS NT028, SUM (CASE WHEN empcode = 'NT-031' THEN 1 ELSE 0 END) AS NT031, SUM (CASE WHEN empcode = 'NT-0