|
![]() |
#1 |
Administrator
|
Цитата:
Специально приведен пример для View на Union на MSDN: https://msdn.microsoft.com/EN-US/library/gg846293.aspx Цитата:
private static server str Comp_Party_LifeTime(int branchNum)
{ switch (branchNum) { case 1: break; case 2: break; } Цитата:
CREATE VIEW "DBO".TESTVIEWUNION
AS SELECT A.ACCOUNTNUM AS ACCOUNTNUM ,A.PARTY AS PARTY ,A.DATAAREAID AS DATAAREAID ,A.RECID AS RECID , (CAST (((SELECT top 1 bg.DiscNoticeDelayDays from BankGroup as bg where bg.DiscNoticeDelayDays <= (123 + A.PARTY) /*1*/ )) AS INT)) AS COMPUTEDINT FROM CUSTTABLE A UNION SELECT A.CUSTACCOUNT ,A.LIFETIME ,A.DATAAREAID ,A.RECID , (CAST (((SELECT top 1 bg.DiscNoticeDelayDays from BankGroup as bg where bg.DiscNoticeDelayDays <= (123 + A.LIFETIME) /*2*/ )) AS INT)) AS COMPUTEDINT FROM ASSETBOOK A
__________________
Возможно сделать все. Вопрос времени |
|
|
За это сообщение автора поблагодарили: Logger (1), skuull (1). |
Теги |
query, view |
|
|