Hi everyone

One of my queries is running too slow so I would like to output the results of the subquery into a table and then use that table in...

Data factory has a for each loop.

This may be a start.  https://debbiesmspowerbiazureblog.home.blog/category/azure/azure-data-factory-azure/azure-data-factory-for-each-loop/

Why are you trying to read a spreadsheet?  Can you execute a query against the source of the...

Your data types are wrong.

In your query, you are ordering by  DateInsertion. Since this is stored as characters, and not a date, your sort is not going to return in...

Can you publish the code?

I am not seeing a Power BI forum on this group. Is there one and I'm just missing it?

One of our Devs has a question. He's trying to get...

What's the chance of you making the reporting login sysadmin for long enough to run and test the query?

It it runs fast, then the mystery deepens.

If if runs in the...

Considering that this a a site dedicated to Microsoft SQL Server, I do not think you are going to find a lot of resources related to MySql.

These are MySQL forums...

Hi

firstly im sorry if this is in the wrong place, i couldnt find a ssis forum.

I have been working with a mariadb, trying to get the data into sql...

Thanks a lot Phil, Michael and Bran for your incredible help and guidance. You guys have very well understood all my concerns and provided me exactly what I needed.

@Phil...

The simple answer is that EXISTS is usually a better query plan. As I understand it, EXISTS stops when the...

Thanks guys.  I also thought the Bank filter may be unnecessary.  I tried removing it and got one more record than with it, I'll look into that.  It ran...

That's your issue.  It will not work

Is the version of Access 32, or...

The actual error would be much better. WHAT ODBC error?  What SPECIFICALLY did it say?

How about a screen shot???

• This reply was modified 3 years, 10 months ago by Michael L John.

When I consider how much time I used to spend configuring and testing disk performance, vs. how little I do now, one would think I have a lot more free...