"Andrew John" <aj@DELETEmistrose.com> wrote in message
news:edo$7wQIEHA.520@tk2msftngp13.phx.gbl...
> Please do not repeat post - netiquette.
>
> "ajmiester" <ajmister@opyonline.net> wrote in message
> news:uEQSUtPIEHA.716@TK2MSFTNGP12.phx.gbl...
> > Hi
> >
> > I have a table that has data being inserted as soon as it available. I
> have
> > a query that is scheduled to run at the end of the day which extracts
data
> > where date > yesterday. I have to modify it to run every half hour and
> only
> > include data that was inserted after the previous run.
> >
> > Create table tmp_comp
> > ( name char(30),
> > number float,
> > flag char(2),
> > e_dt datetime
> > )
> >
> > current query
> >
> > declare @y_dt char(12)
> > select @y_dt = convert(char(12),(select dateadd(dd, -1, getdate())),10)
> > --print @y_dt
> >
> > select name as C_name,
> > number as Value,
> > e_dt as Entry_date
> > from tmp_comp
> > where convert(char(12),e_dt,10) = @y_dt
> > order by name
> > go
> >
> > Ajay
> >
> >
>
>

"ajmiester" <ajmister@opyonline.net> wrote in message
news:uEQSUtPIEHA.716@TK2MSFTNGP12.phx.gbl...
> Hi
>
> I have a table that has data being inserted as soon as it available. I
have
> a query that is scheduled to run at the end of the day which extracts data
> where date > yesterday. I have to modify it to run every half hour and
only
> include data that was inserted after the previous run.
>
> Create table tmp_comp
> ( name char(30),
> number float,
> flag char(2),
> e_dt datetime
> )
>
> current query
>
> declare @y_dt char(12)
> select @y_dt = convert(char(12),(select dateadd(dd, -1, getdate())),10)
> --print @y_dt
>
> select name as C_name,
> number as Value,
> e_dt as Entry_date
> from tmp_comp
> where convert(char(12),e_dt,10) = @y_dt
> order by name
> go
>
> Ajay
>
>