Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.
CREATE TABLE [dbo].[DIM_PRODUCT]( [product_id] [int] IDENTITY(1,1) PRIMARY KEY NOT NULL, [item_category] varchar(4) NULL, [variety] varchar(2) NULL, [variety_short] varchar(15) NULL, [commodity] varchar(2) NULL, [commodity_short] varchar(4) NULL, [lot] varchar(3) NULL, [deal] varchar(3) NULL, [exporter] varchar(6) NULL, )
CREATE TABLE [dbo].[FACT_SALES]( [fk_product_id] int NOT NULL, [2LYR_volume] money NULL, [qe_fob] money NULL, [oe_freight] money NOT NULL, [oe_brokerage] money NOT NULL, [oe_other] money NOT NULL, [tt_fob] money NOT NULL, [net_fob] money NOT NULL, [average_gross] money NOT NULL, [total_income] money NOT NULL, [total_revenue] money NOT NULL, [accrued_income] money NOT NULL, ) ALTER TABLE FACT_SALES ADD CONSTRAINT FK_DimProduct FOREIGN KEY (fk_product_id) REFERENCES DIM_PRODUCT(product_id) GO
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|how to resize column length with primary ket||4||27|
|rolling count by date, hour query||7||26|
|SQL - Update field value based on two other fields in same table.||13||33|
Join the community of 500,000 technology professionals and ask your questions.