Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. RRinTetons

    Excel pivot table refresh says Invalid Pivot Table report

    Excel from current Office 365. No Power BI tools in use. Data not added to Data Model. I’ll take a look at the link you suggested. - Richard Ray Developer, Data Analyst Jackson Hole, WY
  2. RRinTetons

    Excel pivot table refresh says Invalid Pivot Table report

    I created an Excel workbook that queries a SQL Server database that returns around 500,000 to 600,000 rows. He then refreshes a Pivot Table references query data. You can successfully refresh the Pivot Table immediately after the refresh. When he saves the workbook and reopens it, though...
  3. RRinTetons

    SQL Server 2008 R2 login auditing

    I have a client running a database on SQL Server 2008 R2 Standard. They are very concerned about processing power on the server box, and want to set up long-term auditing of logins. What is the lightest impact method to do that? Can a trace or Profiler session be set up from another server? Does...
  4. RRinTetons

    Structured Table References in COUNTIFS

    PROBLEM SOLUTION Interesting discussions re INDIRECT. To recap my original problem, I had an #VALUE error when attempting to replace cell references with Structured Table References (STR's) in COUNTIFS & SUMIFS. As would be expected, the problem is nothing to do with either STR's or the...
  5. RRinTetons

    Structured Table References in COUNTIFS

    My apologies, my forum posts are done via Dragon Naturally Speaking. I missed editing the COUNTIFS example to include the underscore in the name. As my keyboard skills are pretty badly deteriorated< I certainly use Intellisense, as well as other syntax helpers, when writing code or entering...
  6. RRinTetons

    Structured Table References in COUNTIFS

    Can a Structured Table Reference (STR) be used in place of cell references in COUNTIFS formulas? I've got a coworker's workbook that takes several minutes to recalc and is taking up over a gb of disk. He's got hundreds of COUNTIFS in cells with multiple references that extend to row 1,048,576...
  7. RRinTetons

    MS Quefy syntax for calling SP with parameters.

    To answer my own question: MS Query as present in Excel 2010 and 2013 doesn't recognize named parameters. In my case, the client's proc accepts up to 12 arguments, only two of which are of interest in this application. As I couldn't use named parameters to pick out the ones I needed in Excel, I...
  8. RRinTetons

    Tool for job scheduling

    I'm looking for a tool to recommend to a client to help him visualize job schedules in SQL Server 2008 and 2012. He's got a LOT of overnight jobs that need to run in order to do closes, posting, ETL, backups, optimization, etc. He wants to be able to see what's scheduled when, and where he might...
  9. RRinTetons

    MS Query SQL Syntax

    Re PowerQuery —- Agree, 100%. Unfortunately, this client has an aversion to Microsoft PowerBI tools, so,I’m stuck with MS Query... I’ve made it work in the past, and recall the syntax being a bit arcane, so I’ll persevere. - Richard Ray Developer, Data Analyst Jackson Hole, WY
  10. RRinTetons

    MS Quefy syntax for calling SP with parameters.

    I tried this over the Office list figuring that MS Query was more an Eccel thing, but was directed over here, so... RRinTetons (IS/IT--Management)(OP)20 Dec 19 01:59 This query works fine in SSMS: EXECUTE [dbo].[myProc] @BeginTransactionDate = '2019-12-01 22:52:00',@EndTransactionDate =...
  11. RRinTetons

    MS Query SQL Syntax

    I don’t know, I figured that more people working with Excel would be likely to have used MS Query than would folks primarily working with SQL query syntax. As I indicated, the *SQL* part is fine, it’s calling it in MS Query to get the days into Excel that causes problems. Where would *you*...
  12. RRinTetons

    MS Query SQL Syntax

    This query works fine in SSMS: EXECUTE [dbo].[myProc] @BeginTransactionDate = '2019-12-01 22:52:00',@EndTransactionDate = '2019-12-5 22:52:00' When I change it to work as a stored procedure call in MS Query to move data into an Excel workbook I *thought it should look like: {CALL...
  13. RRinTetons

    Sleuthing out job failure

    Yes, I have a dev environment, isolated on its own server, and machines from which to test, even. Can you suggest ways to get a client to replicate both Windows and SQL Server security across those machines such that they mirror the production environment, perfectly? I can do it on a network...
  14. RRinTetons

    Sleuthing out job failure

    At least it seems like a failure to me. I have a backup job that includes three COPY TO commands to move most recent backups to other servers for archive and isolated processing needs. Two of the statements work perfectly wel, third one doesn't seem to work at all, but doesn't throw an error...
  15. RRinTetons

    Logging into a database using SSMS from non-domain machine

    I have a client who, quite properly,has all SQL Server do’s set to Windows Authentication. I have a VPN connection, I can see the database server. I even have a Windiescaccountinntheirsystem. However being on a non-domain computer gives me no obvious (obvious to me, anyway) way to authenticate...
  16. RRinTetons

    Anybody integrating with ASP via the Workforce API's?

    So you're saying I should build a .NET application that does the data collection? - Richard Ray DBA, Developer, Data Analyst Jackson Hole Mountain Resort
  17. RRinTetons

    Anybody integrating with ASP via the Workforce API's?

    I have an existing database application that accesses HR data from ADP's hosted HR system and maintains employee data and access in our enterprise operations system. I get the data from a local SQL Server db that's updated from ADP by a middleware product called LinkSync. The new version of ADP...
  18. RRinTetons

    Multiple columns with Report Builder 3.0

    SQL Server 2008 R2, Report Builder 3.0 I want to create a report that shows two columns of data in multiple sets of columns across the page. I don't see a way to make a nice neat table to illustrate, so I'll use dots to line things up, Jones, Tom.............HR Miller...
  19. RRinTetons

    Update data in specific tables in specific columns in database

    Dear Olaf, After 35 years working with databases I'm pretty familiar with normalization. If this were a database I had designed I promise you it wouldn't have this problem, but it's not. I'm trying to complete a task assigned to me, as it was assigned, in the world in which it was assigned. I...
  20. RRinTetons

    Update data in specific tables in specific columns in database

    Is this job for the MERGE statement? I've never really used it much, but maybe? - Richard Ray DBA, Developer, Data Analyst Jackson Hole Mountain Resort

Part and Inventory Search

Back
Top