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 | 12/13/2018 14:43:10 |
| Last Modified | 12/13/2018 14:43:10 |
Columns
| Key | Name | Description |
|---|---|---|
| id | ||
| no_skep | ||
| startdate | ||
| enddate | ||
| create_by | ||
| create_date | ||
| update_by | ||
| update_date |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE VIEW dbo.view_kurs_header as SELECT dbo.dt_currencies_header.id, dbo.dt_currencies_header.no_skep, dbo.dt_currencies_header.startdate, dbo.dt_currencies_header.enddate, users_1.username AS create_by,
dbo.dt_currencies_header.createdate AS create_date, dbo.users.username AS update_by, dbo.dt_currencies_header.editdate AS update_date
FROM dbo.dt_currencies_header LEFT OUTER JOIN
dbo.users ON dbo.dt_currencies_header.editby = dbo.users.id LEFT OUTER JOIN
dbo.users AS users_1 ON dbo.dt_currencies_header.createby = users_1.id
GO
GO
CREATE VIEW dbo.view_kurs_header as SELECT dbo.dt_currencies_header.id, dbo.dt_currencies_header.no_skep, dbo.dt_currencies_header.startdate, dbo.dt_currencies_header.enddate, users_1.username AS create_by,
dbo.dt_currencies_header.createdate AS create_date, dbo.users.username AS update_by, dbo.dt_currencies_header.editdate AS update_date
FROM dbo.dt_currencies_header LEFT OUTER JOIN
dbo.users ON dbo.dt_currencies_header.editby = dbo.users.id LEFT OUTER JOIN
dbo.users AS users_1 ON dbo.dt_currencies_header.createby = users_1.id
GO
Depends On
2Used By
No items found