Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.
SELECT v.rep, Sum(v.[Gross Rev]) as GrossRev, DATENAME(month, v.Funded) as Mth Into #temp FROM CRMPROD_01.dbo.v_P_Reporting v WHERE v.Funded is not null and v.Status <> 'Closed' and (YEAR(v.Funded) = YEAR(getdate())) and (MONTH(v.Funded) > MONTH(getdate())-3) Group by rep, v.Funded ORDER BY v.rep, DATENAME(month, v.Funded) SELECT Rep,June,July FROM ( SELECT Rep,Mth,Grossrev FROM #temp)P PIVOT (SUM(Grossrev) FOR Mth IN (June,July))As Pvt order by rep
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Returning Message/Value Back to Access from a SQL Server trigger||3||36|
|user database (login sql or login windows)||3||31|
|.Net remove carriage returns, line feeds and tabbs||5||18|
|T-SQL: Need training video on creating a Clustered Index||2||13|