Description
Properties
| Name | Value |
|---|---|
| Collation | |
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Schema Bound | False |
| Created | 11/28/2019 22:38:08 |
| Last Modified | 11/28/2019 22:39:57 |
Columns
| Key | Name | Description |
|---|---|---|
| supplier_customer_id | ||
| grn_total | ||
| grn_ready |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE view dbo.vw_ms_molts_grn_group_supplier
---XencX---with encryption
as
SELECT mapping_supplier_customer_id AS supplier_customer_id
, COUNT(*) AS grn_total,
sum(case when r_s=0 then 1 else 0 end) as grn_ready
FROM vw_ms_molts_grn
where (NOT (mapping_supplier_customer_id = - 1 OR
mapping_supplier_customer_id IS NULL) ) and used =0
GROUP BY mapping_supplier_customer_id
GO
GO
CREATE view dbo.vw_ms_molts_grn_group_supplier
---XencX---with encryption
as
SELECT mapping_supplier_customer_id AS supplier_customer_id
, COUNT(*) AS grn_total,
sum(case when r_s=0 then 1 else 0 end) as grn_ready
FROM vw_ms_molts_grn
where (NOT (mapping_supplier_customer_id = - 1 OR
mapping_supplier_customer_id IS NULL) ) and used =0
GROUP BY mapping_supplier_customer_id
GO