First, note that your CASE expressions do not filter any data out. To do that requires a WHERE clause.

Let's be more specific and focus on DailycheckHome, for example.

First of all,...

Thanks, Phil for kind words. In my query I have been trying to filter following options but I know the query does not filter when I use a.TRNyear=2022 or...

I have created a query but not filtering properly. for example and I like to show it on the report where I have struggles it so far.

What is your question?...

Those are not INTs!! Change the target datatype to DECIMAL and you should have more success.

CSV files are not Excel files. Open it in Notepad to see the unadulterated data.

Apologies for checking the...

My mistake. Try these:

declare @id numeric(19,6) = '123.456'

select @id, up = ROUND(@id,2,0), down = ROUND(@id,2,1)

Change your precision to make the query work as you intend:

declare @id numeric(19,6) = '123.456'

select @id, ROUND(@id,2)

apologies ,cut and paste error , example value 2859 i.e theyre all 4 digit numbers.

Would that be quicker do you think even with having to recreate the nonclustered (&...

As you are presenting the data grouped only by LOC, what function do you think joining on those other columns performs?

Another option: copy the rows you wish to keep to a copy of the current table, then swap that table with the current one.

Also, how did you get J22 into...

• This reply was modified 3 years, 10 months ago by Phil Parkin.

Sorry, how do I go about Jeff's method of using BULK INSERT. Is it an SQL query ?

I was playing around with the ForEach loop container to try and...

Thanks Jeff

I haven't heard of ACE driver. Is it a tool ? if so, can you share a link please. I am not sure how to use bulk insert...

Here is another version – obviously untested, but does not rely on a JOIN:

WITH Totals
AS (SELECT LOC
          ,Tab...

• This reply was modified 3 years, 10 months ago by Phil Parkin.

Before I attempt to explain, can you try running this version please?

WITH ACTUALS
AS (SELECT LOC
          ,Actuals = SUM(HistoryQuantity)
...