Description
Properties
| Name | Value |
|---|---|
| Collation | |
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Schema Bound | False |
| Created | 9/11/2017 11:00:25 |
| Last Modified | 9/11/2017 11:00:25 |
Columns
| Key | Name | Description |
|---|---|---|
| id_source_header | ||
| count_item | ||
| count_minus | ||
| count_plus |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
create view dbo.vw_ms_adjustment_item_sum
---XencX---with encryption
as
SELECT
id_source_header
, COUNT(*) AS count_item
, sum(is_minus) as count_minus
, sum(is_plus) as count_plus
FROM vw_ms_adjustment_item
GROUP BY id_source_header
GO
GO
create view dbo.vw_ms_adjustment_item_sum
---XencX---with encryption
as
SELECT
id_source_header
, COUNT(*) AS count_item
, sum(is_minus) as count_minus
, sum(is_plus) as count_plus
FROM vw_ms_adjustment_item
GROUP BY id_source_header
GO