SELECT  
		[SourceTable] = N'ActorNames',
        ACTORS.ActorID AS [ActorIDPrimaryKey],
        ACTORS.SIDNum,
        ACTORNAMES.LastName,
        ACTORNAMES.FirstName,
        ACTORNAMES.MiddleName,
        ACTORNAMES.Suffix,
        ACTORNAMES.Salutation,
        ACTORNAMES.OrganizationName,
        CONVERT(VARCHAR(8), ACTORNAMES.an_CreateDate, 112) AS create_date
FROM    ACTORS
        INNER JOIN ACTORNAMES ON ACTORS.ActorID = ACTORNAMES.ActorID
WHERE   ( NOT ( ACTORNAMES.an_Creator = 'cjis' )
        )
ORDER BY ACTORS.ActorID

WHERE   ( NOT ( ACTORNAMES.an_Creator = 'cjis' )
        )
	AND an_createdate >= '20090211 07:00:00'

an_createdate >= DATEADD(hh,7,DATEADD(dd,DATEDIFF(dd,0,GETDATE()),0))

quote:

---

Originally posted by Peso

WHERE   ( NOT ( ACTORNAMES.an_Creator = 'cjis' )
        )
	AND an_createdate >= '20090211 07:00:00'

---

E 12°55'05.63"
N 56°04'39.26"

---

quote:

---

Originally posted by badpig521

quote:

---

Originally posted by Peso

WHERE   ( NOT ( ACTORNAMES.an_Creator = 'cjis' )
        )
	AND an_createdate >= '20090211 07:00:00'

---

E 12°55'05.63"
N 56°04'39.26"

---

ok, that makes sense, but is there a way to make it a little more automatic. Here is what I am trying to do. I am creating an SSIS package that would run 3 Xs a day after my initial extract. I am pulling the data into a flat file. I would like to run it pulling the data created on each day after a certain time. For example, on this day, I run a job @ Noon pulling data created after 7 am. Does that make sense or am I way off?

---

...
WHERE...
and an_createdate >= DATEADD(hh,7,DATEADD(dd,DATEDIFF(dd,0,GETDATE()),0))

quote:

---

Originally posted by visakh16

quote:

---

Originally posted by badpig521

quote:

---

Originally posted by Peso

WHERE   ( NOT ( ACTORNAMES.an_Creator = 'cjis' )
        )
	AND an_createdate >= '20090211 07:00:00'

---

E 12°55'05.63"
N 56°04'39.26"

---

ok, that makes sense, but is there a way to make it a little more automatic. Here is what I am trying to do. I am creating an SSIS package that would run 3 Xs a day after my initial extract. I am pulling the data into a flat file. I would like to run it pulling the data created on each day after a certain time. For example, on this day, I run a job @ Noon pulling data created after 7 am. Does that make sense or am I way off?

---

you can make source query like this

...
WHERE...
and an_createdate >= DATEADD(hh,7,DATEADD(dd,DATEDIFF(dd,0,GETDATE()),0))

this will ensure it always take current days records from 7 am onwards

---