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,470)
    • Functional (119)
    • General (116)
    • Technical (48)
    • Tips & tricks (5,291)
  • ERP general (347)
  • Information management (58)
  • Off-topic (51)
  • Projectmanagement (450)
  • Quote of the week (29)
  • Visual C# / ASP.net (57)

Common Table Expressions in MS SQL Server

By admin in Dynamics NAV & BC, Tips & tricks 23 October 2011 0 Comment

CTE’s or Common Table Expressions is a feature that is available since MS SQL Server 2005.
It’s a kind of temporary view or to translate it in NAV lingo, temporary tables. CTE’s only exist
in the query where they are declared and can be used as it was a regular table.

Bron : Something, something, something C/Side
Lees meer…

Share this:

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

Like this:

Like Loading...

Gerelateerde artikelen:

  1. Temporary table in NAV
  2. Creating Filtered Views in NAV 2009 RTC
  3. Export NAV license from SQL Server
  4. How to schedule and automate backups of SQL Server databases in SQL Server Express
  5. Regular Expressions in NAV
Tags ServerSQL
Symbols in SQL Reporting Services
How do you search for a field in Dynamics NAV Table Designer?

Related Articles.

Dynamics 365 Business Central: Get the amount of SQL rows read and the amount of SQL statements executed on the session via AL – SessionInformation Data Type

01 Mar, 2023

SQL – Search for special characters

04 Oct, 2022

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

25 Aug, 2022

Export SQL data to CSV or XML File via Powershell

03 May, 2022

AL is not SQL (and Business Central is not a “SQL Application”)

17 Dec, 2021

Leave a Comment.

You must be logged in to post a comment.

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 take backup of specific system table before the Deletion of records from a specific table?
  • Show each month on Account schedule and YTD
  • BC2022 hide specific page for a profil
  • BC 18 Edit in Excel Invalid server configuration
  • Allocation costs in BC
  • CurrPage.EDITABLE together with CurrPage.UPDATE
  • Design Mode in BC Cloud Sandboxes
  • Financials in BC
  • Copy newly created temp file
  • NAV webclient: Force auth by parameter
  • Auto Attached "Document Attachment" upon Send Email
  • Business Central Copy Link Option in Share Menu on Pages
  • [color=#FF0000][Inappropriate/Offensive text removed by Moderator.][/color]
  • How to import sales orders from excel in navision?
  • You do not have the following permissions on TableData Vendor Ledger Entry: Modify
  • Importing Items from Excel - Include Extended Text?
  • BC 21 import multiple xmlport with dynamic filesnames
  • Copy User field from posted purchase invoice line(123) to G/L Entry(17) table
  • Microsoft.Dynamics.Nav.Runtime.NavVariant variable not initialized
  • Can I take backup of user personalization?

RSS Dynamics NAV Team Blog

  • Dynamics 365 Field Service Mobile: New multi-image attachment feature and tips to get the most out of Inspections
  • Account structure activation performance enhancement 
  • Split recurring contract billing across multiple customers 
  • Status-Driven Success: Managing Your Work Order Lifecycle through Statuses – Part 1  
  • Status-Driven Success: Managing Your Work Order Lifecycle through Statuses – Part 2  
  • Status-Driven Success: Managing Your Work Order Lifecycle through Statuses – Part 3  
  • Printing Labels Using External Service with Dynamics 365 – Warehouse Management
  • How Copilot in Microsoft Dynamics 365 and Power Platform delivers enterprise-ready AI built for security and privacy
  • How real-time analytics improve supervisor experiences in Customer Service
  • Boost your sales business with smart organization charts

RSS Power BI

  • REMINDER: Announcing the retirement of data support for Streaming Dataflows
  • Power BI Embedded with Microsoft Fabric
  • Power BI Report Server May 2023 Feature Summary
  • Learn about Microsoft Fabric from MVPs
  • On-premises data gateway May 2023 release
  • Power BI May 2023 Feature Summary
  • Power BI Administrator role will be renamed to Fabric Administrator
  • New Tenant Setting Notifications and GetTenantSettings API
  • Microsoft Fabric Launch Event | May 24-25
  • Introducing Microsoft Fabric and Copilot in Microsoft Power BI
Proudly powered by WordPress. Theme: DW Minion by DesignWall.
%d bloggers like this: