3 Replies Latest reply: Oct 28, 2013 3:41 PM by Israr Khan RSS

    Creating Synthetic Index from two SQL table columns. . .

      I need to create a synthetic key by just joining two key columns of data into one to join to a second table with identical dual key fields.

      But i don't need a cartesian product of all strProject + System. . .

       

      This doesn't appear to work. .  There must be a trick to the SQL pass through to the SQLServer 2012 db. . .

      Without creating a new SQLSERVER download table. . .

       

      LOAD "Book_Period",

          strDistrict,

          strProject,

          Concat([strProject],[System]) as "ProjectID",

          System,

          Sequ_Nbr,

          Product,

          BookDate,

          Face_Price,

          Est_Material,

          Est_Labor,

          Est_Subcontractor,

          Est_Sundry,

          Est_Cost,

          Est_Margin;

      SQL SELECT *

      FROM "FPA_Admin".dbo.BOOKINGS

      WHERE Book_Period > 201200 AND Sequ_Nbr=0;

       

      tired from fighting crappy system reports from systems with other programmers. . .

       

      thanks in advance.