October 7, 2015 at 7:35 am
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
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply