Browse By Tags

  • Web Services, Where Clauses and Subqueries

    This article follows on from a previous article " Using Joins in Web Services ". That article discussed how views that are linked into CRM and described as 'tables' in metadata can be used to provide access to data from multiple tables within a single…

  • SQL - Produced Vs Manufactured in KG's (w/ a subquery) - how to group subquery by product?

    Hi , I have a query , which is desired to return the KG's produced and sold (just based on finished goods). What I have is the following: -- SELECT ISNULL(I.ITMREF_0,'[Total-Produced]') as 'Product', P.ITMDES1_0 as 'Desc', H.STU_0, SUM(P.ITMWEI_0…

*Community Hub is the new name for Sage City