IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[BudgetExportView]') AND OBJECTPROPERTY(id, N'IsView') = 1)
DROP VIEW [dbo].[BudgetExportView]
GO

create view dbo.BudgetExportView as

SELECT bindata.binheaderid, bindata.unitid,
SUM(CASE Bin WHEN 1 THEN [value] ELSE 0 END) AS bin1value,
SUM(CASE Bin WHEN 1 THEN [uvalue] ELSE 0 END) AS bin1uvalue,
SUM(CASE Bin WHEN 1 THEN ISNULL([value]/NULLIF([uvalue],0),0) ELSE 0 END) AS bin1ucvalue,
SUM(CASE Bin WHEN 2 THEN [value] ELSE 0 END) AS bin2value,
SUM(CASE Bin WHEN 2 THEN [uvalue] ELSE 0 END) AS bin2uvalue,
SUM(CASE Bin WHEN 2 THEN ISNULL([value]/NULLIF([uvalue],0),0) ELSE 0 END) AS bin2ucvalue,
SUM(CASE Bin WHEN 3 THEN [value] ELSE 0 END) AS bin3value,
SUM(CASE Bin WHEN 3 THEN [uvalue] ELSE 0 END) AS bin3uvalue,
SUM(CASE Bin WHEN 3 THEN ISNULL([value]/NULLIF([uvalue],0),0) ELSE 0 END) AS bin3ucvalue,
SUM(CASE Bin WHEN 4 THEN [value] ELSE 0 END) AS bin4value,
SUM(CASE Bin WHEN 4 THEN [uvalue] ELSE 0 END) AS bin4uvalue,
SUM(CASE Bin WHEN 4 THEN ISNULL([value]/NULLIF([uvalue],0),0) ELSE 0 END) AS bin4ucvalue,
SUM(CASE Bin WHEN 5 THEN [value] ELSE 0 END) AS bin5value,
SUM(CASE Bin WHEN 5 THEN [uvalue] ELSE 0 END) AS bin5uvalue,
SUM(CASE Bin WHEN 5 THEN ISNULL([value]/NULLIF([uvalue],0),0) ELSE 0 END) AS bin5ucvalue,
SUM(CASE Bin WHEN 6 THEN [value] ELSE 0 END) AS bin6value,
SUM(CASE Bin WHEN 6 THEN [uvalue] ELSE 0 END) AS bin6uvalue,
SUM(CASE Bin WHEN 6 THEN ISNULL([value]/NULLIF([uvalue],0),0) ELSE 0 END) AS bin6ucvalue,
SUM(CASE Bin WHEN 7 THEN [value] ELSE 0 END) AS bin7value,
SUM(CASE Bin WHEN 7 THEN [uvalue] ELSE 0 END) AS bin7uvalue,
SUM(CASE Bin WHEN 7 THEN ISNULL([value]/NULLIF([uvalue],0),0) ELSE 0 END) AS bin7ucvalue,
SUM(CASE Bin WHEN 8 THEN [value] ELSE 0 END) AS bin8value,
SUM(CASE Bin WHEN 8 THEN [uvalue] ELSE 0 END) AS bin8uvalue,
SUM(CASE Bin WHEN 8 THEN ISNULL([value]/NULLIF([uvalue],0),0) ELSE 0 END) AS bin8ucvalue,
SUM(CASE Bin WHEN 9 THEN [value] ELSE 0 END) AS bin9value,
SUM(CASE Bin WHEN 9 THEN [uvalue] ELSE 0 END) AS bin9uvalue,
SUM(CASE Bin WHEN 9 THEN ISNULL([value]/NULLIF([uvalue],0),0) ELSE 0 END) AS bin9ucvalue,
SUM(CASE Bin WHEN 10 THEN [value] ELSE 0 END) AS bin10value,
SUM(CASE Bin WHEN 10 THEN [uvalue] ELSE 0 END) AS bin10uvalue,
SUM(CASE Bin WHEN 10 THEN ISNULL([value]/NULLIF([uvalue],0),0) ELSE 0 END) AS bin10ucvalue,
SUM(CASE Bin WHEN 11 THEN [value] ELSE 0 END) AS bin11value,
SUM(CASE Bin WHEN 11 THEN [uvalue] ELSE 0 END) AS bin11uvalue,
SUM(CASE Bin WHEN 11 THEN ISNULL([value]/NULLIF([uvalue],0),0) ELSE 0 END) AS bin11ucvalue,
SUM(CASE Bin WHEN 12 THEN [value] ELSE 0 END) AS bin12value,
SUM(CASE Bin WHEN 12 THEN [uvalue] ELSE 0 END) AS bin12uvalue,
SUM(CASE Bin WHEN 12 THEN ISNULL([value]/NULLIF([uvalue],0),0) ELSE 0 END) AS bin12ucvalue
FROM bindata
GROUP BY bindata.binheaderID, bindata.unitid
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BudgetExportView]') and OBJECTPROPERTY(id, N'IsView') = 1)
GRANT SELECT ON  [dbo].[BudgetExportView] TO [public]
GO