This sounds like homework. Is this homework? In which case, I'll help where you have problems with the work you've done. Please note the tricky phrase, the work you've...

Thank you for assisting.

I have the test data available in re-created bacpac() and Excel format() and attached.

Besides the requirements below, you are welcome to make changes or...

• This reply was modified 1 year, 9 months ago by  yrstruly.
• This reply was modified 1 year, 9 months ago by  yrstruly.

I provided data in the form of a bacpac file. I am not able to provide data in any other format. The backpack file contains the data as it is...

@Ant-Green did you have a chance to test the DB according to the requirements?

Does the dataset meet these requirements?: "Dimensional table and procedure that tracks Primary Accounts’ group movements. An

account moves to different groups that are associated with levels of commission paid.

Analysts needs...

Here is the data https://drive.google.com/file/d/1_8JWxOrAdKEz1dxKITnqW3HZr1GTBgB9/view?usp=share_link

USE [Kazang]
GO

INSERT INTO [dbo].[daily_aggregated_view]
           ([primary_account_id]
           ,[Transaction_Date]
 ...

How do i post data when you guys don't want to get it from a link?

What defines the start and end dates of a transaction? Start of a new day would be the start date and end of day would be the end date.

            
February 23, 2023 at 12:44 pm
            
#4153258

            
            
                                                
        

@Ed B Have you looked at my data yet?

See bac file. https://drive.google.com/file/d/136YZirJHEzhPGomzRc4iLXSLU-w_KI-O/view?usp=share_link

• This reply was modified 1 year, 11 months ago by  yrstruly.

Please explain how do i retrieve that?

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[transaction_type](
[transaction_type] [nvarchar](255) NULL,
[transaction_code] [float] NULL
) ON [PRIMARY]
GO

---------
/****** Object:  Table [dbo].[Transactions]    Script Date: 2023/02/03 23:25:36 ******/
SET ANSI_NULLS ON
GO

SET...

Thank you.  I attached some sample data and a data model.

This is what i got:

Thank you @Ed B. Yes I am trying to create a slowly changing AccountGroup dimension table. I ran your code and it worked without any errors.

I am also creating a ...

• This reply was modified 1 year, 11 months ago by  yrstruly.