general rule of thumb with aggregates / GROUP BY.

Columns in the SELECT clause must be either aggregates (Sum, Min, Max, Avg...etc) OR they must be in the GROUP...

SSIS package to get the file (download), then import the text file. Then schedule it using a job?

If you added the calculated field to your dataset, then you can use it just like a normal field (as it if were in the original dataset). If not, I...

How long is a piece of string?
Is this a one-off or do you need to import different files with the same structure?
If it's a one-off you can use...

I'm using SSRS 2016, but I'm pretty sure this is still the same.
Open your report, and switch to design mode.
Then go under the Report menu to Then...

I'm turning into Joe Celko... time for a break.
Please help us to help you and read this article. 

June 6, 2017 at 12:41 pm

#1945679

Why not just the table stuff you posted?  Simple create table script, maybe a dozen inserts. Done.

Can't run a SQL statement against a picture.  If you want help, provide consumable data.

I meant that...
1. Don't use that diabolical stored procedure to do something this simple. You just don't need anything near that complex. (with lots of NO LOCK / READ...

Use an IF statement to determine if the value is 'Choice_Added', and overwrite the RowNumber value.  Then filter on the very outside to eliminate the values you don't want.

Do you have a database diagram for this part of the database?  It's hard to tell from the temporary tables how things are related, because there are so many foreign...

Creating datasets is trivial. You have a connection (DataSource), and then you build a DataSet by executing a stored procedure against that DataSource and it returns your dataset. Then you...

This appears to work for the data provided:
SELECT *
FROM test_table2 t2
WHERE t2.ID NOT IN (SELECT ID FROM test_table1)
AND t2.condition = 'Used';