I would like to select the latest date. I tried this:

I had to implement some changes

"Create daily aggregated table or data view along with procedure that tracts the opening and closing

balances of accounts along with debited and credited...

Sorry. I misread the code. I tried it and it works. Please tell me, the code @kaj shared with me also works. Does both of these codes give...

Thank you for the assistance. Do you mean it must be part of the Group By statement/columns, like below(but a new error appears)?

"Msg 2714, Level 16, State 3, Procedure daily_aggregated_view,...

I re-wrote the SQL to join transactions and transaction type, I am getting this error:

CREATE VIEW daily_aggregated_view AS
SELECT 
    primary_account_id,
    Transaction_Date,
...

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

I'm still not getting anywhere even when I changed the columns.

It is all tied to this question(https://www.sqlservercentral.com/forums/topic/view-or-stored-procedure-3)

I have also rreated sql table(s) that would allow analysts to track...

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

Yes.

Transection_type.transaction_code joins on Transactions.primary_type.

DDL of Transactions table and ransactions_type below. I tried changing the column name.

/****** Object:  Table [dbo].[Transactions]    Script Date: 2023/01/31 22:10:46 ******/SET ANSI_NULLS ON
GO

SET...

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

Thanks for the assistance. I tried both and nothing yet:

I would like a  Daily aggregated table or data view that tracts the opening and closing balances of accounts

along with debited and credited amounts. The data view needs to be...

@jeffwilliams "It looks like you put a DISTINCT on every single statement - which either means a bad join or bad design." What will you recommend here or how would...

@JeffreyWilliams Thank you for your input. Would you say, definning primary keys for each row would be the quickest way to ensure uniqueness or no duplicate values being imported?

I agree...

Please give me completed code.

Still getting an error.

-- SQLINES LICENSE FOR EVALUATION USE ONLY
SELECT  CONVERT(DATE, o.created_datetime) as [Date], 
        od.product_uid as 'Product UID',
...