Skip to main content
10000+ Posts
SQL Executor issues a warning for a valid statement

Using Form/Workbench 2022.2, connecting to MSSQL 15 with 10.9 SDE over the top. I'm not an SQL expert, and this statement was a combination of my knowledge, ChatGPT and colleagues knowledgeSELECT    p.*,    -- Calculate the rate of nitrogen (N) application over the entire spread.    -- Convert the area to hectares, then multiply by the rate to get the total weight.    -- Finally, divide by the applied area to obtain the average rate.    SUM(p.Shape.STArea()  / 10000 * p.NutrientN / p.AppliedAreaInHa) OVER () AS  total_n_rate,     -- Calculate the total fertilizer rate over the entire spread.    -- Convert the area to hectares, then multiply by the rate to get the total weight.    -- Finally, divide by the applied area to obtain the average rate.    SUM(p.Shape.STArea()  / 10000 * p.RateKgPerHa / p.AppliedAreaInHa) OVER () AS total_fert_rateFROM    [Agtech].[MASTER].[ProofOfPlacementS

Badge Winners

  • FME Form Advanced Training
    hanhhhas earned the badge FME Form Advanced Training
  • Welcome Back
    stefanpricehas earned the badge Welcome Back
  • FME Flow Authoring Training
    jimc_denverhas earned the badge FME Flow Authoring Training
  • Teacher (Grey)
    bellaatsafehas earned the badge Teacher (Grey)
  • FME Flow Authoring Training
    svenrhas earned the badge FME Flow Authoring Training
Show all badges

Community Stats

32,420
Posts
122,944
Replies
40,147
Members

Latest FME