SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
Select     trim(STR(a.[Supplemental_Data_Numeric_Key_1], 25, 0)) + ' - ' + trim(STR(a.[Address_Number], 25, 0)) + ' - ' + trim(cast(a.SiteId as varchar(10))) as SupplementalDataACTSkey     ,trim(STR(a.[Address_Number], 25, 0)  + ' - ' + trim(cast(a.SiteId as varchar(10)))) as ArtisansSkey     ,a.[siteId],     a.date_updated,a.Date_Additional,     trim(STR(a.[Supplemental_Data_Numeric_Key_1], 25, 0))+ ' - ' + trim(cast(a.SiteId as varchar(10))) as OrderMasterSkey,      isnull(b.Run_Labor_Standard/100,sum(a.Amount_User_Defined1)/100) as [Estimated Hours],     sum(a.Amount_User_Defined1)/100 As [Actual Hours]     ,b.[Sequence_Number_Operations]     FROM [mdw].[SupplementalData] a     full outer join [mdw].[WorkOrderRouting] b on         a.[Supplemental_Data_Numeric_Key_1] = b.[Document_Order_No_Invoice_etc.]            and a.[Address_Number] = b.[Address_Number]           and a.Siteid = b.Site           Group by      trim(STR(a.[Supplemental_Data_Numeric_Key_1], 25, 0)) + ' - ' + trim(STR(a.[Address_Number], 25, 0)) + ' - ' + trim(cast(a.SiteId as varchar(10)))      ,trim(STR(a.[Address_Number], 25, 0)  + ' - ' + trim(cast(a.SiteId as varchar(10)))) ,[Supplemental_Data_Numeric_Key_1],b.Run_Labor_Standard     ,a.[siteId],a.date_updated,a.Date_Additional,b.[Sequence_Number_Operations]     having [Supplemental_Data_Numeric_Key_1] in (2628173)
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear