mssql

  1. M

    Converting MSSQL CTE query to access?

    I had this query formulated that was based off of a query through MSSQL and has CTE expressions which are not compatible with access I guess? I am a noob with Access and SQL. Is there a way to recreate this query but with compatibility with Access? WITH CTE as ( SELECT SHIPMENT_XID,Original...
  2. D

    Auto Update Pivot Table

    Hey guys, I have built a dashboard in excel using a couple MSSQL queries and then I filter the data in a pivot table. The only problem I have is that the data in the pivot is not updating unless I refresh. I am populating a few sheets in a table and have set them to auto refresh every 3...
  3. D

    Add SQL Query To Ribbon.

    Hi Guys, I work a lot in sql and certain queries I run many times per day. I would like to add these queiries to the ribbon so I can run them on the push of a button. Ideally I would like it to create a new sheet for each query. For example if sheet 1 is what Im working on, when I click the...
  4. C

    [VBA] Average number of days between dates for multiple entries in PivotCache

    Hi everybody, my current task is to evaluate data from a MSSQL-DB. This is done by creating a pivot cache, from which pivot charts are generated. This works fine ;) Every DB-entry has a field with a start date and a field with a end-date. My task is to get the number of days between those two...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top