Description
Properties
| Name | Value |
|---|---|
| Collation | |
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Schema Bound | False |
| Created | 8/14/2017 11:20:08 |
| Last Modified | 8/14/2017 11:20:08 |
Columns
| Key | Name | Description |
|---|---|---|
| id_data_in_dtl | ||
| total_pakai |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
create view dbo.vw_sa_data_detail_in_pakai
---XencX---with encryption
as
SELECT id_data_in_dtl, SUM(qty_pakai) AS total_pakai
FROM tbl_data_in_pakai
GROUP BY id_data_in_dtl
GO
GO
create view dbo.vw_sa_data_detail_in_pakai
---XencX---with encryption
as
SELECT id_data_in_dtl, SUM(qty_pakai) AS total_pakai
FROM tbl_data_in_pakai
GROUP BY id_data_in_dtl
GO