SQL 2008 r2 and Excel column disappear

• richestguy

  Grasshopper

  Points: 23

  More actions

  October 7, 2015 at 7:35 am

  #321800

  Hello, I have questions regarding SQL 2008 r2 and Excel 2013.

  The below code users run from excel and it display all the data first time and when user click refresh under Data in excel the JOBID under JOB column disappear but all other column does not I was wondering if anyone had similar issue.

  Any suggestions would be great thank you in advance.

  SELECT Ind_DHK_ProdRpt_view.Job, Ind_DHK_ProdRpt_view.suffix, Ind_DHK_ProdRpt_view.item, Ind_DHK_ProdRpt_view.description,

  Ind_DHK_ProdRpt_view.qty_released, Ind_DHK_ProdRpt_view.[Current WC], Ind_DHK_ProdRpt_view.EndDate, dt.trans_Date AS IntoQue,

  Ind_DHK_ProdRpt_view.co_num, Ind_DHK_ProdRpt_view.Bill_Name, Ind_DHK_ProdRpt_view.UsedHrs, Ind_DHK_ProdRpt_view.start_date, n.notecontent

  FROM IND_DHK_ProdRpt_view AS Ind_DHK_ProdRpt_view LEFT OUTER JOIN

  (SELECT job.job, job.suffix, MAX(jobroute.oper_num) AS oper_num, MAX(d.trans_date) AS trans_Date

  FROM job INNER JOIN

  jobroute ON job.job = jobroute.job AND job.suffix = jobroute.suffix LEFT OUTER JOIN

  (SELECT job, suffix, oper_num, MAX(trans_date) AS trans_date

  FROM jobtran

  WHERE (trans_date >= DATEADD(d, - 180, GETDATE())) AND (job LIKE 'j%') AND (qty_complete > 0)

  GROUP BY job, suffix, oper_num) AS d ON jobroute.job = d.job AND jobroute.suffix = d.suffix AND jobroute.oper_num = d.oper_num

  WHERE (job.stat = 'R') AND (jobroute.complete = 1)

  GROUP BY job.job, job.suffix) AS dt ON Ind_DHK_ProdRpt_view.Job = dt.job AND Ind_DHK_ProdRpt_view.suffix = dt.suffix left outer join

  (SELECT job_2.job, job_2.suffix, job_2.stat, SpecificNotes_2.NoteContent, SpecificNotes_2.NoteDesc

  FROM SyteLine_App_MC.dbo.SpecificNotes AS SpecificNotes_2 INNER JOIN

  SyteLine_App_MC.dbo.ObjectNotes AS ObjectNotes_2 ON SpecificNotes_2.SpecificNoteToken = ObjectNotes_2.SpecificNoteToken INNER JOIN

  SyteLine_App_MC.dbo.job AS job_2 ON ObjectNotes_2.RefRowPointer = job_2.RowPointer

  WHERE (SpecificNotes_2.NoteDesc LIKE 'QQ%')) n on Ind_DHK_ProdRpt_view.job = n.job and Ind_DHK_ProdRpt_view.suffix = n.suffix

  WHERE (Ind_DHK_ProdRpt_view.[Current WC] IN ('AA-160', 'AA-161', 'AA-163', 'AA-164', 'AA-165', 'AA-210')) AND (Ind_DHK_ProdRpt_view.EndDate <= DATEADD(d, 30,

  GETDATE()))

  ORDER BY Ind_DHK_ProdRpt_view.EndDate