Could you perhaps elaborate on what you are looking to determine happened "in the last 90 days"? because your sample query to which you want to add a data parameter; you are mentioning v_add_remove_programs, but then you are completely out of the blue (or so it seems to me) trying to tie that to v_package.name.
On Saturday, October 11, 2014 10:26 PM, Ranvir singh <[email protected]> wrote: any help please!!!! On Wed, Oct 8, 2014 at 6:13 PM, Ranvir singh <[email protected]> wrote: Hi All, > > >For below query I want to add date function like last 90 days.. But im unable >to add the date function > > > > >select distinct V_Packages.Name from V_Packages left outer join >v_Add_Remove_Programs on V_Packages.Name=v_Add_Remove_Programs.DisplayName0 >where v_Add_Remove_Programs.DisplayName0 IS NULL >AND V_Packages.Name NOT like '%\_T\_%' escape '\' > > > > > > >I have tried the below thing not worked any help!!!! > > >select distinct V_Packages.Name from V_Packages left outer join >v_Add_Remove_Programs on V_Packages.Name=v_Add_Remove_Programs.DisplayName0 >where v_Add_Remove_Programs.DisplayName0 IS NULL >AND V_Packages.Name NOT like '%\_T\_%' escape '\' >and >V_Packages.Name in (Select DisplayName0 from v_Add_Remove_Programs where >DATEDIFF (D, >convert(datetime,V_add_remove_programs.InstallDate0,0),GETDATE())<=90) >
