This is a variation of the above. I think your left joins are invalidated by the WHERE filter on the item table, so add the filter to the join or...

• This reply was modified 2 years, 7 months ago by Ed B. Reason: Join fix

Does the row count change when you remove the coalesce? I think the coalesce is there because dbo.PLNT_PARTACTWORKC is joined with an outer join. I suspect that removing the coalesce...

Trust me, I don’t use format specifically because of your previous...

I suspect that the sub queries used to get a random row for each name are performing a table scan. It seems that you identify a batch by updating the...

I suggest you provide sample data in the form table create and insert statements. I would simplify the tables to include only the relevant columns and make up the data....

I think you might have missed one of the requirements. It states there should be a snapshot for every account for every date even on dates an account has no...

Are you trying to make a slowly changing AccountGroup dimension table?

It might as simple as inserting the current data, then every day you expire changed rows and insert new rows....

Does this get you any closer?

Edit: the date column is already a date so no need to convert it.

SELECT  a.[DATE] AS TransactionDate,
    ...

• This reply was modified 2 years, 7 months ago by Ed B.

I got the following message

Msg 4108, Level 15, State 1, Line 284 Windowed functions can only appear in the SELECT or ORDER BY clauses

How can i re-set the ID...

If you don't want to write the data twice and you're using SSIS then you could multicast the dataflow to two destinations that are the same table. After the multicast...

Many new users would put the join filter criteria in the WHERE clause which would prevent the left joins from functioning as outer joins, so this is very good for...

Have you tried adding the package to an empty SSIS project and building any script tasks? If the package runs in debug then deploy to file system again.

What does the job activity monitor say? If it shows a status of idle I would delete the job history and check it again tomorrow.

If the job is not running...

Does the client need to hit refresh? I have been fooled many times.

From you required output it appears that you want the last row for each date, but this is based on the order they appear on the screen.

This will return one...