Hi there I have the following Query and I want the user to enter Start Date in Excel that will trigger the Query.
is it possible to it?
SELECT Problems_ProblemLog.EntryNo, Problems_ProblemLog.RejectID, Problems_ProblemLog.ProblemDescription, Problems_ProblemLog.ActionDescription, Problems_ProblemLog.EDA, Problems_ProblemLog.StartDate, Problems_ProblemLog.PartSNOriginal, Problems_ProblemLog.PartSNNew, Problems_ProblemLog.InstrumentNo, Problems_ProblemLog.PartIDEntry, Problems_ProblemLog.ProblemID, Problems_ProblemLog.ActionID, Problems_ProblemLog.Comment, Problems_ProblemLog.FixID, Problems_ProblemLog.UserID, Problems_ProblemLog.MoreComment
FROM {oj XTestPlus.dbo.Problems_ProblemLog Problems_ProblemLog LEFT OUTER JOIN XTestPlus.dbo.Instruments_Instrument Instruments_Instrument ON Problems_ProblemLog.InstrumentNo = Instruments_Instrument.InstrumentNo}
WHERE (Instruments_Instrument.ModelID In (5,6,7,9,10,60,61,62,54,65,26,25,23)) AND (Problems_ProblemLog.StartDate>{ts '2014-09-01 00:00:00'})
in other words, I would like the query to take the date from a cell in an excel table.
any help would be appreciated!
thanks,
Anat
is it possible to it?
SELECT Problems_ProblemLog.EntryNo, Problems_ProblemLog.RejectID, Problems_ProblemLog.ProblemDescription, Problems_ProblemLog.ActionDescription, Problems_ProblemLog.EDA, Problems_ProblemLog.StartDate, Problems_ProblemLog.PartSNOriginal, Problems_ProblemLog.PartSNNew, Problems_ProblemLog.InstrumentNo, Problems_ProblemLog.PartIDEntry, Problems_ProblemLog.ProblemID, Problems_ProblemLog.ActionID, Problems_ProblemLog.Comment, Problems_ProblemLog.FixID, Problems_ProblemLog.UserID, Problems_ProblemLog.MoreComment
FROM {oj XTestPlus.dbo.Problems_ProblemLog Problems_ProblemLog LEFT OUTER JOIN XTestPlus.dbo.Instruments_Instrument Instruments_Instrument ON Problems_ProblemLog.InstrumentNo = Instruments_Instrument.InstrumentNo}
WHERE (Instruments_Instrument.ModelID In (5,6,7,9,10,60,61,62,54,65,26,25,23)) AND (Problems_ProblemLog.StartDate>{ts '2014-09-01 00:00:00'})
in other words, I would like the query to take the date from a cell in an excel table.
any help would be appreciated!
thanks,
Anat