Description
Properties
| Name | Value |
|---|---|
| Collation | |
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Schema Bound | False |
| Created | 9/11/2017 10:55:01 |
| Last Modified | 9/11/2017 10:55:01 |
Columns
| Key | Name | Description |
|---|---|---|
| ms_memo_header_id | ||
| total_item | ||
| count_supply |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
create view dbo.vw_ms_memo_header_count_detail
---XencX---with encryption
as
SELECT
ms_memo_header_id
,count(*) as total_item
,sum(count_supply) as count_supply
FROM
vw_ms_memo_detail_sum_supply
group by ms_memo_header_id
GO
GO
create view dbo.vw_ms_memo_header_count_detail
---XencX---with encryption
as
SELECT
ms_memo_header_id
,count(*) as total_item
,sum(count_supply) as count_supply
FROM
vw_ms_memo_detail_sum_supply
group by ms_memo_header_id
GO