Skip to content

Instantly share code, notes, and snippets.

@Erik-H-zz

Erik-H-zz/CreateTableWithTargets.sql

Created July 13, 2022 16:30
Show Gist options
  • Save Erik-H-zz/3524f4554c639525cc7d274994039fd3 to your computer and use it in GitHub Desktop.
Save Erik-H-zz/3524f4554c639525cc7d274994039fd3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
CreateTableWithTargets.sql
CREATE TABLE [dwh].[TargetPerConsultant](
[RowID] [int] IDENTITY(1,1) PRIMARY KEY,
[Firstname] [varchar](50) NULL,
[TargetAmount] [smallmoney] NULL
) ON [PRIMARY]
GO
INSERT INTO [dwh].[TargetPerConsultant] (FirstName,TargetAmount)
VALUES ('Arthur',1200),
('Erik', 1000),
('Tom', 900)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment