su.dbms.sql

 
 - SU.DBMS.SQL ------------------------------------------------------------------
 From : Akzhan Abdulin                       2:5030/217     17 Feb 2001  16:11:38
 To : All
 Subject : деревья 5
 -------------------------------------------------------------------------------- 
 

 Типичное использование:
 
 === Cut ===
 SET QUOTED_IDENTIFIER ON
 GO
 CREATE VIEW akViewAccountCreditBalance2
 AS
   SELECT
     AA.AncestorId AS "Id",
     FM.CurrencyId AS CurrencyId,
     SUM(FM."Sum") AS "Sum"
   FROM
     AnAccountAndItsAncestors AA
     INNER JOIN AFinanceMovement FM ON (AA.AccountId = FM.CreditAccountId)
   GROUP BY
     AA.AncestorId,
     FM.CurrencyId
 GO
 
 SET QUOTED_IDENTIFIER ON
 GO
 CREATE VIEW akViewAccountDebitBalance2
 AS
   SELECT
     AA.AncestorId AS "Id",
     FM.CurrencyId AS CurrencyId,
     SUM(FM."Sum") AS "Sum"
   FROM
     AnAccountAndItsAncestors AA
     INNER JOIN AFinanceMovement FM ON (AA.AccountId = FM.DebitAccountId)
   GROUP BY
     AA.AncestorId,
     FM.CurrencyId
 GO
 
 === Cut ===
 
 === Cut ===
 SET QUOTED_IDENTIFIER ON
 GO
 CREATE VIEW akViewAccountBalance2_Supp
 AS
     SELECT
       CB."Id" AS "Id",
       CB.CurrencyId AS CurrencyId,
       CB."Sum" AS CreditSum,
       CAST(NULL AS MONEY) AS DebitSum
     FROM
       akViewAccountCreditBalance2 CB
   UNION ALL
     SELECT
       DB."Id" AS "Id",
       DB.CurrencyId AS CurrencyId,
       CAST(NULL AS MONEY) AS CreditSum,
       DB."Sum" AS DebitSum
     FROM
       akViewAccountDebitBalance2 DB
 GO
 
 SET QUOTED_IDENTIFIER ON
 GO
 CREATE VIEW akViewAccountBalance2
 AS
   SELECT
     "Id",
     CurrencyId,
     SUM(CreditSum) AS CreditSum,
     SUM(DebitSum) AS DebitSum
   FROM
     akViewAccountBalance2_Supp
   GROUP BY
     "Id",
     CurrencyId
 GO
 
 === Cut ===
 
 === Cut ===
 SET QUOTED_IDENTIFIER ON
 GO
 CREATE FUNCTION dbo.akGetAccountBalance2 (@AccountId AnAccountId)
 RETURNS TABLE
 AS
 RETURN
   SELECT CurrencyId, CreditSum, DebitSum
   FROM akViewAccountBalance2
   WHERE "Id" = @AccountId
 GO
 
 === Cut ===
 
 Akzhan
 
 --- FMail/Win32 1.42/g
  * Origin: MT Computers, mailto:akzhan@mtgroup.ru (2:5030/217)
 
 

Вернуться к списку тем, сортированных по: возрастание даты  уменьшение даты  тема  автор