dbo.vw_ms_grn_item

Description

Properties

Name	Value
Collation	SQL_Latin1_General_CP1_CI_AS
ANSI Nulls ON	True
Quoted Identifier ON	True
Encrypted	False
Schema Bound	False
Created	11/28/2019 04:07:25
Last Modified	11/28/2019 04:12:42

Columns

Key	Name	Description
	item_count
	GRNUMBER
	GRDATE
	SHIPPING
	SHIPPER

SQL Script

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO

CREATE view dbo.vw_ms_grn_item_count
---XencX---with encryption
as
  SELECT       COUNT(*) AS item_count ,
  GRNUMBER,GRDATE ,SHIPPING,SHIPPER

FROM            test_compare
GROUP BY GRNUMBER,GRDATE,SHIPPING,SHIPPER

GO

Depends On

dbo.test_compare

Used By

No items found