22 lines
825 B
Transact-SQL
22 lines
825 B
Transact-SQL
USE [envisage]
|
|
GO
|
|
/****** Object: View [dbo].[VW_Expenditure2FeeCalculation] Script Date: 06/23/2014 13:20:56 ******/
|
|
IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[VW_Expenditure2FeeCalculation]'))
|
|
DROP VIEW [dbo].[VW_Expenditure2FeeCalculation]
|
|
|
|
/****** Object: View [dbo].[VW_Expenditure2FeeCalculation] Script Date: 06/23/2014 13:21:28 ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER OFF
|
|
GO
|
|
CREATE VIEW [dbo].[VW_Expenditure2FeeCalculation]
|
|
AS
|
|
SELECT Fee_Calculation.Id,
|
|
Fee_Calculation.ExpenditureCategoryId,
|
|
Fee_Calculation.MinShot,
|
|
Fee_Calculation.MaxShot,
|
|
Fee_Calculation.Quantity,
|
|
Expenditure_Category.WksSubjectToFee
|
|
FROM Fee_Calculation
|
|
INNER JOIN Expenditure_Category ON Fee_Calculation.ExpenditureCategoryId = Expenditure_Category.Id
|