pareekayush6

USE [reporting]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[trn_weakness_report] AS
  IF OBJECT_ID('reporting.dbo.weakness_report', 'U') IS NOT NULL
    DROP TABLE reporting.dbo.weakness_report;

pareekayush6

DROP TABLE IF EXISTS sandbox.f_test;
CREATE TABLE sandbox.f_test
(
    date_skey INTEGER ENCODE LZO,
    item_skey BIGINT ENCODE LZO,
    shop_skey INTEGER ENCODE LZO,
    field1    DECIMAL(12, 2) ENCODE LZO,
    field2    DECIMAL(12, 2) ENCODE LZO,
    field3    DECIMAL(12, 2) ENCODE LZO,
    field4    DECIMAL(12, 2) ENCODE LZO,