query Discussions

About 849 results - Page 1 of 85
  • Issue#601907: filter a table in a query based on a parameter and update remaning tables

    My database has company table containing mutltiple companies. It also has many other tables related to the company table.I want to make reports for a specific company and have created a parameter called company id. I filter out every row in the compnay table that is not equal to that parameter and that works great.My questions is this: Is there a way to remove rows in all other tables where the company does not exist anymore because it has been filtered out using my paramter. Or do I need to man...

  • Issue#655663: Giffgaff - Credit query

    Topped up account Monday with £10, phone used for texts and calls only and credit balance is £0. I've just put another £10 on. Please explain where my credit has gone...

  • Issue#433453: ASRock MB Query

     "Just installed the H110M-DGS/D3, only comes with onboard DVI, only works DVI to DVI, i..."...

  • Issue#514725: ERROR Reading Join Query parametricas

    Hola a todos,tengo este problema.He escrito con el DB Connection Toolkit una VI que lee una query parametrica access y restituye un Array 2D con el resultado de la query.El problema es:-Si los campos de la query vienen todo de la misma tabella de Access todo funciona perfectamente.-Si es una join query, con campos de diferentes tabelas relacionadas entre ellas de Access, en Labview me da este error, cuando empujo Run: Error -2147467259 occurred at NI_Database_API.lvlib:Cmd Execute.vi->Un...

  • Issue#579783: Use server tag for query string

    I am working on a project where clicking a button will open a client-side popup. In order to do this I am using the line of code below: var rtnVal = window.open("../../Pages/SubPages/AssignDelegate.aspx?admnid=" + <% GetId() %> , "popWindow"); The GetId() method is in my code behind and returns a string. I have done a lot of digging and tried many different versions of this, but I'm still unable to figure out how to get it to allow my server tag to add that string t...

  • Issue#199862: NetApp - Unified Manager 6.3 mySQL Query for Alerts

    So I am building a dashboard that runs queries against a couple sources. This includes DFM 5.x and UM 6.3. The table/view I'm working on right now is one that gets the existing alerts that have been sent out to our oncall analysts. The view would give them a single place to go, in order to click for more details on an alert that can't be given in a single text message. I have been able to generate the query using DFM's 5.x sybase database views, but not UM 6.3. My current method o...

  • Issue#374771: Dreamweaver - changing default J Query UI accordion settings

    I am using the accordion and by default it shows with the first panel open. Is there a setting I can change so that none of the panels are open? ...

  • Issue#121202: BODY SHOP QUERY

    I am buying a present for my older sister. She is into the whole organic and all natural'e products thing. So i did some research and Body Shop seems to be the most popular and trusted brand that fills this category. Do you guys have any suggestions on: -what products body shop is famous or good for? :s11: -what do you guys usually get for yourselves from Body Shop? -how are the customer service standards in Body Shop? -which Singapore outlet do you guys normally go to? -if anyone has ...

  • Issue#263249: PowerShell Query to get Security Group's name and email address?

    I was wondering if someone could help me with a task I've been assigned. We have several types of employees in my company, the biggest being FTE. I was tasked to get all full time employee's name and email address to be able to export it to a .txt document. I have a script to be able to get all AD users, but that list is too big. Can anyone help me with just getting a query for PowerShell that would just get me names and email addresses of users in a certain security group?  Thank you in advan...

  • Issue#1182837: user parameter in dynamic query

    Hello! I'm trying to pass the value of a parameter to my dynamic query statement so that I can limit the dataset on the source db (dealing with extremely large data). I tried the following... but it doesn't transfer the value of parameter StartDate to variable p_start_date.  How can I get the parameter value passed so I can use it in my dynamic query?  letp_start_date = fnGetParameter("StartDate"),Source = SapHana.Database("server",[Query="select ""VBAK"".""VBELN"", ""VB...

  • Issue#253230: Query with CTE gives error

    I used SQL Server and a query that uses a CTE.  It gives me an error "Incorrent syntax near the Keyword 'WITH'. ......."if this is a common table expression......previous statement must be terminated witha  semicolon." The query runs fine outside of Power BI.  I tried putting a semi-colon before the 'WITH', but that didn't work.   I see the data in the grid, but can't apply query changes and get the error ...

  • Issue#727308: Autodesk - Bifrost playblast query

    Hello, I'm very new to Bifrost, I'm wondering why the collider geo disappears when I playblast my simulation? Is there an option to keep it visible? Best, Tristan...

  • Issue#768552: SQL: Better to connect to raw table and apply steps or filter/join with query?

    We have an on-premise data source (SQL Server 2008 - I know its old...) housing our ERP data (Microsoft Dynamics AX 2009). We are currently using PowerBi to connect to this data using an import connection which is suitable for those current datasets/reports. I am now looking at building out standardised data sets for various finance related functions using Direct Query connections. I am trying to find the best way to set these data sets up. My options so far are: 1. Simply connect to t...

  • Issue#875892: New Phone WhatsApp Query

    -If you get a new phone, and use your existing sim (with the same number) in the new phone then no one will be able to access your old WhatsApps or media from the old phone? -If you get a new phone with a new sim with the same number as your old phone, then no one will be able to access your WhatsApps or media from the old phone? -If you get a new phone with a new sim and new number, but the old phone hasn't been used for 45 days, then all WhatsApp conversations and media will be deleted? Als...

  • Issue#951687: Need Help On Power Query Code

    Can somebody help me with the Power Query code by which I can update the value for Column Spend for against ProductTitle Diff whose formula is Base = 1 – SUM(Spend). Data may increase and pattern is shown below. The source is SharePoint list. I will have to show this data on Donut chart in Power BI. Spend   ReportDate    ProductTitle                  Spend    &...

  • Issue#1002842: Moneygram/US Paypal Query

    Hi There, I am a user of Paypal Australia and I am in the process of finalising a sale through Gumtree. The purchaser has advised that I need to send a fee to Moneygram for a shipping fee and until I complete this the payment will not process even though it has left her account (but not yet in mine). I have called Paypal and they stated they wouldnt advise someone to pay fees to a Western Union or other. Not sure if US Paypal have different procedures though. Can someone please advise wheth...

  • Issue#54888: Photoshop Elements - Elements Ctalogue Query

    I have installed elements 14.  Should I uninstall Elements 12.  If I don't dos that mean I am cluttering up my PC with two Catalogues?  And where does elements save the catalogue to?  Any help much appreciated....

  • Issue#1045886: Chicagoland Power BI User Group: On-premises data gateway, Direct Query, Security

    On-premises data gateway acts as a bridge, providing quick and secure data transfer between on-premises data (data that is not in the cloud) and the Power BI.We are going to talk about the benefits of installing the on-premises gateway, direct query and scheduled refresh options available....

  • Issue#1079157: Direct Query and Query Parameters

    Hi guys, As far as I can see usage of Query Parameters in DirectQuery mode is not well supported and please let me know if I'm wrong about it. I'm trying to create report with Azure SQL Database as data source in DirectQuery mode where I would like to apply row filtering based on the value of my parameter. What I'm trying to do is to dynamically change parameter and get different result based on the parameter value? Right now Power BI Desktop is telling me that this approcah will ...

  • Issue#1118392: Using DAX in Query Editor

    In Query Editor you are able to create a custom column. But I was not able to code with DAX in the Query Editor. Is it not possible?I need to create a custom column in the Query Editor, which gets a value according to the value of another column and the current date. And I need to do that in the Query Editor, because I want to unpivot the new column after that.How can code DAX in Query Editor?...

  • Issue#640792: DATEDIFF_BIG Azure DW Direct Query

    Hi,I have used DATEDIFF and I think it is getting translated to DATEDIFF_BIG on backend and there it is giving error that function is not recognised.As per online docs function is available in SQL Azure DW so not sure why the error. It is a direct query connection to SQL Azure DW. Thanks,Dilkush...

  • Issue#716618: Query Parameter Testing

    I am testing query parameters.  I have a Web URL that is constructed of 4 parameters.  Two of the parameters contain multiple values that I want to iterate over using the same base URL parameters. Any thoughts on how I would iterate through the values of the 'Season' and the 'Page' parameters and create a table that was appended for all values where the parameters changed? Here is the script:let Source = Web.Page(Web.Contents(BaseURL & Season & MidURL & Page &...

  • Issue#387593: Retrieve query point coordonate to create a plane passing through this point.

    Hi everyone, I am creating a script in shell to modify a command journal from ensight. The goal is simple, i have created "bricks" of Ensight ' journals that i modify in order to change its display. example __________________________ ADD_CASE case: create_viewport ON case: apply_context OFF case: reflect_model_in 'none' # "case: add Case X" flag__casenum #"case: select Case X" flag__caseselect part: select_default part: modify_begin part: elt_representati...

  • Issue#463514: Autodesk - Query Civil 3D Objects?

    Hi, Map 3D & C3D 2016 on Win7 machine. Is it possible to query the data from Civil 3D objects using Map? I'm primarily interested in extracting the data from pipe networks so that each object can be added to our GIS as seamlessly as possible. If a query won'r do it, are there other methods of doing this? I don't care if the objects relate to each other anymore. I simply want each one treated as a point or line feature with attributes defined by the Civil 3D data - so that a GI...

  • Issue#526559: Dell - MD3460 SMART DATA Query - Critical Error

    Desc=Drive error during SMART data query - Unknown error (5h/24h/0h): (adapter=Dell 12Gbps HBA, adapterWwn=Dell 12Gbps HBA, Drive Target Port Wwn=500a0986359ef010)....