lyfz_repos/经典版源码/document/数据库表脚本/digitalview.sql

USE [db]
GO
/****** 对象:  View [dbo].[digitalview]    脚本日期: 12/06/2014 16:41:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER VIEW [dbo].[digitalview] 	AS SELECT 
id, 
name1, 
name2, 
taoxiname,
taoxijiage, 
waiter5, 
time8,
waiter7, 
time9, 
waiter4, 
time10, 
status4, 
status6, 
status5, 
txtype,	
(SELECT SUM(CAST(money AS float)) AS Expr1 FROM dbo.dindanbukuan WHERE (bz = '选片二销') AND (id = dbo.dindan.id)) AS money2,				 
(SELECT SUM(CONVERT(float, ps)) AS Expr2 FROM  dbo.dindansp WHERE (id = dbo.dindan.id)) AS ps,
(SELECT SUM(CONVERT(float, zs)) AS Expr3 FROM  dbo.dindansp AS dindansp_1 WHERE (id = dbo.dindan.id)) AS zs 
FROM dbo.dindan