Description
Properties
| Name | Value |
|---|---|
| Collation | |
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Schema Bound | False |
| Created | 9/11/2017 10:05:05 |
| Last Modified | 9/11/2017 10:05:05 |
Columns
| Key | Name | Description |
|---|---|---|
| ms_report_car_line_sum_id | ||
| total_base_part |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
create view dbo.vw_ms_setting_report_car_line_count_base_part
---XencX---with encryption
as
SELECT dt_ms_item_base_h_report_car_line_sum.ms_report_car_line_sum_id, COUNT(dt_ms_item_base.ms_item_base_no) AS total_base_part
FROM dt_ms_item_base_h_report_car_line_sum INNER JOIN
dt_ms_item_base ON dt_ms_item_base_h_report_car_line_sum.ms_item_base_h_report_car_line_sum_id = dt_ms_item_base.ms_item_base_h_report_car_line_sum_id
GROUP BY dt_ms_item_base_h_report_car_line_sum.ms_report_car_line_sum_id
GO
GO
create view dbo.vw_ms_setting_report_car_line_count_base_part
---XencX---with encryption
as
SELECT dt_ms_item_base_h_report_car_line_sum.ms_report_car_line_sum_id, COUNT(dt_ms_item_base.ms_item_base_no) AS total_base_part
FROM dt_ms_item_base_h_report_car_line_sum INNER JOIN
dt_ms_item_base ON dt_ms_item_base_h_report_car_line_sum.ms_item_base_h_report_car_line_sum_id = dt_ms_item_base.ms_item_base_h_report_car_line_sum_id
GROUP BY dt_ms_item_base_h_report_car_line_sum.ms_report_car_line_sum_id
GO