Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
WHERE (OrderEntryStats.Entered>={ts '2015-12-01 00:00:00'}) AND (OrderEntryStats.FacId Not In ('FORMS','MSTR','RETAIL','SAMPLE','TEST','TEST#2','TEST2','TEST3','TRLK','stag')) AND (OrderEntryStats.Deleted=1) |
How do I convert this to work in the data load?
Need to run but will check back later
The other times I copied the sql I had to remove Orderentrystats. before it would run and now I cant refresh data must be Friday
Thank you for your help
wow that worked great. Now the where statements, I got these to work after editing the detail. Is there a way to copy paste?
WHERE (OrderEntryStats.Entered>={ts '2015-12-01 00:00:00'}) AND (OrderEntryStats.FacId Not In ('FORMS','MSTR','RETAIL','SAMPLE','TEST','TEST#2','TEST2','TEST3','TRLK','stag')) AND (OrderEntryStats.Deleted=1);
May be this:
LIB CONNECT TO 'pmd-sandbox (pharmore_rwinkel)';
Table1:
LOAD *;
SQL SELECT
OrderEntryStats.EnteredByNPI AS 'OEDEnteredByNPI',
OrderEntryStats.RxNo,
OrderEntryStats.Entered AS 'OEDEntered',
OrderEntryStats.PhrNPI AS 'OEDPhrNPI',
OrderEntryStats.InitReview AS 'OEDInitReview',
OrderEntryStats.ProfileOnly AS 'OEDProfileOnly',
OrderEntryStats.DispenseDt AS 'OEDDispenseDt',
OrderEntryStats.TransType AS 'OEDTransType',
OrderEntryStats.Deleted AS 'OEDDeleted',
OrderEntryStats.FacId AS 'OEDFacID',
OrderEntryStats.PatId AS 'OEDPatID'
FROM Rx.dbo.OrderEntryStats OrderEntryStats
WHERE (OrderEntryStats.Entered>={ts '2015-12-01 00:00:00'}) AND (OrderEntryStats.FacId Not In ('FORMS','MSTR','RETAIL','SAMPLE','TEST','TEST#2','TEST2','TEST3','TRLK','stag')) AND (OrderEntryStats.Deleted=1);