You could use something like this.. I would recommend commenting out the EXEC statement and just printing the SQL to make sure the SQL statement is correct.

USE [mydatabase]; ...

You're not specifying a way of telling which records are already in the destination table. Without that, you're going to insert the same records over and over.maybe you could use...

For Each [file] Loop?

How are you going through the table?

You could use a TOP VALUES query...

SELECT TOP 5 *

FROM dbo.MyTable

WHERE ...

Where are you sending the records? I guess you could use OFFSET....

Okay, thanks... That's a great design! Not sure who thought of that, but just wow.

Here's a screenshot. Note the lack of individual tables in the field list on the right.

Every other time, the tables are broken out and then the columns are under...

If it's clinical trials data, that's all covered under HIPPA/PHI rules.

Having Access involved is a security disaster waiting to happen. It has no built-in security anymore. If at all possible,...

You can lead a horse to water....

Isn't that kind of presumptuous? Send me your paycheck, and then I'll do your job.

If you are only trying to compare email1, then this will return all email addresses being used by more than one employee...

SELECT email1

FROM #temp1

GROUP BY email1

HAVING COUNT(*)>1;

If you need to...

So what did you try?

I don't have an Oracle instance to connect to, but when you run the wizard to add a Data Source, you can choose "Oracle Database" from...

A quick search turned up a ton of information...

Oracle Connection Type (SSRS)

Data Sources supported by SSRS

How to add an Oracle data source in SSRS

Did you, by chance, drop a Matrix into your report design surface instead of a Tablix? Try them side by side to see the difference.

You don't do anything different. The combination of the partition scheme and function determine the partition the record will be written to. SQL Server handles all that for you....

It appears that Steve Jones (the guy that runs this show... I mean website) wrote several articles about tSQLt. This is the first one[/url]. Try reading some of...

I think the one migration/upsizing path that is not available is from PowerBI Desktop to SSAS.... so of course, that's what I did. Just seems strange that you can...