Description
Properties
| Name | Value |
|---|---|
| Collation | |
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Schema Bound | False |
| Created | 9/11/2017 10:32:38 |
| Last Modified | 9/11/2017 10:32:38 |
Columns
| Key | Name | Description |
|---|---|---|
| ms_manual_invoice_id | ||
| item_count | ||
| unmap |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
create view dbo.vw_ms_manual_invoce_item_count
---XencX---with encryption
as
SELECT ms_manual_invoice_id, COUNT(*) AS item_count ,sum(case when nullif(mapping_ms_item_id,-1) is null then 1 else 0 end ) as unmap
FROM dt_ms_manual_invoice_detail
GROUP BY ms_manual_invoice_id
GO
GO
create view dbo.vw_ms_manual_invoce_item_count
---XencX---with encryption
as
SELECT ms_manual_invoice_id, COUNT(*) AS item_count ,sum(case when nullif(mapping_ms_item_id,-1) is null then 1 else 0 end ) as unmap
FROM dt_ms_manual_invoice_detail
GROUP BY ms_manual_invoice_id
GO