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...

Will do. I guess I'm still a serious noob when it comes to DAX... just getting my head around the way it works is hard!!!

I was thinking I should just...

Bummer. That's what I was afraid of.

What do you do if the model is missing a measure or two and maybe some useful calculated columns? Call the developer, because...

Looks like this should do it...

http://stackoverflow.com/questions/11301383/automatically-drop-and-recreate-current-indexes

EXEC sp_MSforEachTable 'ALTER INDEX ALL ON ? DISABLE'

and

EXEC sp_MSforEachTable 'ALTER INDEX ALL ON ? REBUILD'

is all you need if you want to do it for...