Ver Mensaje Individual
  #6 (permalink)  
Antiguo 24/01/2014, 09:24
Avatar de Libras
Libras
Colaborador
 
Fecha de Ingreso: agosto-2006
Ubicación: En la hermosa perla de occidente
Mensajes: 7.412
Antigüedad: 17 años, 8 meses
Puntos: 774
Respuesta: Como hacer la suma del siguiente campo con sqlserver?

Código SQL:
Ver original
  1. SELECT *, isnull(win,0)-isnull(loss,0) AS resultado FROM(
  2.  
  3. SELECT *
  4. CASE WHEN RESULT=1 OR tickets=1 THEN SUM(h.winamount) END AS win,
  5. CASE WHEN RESULT=0 OR tickets=0 THEN SUM(h.winamount) END AS loss
  6. FROM(
  7. SELECT CONVERT(VARCHAR(8), H.[SettledDate] , 108) AS 'Time', CONVERT(VARCHAR(MAX),G.[VisitorNumber]) + '/' + CONVERT(VARCHAR(MAX),G.[HomeNumber]) AS 'NumGame',
  8.        G.[VisitorTeam] + '@'+ G.[HomeTeam] AS 'Teams', CONVERT(VARCHAR(MAX),G.[VisitorScore]) + ' - ' + CONVERT(VARCHAR(MAX),G.[HomeScore]) AS 'Score', COUNT(*) AS 'Tickets',
  9.        SUM(H.[RiskAmount]) AS 'Risk',d.RESULT,h.winamount
  10. FROM  GRADEDGAME G, GRADEDWAGERHEADER H, GRADEDWAGERDETAIL D, AGENT A, WAGERTYPE W
  11. WHERE D.[IdGame]      =  G.[IdGame]         AND
  12.       D.[IdWager]     =  H.[IdWager]        AND
  13.       H.[IdAgent]     =  A.[IdAgent]        AND
  14.       H.[IdWagerType] =  W.[IdWagerType]    AND
  15.       G.[GradedDate] >= CONVERT(datetime,('2014-01-12 00:00:00')) AND
  16.       G.[GradedDate] <= CONVERT(datetime,('2014-01-12 23:59:59')) AND
  17.       W.[Description] NOT LIKE '%PARLAY%' AND
  18.       W.[Description] NOT LIKE '%REVERSE ACTION%' AND
  19.       H.[IdAgent] = 5585
  20. GROUP BY H.[SettledDate], G.[VisitorNumber], G.[HomeNumber], G.[VisitorTeam], G.[HomeTeam], G.[VisitorScore], G.[HomeScore], d.RESULT,h.winamount
  21. ) AS t1
  22. ) AS t2
__________________
What does an execution plan say to t-sql query? Go f**k yourself, if you are not happy with me