query Discussions

About 849 results - Page 1 of 85
  • Issue#66739: Linq query not working as expected.

    Hello All, I have three tables in my database ,  1.Horse 2.Show 3.ShowHorses Horse contains horse details and show contains show details. currently i am having data into the horse table and show table. there is a relationship between showid and horseid maintained into the showhorses table. currently there is no data into the showhorses table. i am trying below query in sql server to get the records using left join. also i have tried the same query using linq but still the same trouble. sho...

  • 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#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#304697: Giffgaff - I think I've been overcharged for an international call how do I query this?

    International call charges...

  • 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#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#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#143: Sony - Faulty A6000 and lens software update query

    My 7 month old A6000 using the original SELP1650 and later purchased SEL55210 has developed a problem. Using the auto modes everything works correctly, but useing A,S or P modes has suddenly produced heavy vignetting and erratic, often under exposure. It would appear to be faulty. I decided to see how updated my lens software was in case an update might cure the problem. The lens status is:- SELP1650 Body V2.00 Lens V.01SEL55210 Body V2.00 Lens V.02 Refering to "ILCE-6000 Support ...

  • 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#754789: How to use Query Time Join with Lucene 5.3.0?

    I am referring this link for usage of query time join and I am able to use following method createJoinQuery(String fromField, boolean multipleValuesPerDocument, String toField, Query fromQuery, IndexSearcher fromSearcher, ScoreMode scoreMode) Parameters: fromField - The from field to join from multipleValuesPerDocument - Whether the from field has multiple terms per document toField - The to field to join to fromQuery - The query to match documents on the from side fromSearcher - ...

  • Issue#819643: Incorrect syntax in Power BI - but query works fine in SSMS?

    Hi,I'm getting this error when trying to use a direct query ï»¿But when I run my proc in SSMS it is just fine - I can't figure out why POwer BI doesn't like it. Here's the statement I am trying to use: DECLARE @CLAIMS int DECLARE @from_date_entered date DECLARE @to_date_entered date ---------------------------- SET @from_date_entered = GETDATE() SET @to_date_entered = GETDATE() --SET @from_date_entered = N'03/16/2016' --SET @to_date_entered = N'03/16/2016' ---------------------...

  • 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#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#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#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#147199: Copy a Query from one PowerBI file to another

    Does anyone know how (if it is possible) to copy a query from one PowerBI file to another. I have a query that pulls data from CRM (Account Set) that I have customized (i.e. modified values, data types, calculated columns, etc.) that I would like to copy into a different powerBI file instead of having to redo the same query.  ...

  • Issue#215957: SAN Health related query

    Hi,I am collecting SAN health report from Broacde SAN switches in that one of the fabric has total 9 switches but while adding in to the switch in the Set file, SAN health tool is gathering only 8 switches  not the 9th one, but in switches with the "fabricshow" command it is shows all 9 switches, please help me why it is happening like this and which is not founded 9th switch if iam adding in the set file it is showing separate fabric  ...

  • 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#325799: Tableau - Is there a way to avoid Tableau from including unnecessary fields from query (Live Conn. S

    Hi, This is my first question - but I would like to thank everyone contributing to this forum for all their work which has helped me a lot! I am working on a live connection to our data warehouser DB, which is SQL Server 2012. I have a simple viz (bar chart) and a parameter control where I can select one of tre different measures I want to display in the viz. The measure-field in the viz is calculated by a formula:     case ParamMeasure    &...