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

  • English Speaker
    ranxdotcomhas earned the badge English Speaker
  • FME Flow Authoring Training
    andrew_prhas earned the badge FME Flow Authoring Training
  • Welcome Back
    andrew_prhas earned the badge Welcome Back
  • Welcome Back
    bboulmayhas earned the badge Welcome Back
  • Hindi Speaker
    prayag_iashas earned the badge Hindi Speaker
Show all badges

Community Stats

32,343
Posts
122,980
Replies
40,417
Members