Pardaan.com

If your work becomes your passion…

If your work becomes your passion…

Menu

  • Profile
  • Tags

Categories

  • Data & Analysis (248)
  • Dynamics NAV & BC (5,564)
    • Functional (119)
    • General (116)
    • Technical (48)
    • Tips & tricks (5,385)
  • ERP general (347)
  • Information management (58)
  • Off-topic (51)
  • Projectmanagement (450)
  • Quote of the week (29)
  • Visual C# / ASP.net (57)

How Do I Perform a Select Distinct with Queries

By admin in Dynamics NAV & BC, Tips & tricks 13 May 2016

This video demonstrates how to perform a select distinct with queries in Microsoft Dynamics NAV. The demonstration covers the following steps: What is a Select Distinct?

Bron : Think about IT
Lees meer…

Share this:

  • Facebook
  • LinkedIn
  • WhatsApp
  • Twitter
  • Email
  • Print

Like this:

Like Loading...

Gerelateerde artikelen:

  1. Application Design Pattern: SELECT DISTINCT with Queries
  2. TIP #35 | Using Queries in Pages & Reports
  3. Putting Queries to Use in Business Central
  4. Designing charts & queries
  5. How to Perform Bank Reconciliations in Microsoft Dynamics NAV 2015
Tags DistinctQuerySelect
NAV performance part 4: SQL Azure
Creating a Wizard with Workflows 1/2

Related Articles.

Can I query half a record in AL?

12 Oct, 2022

How to use the Query object as an API in Business Central

06 Oct, 2022

Use a Query Object if you have an urge for SQL in Business Central

25 Aug, 2022

D365 Business Central : Using Query to Get Distinct Values

10 Aug, 2022

Query Object: How Does It Work In Business Central?

12 Jul, 2022
Pardaan.com

Microsoft Dynamics NAV, Business Central, ERP general, Projectmanagement, Information management and Visual C#


Dennis Pardaan

Facebook page

Facebook page

Stay Hungry, Stay Foolish

RSS Mibuso

  • How to become a member of AppSource/MarketPlace
  • cannot have any leading or trailing spaces
  • Objects not shown after update license file
  • This is a real head scratcher! - Server killing sessions
  • Dynamics.IS JSON Mgt codeunit question (generating well formed JSON string)
  • Business Central OnPrem – Not refresh Total Balance in pages
  • How do I translate from Danish using xlf files in Business Central cloud?
  • Reversal transaction G/L Entry No. and Vendor Ledger Entry No. are not the same
  • DotNet .... is missing (BC22)
  • NAV 2018 - Job No. must be equal to '' in G/L Entry when reversing a G/L register
  • Action after salesOrder API Post
  • LS Retail Z-Report Wrong Amount
  • How can prepayment amount to be deducted be manipulated?
  • Account Schedule AllowScheduling = false
  • Restoring Company to an Exiting Business Central Environment
  • BC365 Disable Print Icon on Report Viewer
  • RDLC - Dynamically increase the width of a table when a column is hidden?
  • test soap web service - web access key no longer on the user card
  • Syntax for using DotNet Library NAV2016
  • Flowfield to see the birthday is this week?

RSS Dynamics NAV Team Blog

  • Announcing Unified Trial and Developer Environments for Dynamics 365 Finance and Operations apps 
  • Leverage Warehouse management only mode to optimize your business 
  • Adding Regional Formats to Reports in Business Central
  • Microsoft is named a Leader in 2023 Gartner® Magic Quadrant™ for Sales Force Automation Platforms
  • Extend your Dynamics 365 skills at the second Power Platform Conference this October in Las Vegas
  • Streamline your sales workflow: How AI-powered Opportunity summaries transform collaboration
  • From Microsoft to global brands, Dynamics 365 Copilot is helping transform customer experiences across service, sales, and marketing
  • 4 benefits of modern warehouse management solutions
  • IDC shares how generative AI transforms business processes within marketing, sales, and service 
  • Now generally available: The new Microsoft Dynamics 365 Customer Insights

RSS Power BI

  • On-premises data gateway September 2023 release
  • Power BI September 2023 Feature Summary
  • Supporting Azure Active Directory shared device mode (preview) for Power BI Mobile apps
  • Dataset Refresh History Enhancements
  • Announcing calculation groups for Direct Lake datasets
  • Heads up: Power BI OneDrive and SharePoint report viewing will be on by default starting in October
  • Streamlining cloud connection management for datasets, paginated reports, and other artifacts
  • Best Practices to prevent GetGroupsAsAdmin API timeout
  • Heads up: Changes to Excel workbook support in Power BI workspaces
  • On-premises data gateway August 2023 release
Proudly powered by WordPress. Theme: DW Minion by DesignWall.
%d bloggers like this: