data cycle

T

thread

Hi all,
I'm building a wizard that make data cuts for groups
i need to make sufficient way to extract the data one cycle before in
a smart way depending on the population
beside the cycle i need to take to consideration the year(if there was
just one cycle in this year the data will be pulled from last year
depending on the recent cycle
if there was already a cycle in the the same year should extract the
data from the same year just recent cycle
any examples or comments?
 
L

Larry Linson

I wish I understood what you are talking about -- feel free to clarify your
use of the term "cycle" in this context, and why a "wizard" is necessary,
rather than just normal processing, and, well... details of what you have
and are trying to accomplish.

Larry Linson
Microsoft Access MVP
 
T

thread

i'm buidling a tool that populating data based on the current year
together will data from the archives
the 2 cycles that i'm talking are 2 cycle of data submitting and data
uploading
i want to find a smart SQL sentece or maybe something more suffiecent
that will make the tool easy to exchange between the data collection
in the archives
for example
i'm uploading and submittng data to 5 groups in the tool as part of
proccess to cycle 1
then in the same year i'm submitting data and uploading only to 2 of
them
i need to find a sufficiend way to switch between the archive filter
basing on a year and a cycle

Larry Linson כתב:
 
T

thread

any ideas?
thread כתב:
i'm buidling a tool that populating data based on the current year
together will data from the archives
the 2 cycles that i'm talking are 2 cycle of data submitting and data
uploading
i want to find a smart SQL sentece or maybe something more suffiecent
that will make the tool easy to exchange between the data collection
in the archives
for example
i'm uploading and submittng data to 5 groups in the tool as part of
proccess to cycle 1
then in the same year i'm submitting data and uploading only to 2 of
them
i need to find a sufficiend way to switch between the archive filter
basing on a year and a cycle

Larry Linson כתב:
Click to expand...
 
A

Aaron Kempf

he's asking how to find a decent ETL tool

and the answer is SQL Server DTS or SSIS or even Informatica


any ideas?
thread ???:
 
L

Larry Linson

Apparently Mr. Kempf understands what you are asking better than I do, or he
feels he has the answer, regardless of the meaning of the question, as is
sometimes the case with his answers.

But, I am sorry that I still don't understand what you are trying to
accomplish.
populating data based on the current year
together will data from the archives
Click to expand...

Populating what? A Table -- permanent or temporary? Extracting the data
with a Query? Once you have that data "populated," what are you going to
_do_ with it?
the 2 cycles that i'm talking are 2 cycle
of data submitting and data uploading
Click to expand...

If I said, "the 2 bricks that I'm talking about are 2 bricks, one red, and
one grey" I would still need a definition of "brick" unless I was sure what
a "brick" was. "Cycle" is such a generic term that I still don't understand
what you mean.
i'm uploading and submittng data to 5
groups in the tool as part of proccess
to cycle 1 then in the same year i'm
submitting data and uploading only
to 2 of them
Click to expand...

"Groups in the tool" doesn't tell me anything, nor "part of process to cycle
1", and have no idea what the significance may be of "in the same year i'm
submitting data and uploading only to 2 of them".

This may all be meaningful information to you. I suppose it must be. I don't
understand the source of your information, nor what kind of information you
are processing, nor what you are actually trying to do with it. I'm
assuming that "cycle" has a particular specific meaning for you that is not
clear to me. It would be helpful if you would speak less generically and
more specifically in real-world terms.

Larry Linson
Microsoft Access MVP




any ideas?
thread ???:
 
T

thread

Hi I'm sorry that i'm not clear its just hard to explain this data
implementation

we are using big archive table that suppose to pull out data from the
last time it have been uploaded
the cycles that i'm talking about it 2 cycles of data uploading
that means to cut story short:

i'm uploading data in april 2007
then
in june the same year i'm uploading again
a year after i'm uploading again and etc...
this is the optimal load of the data but there would be an exception
of the upload for several of individuals
all what i need to extract in the end of the day its the last data
that been uploaded to the table
its east when its going year by year as i can just go one year
before,and pull information but its becomes more complicated when the
year before might consist 2 data uploading when i'm not really sure
when it have been uploaded.
i hope it spread more light on my issue

Larry Linson כתב:
 
A

Aaron Kempf

again

you need an ETL TOOL, not Microsoft Access

go and buy a copy of SQL Server 2000 Developers; it is only $49

and learn DTS

Hi I'm sorry that i'm not clear its just hard to explain this data
implementation

we are using big archive table that suppose to pull out data from the
last time it have been uploaded
the cycles that i'm talking about it 2 cycles of data uploading
that means to cut story short:

i'm uploading data in april 2007
then
in june the same year i'm uploading again
a year after i'm uploading again and etc...
this is the optimal load of the data but there would be an exception
of the upload for several of individuals
all what i need to extract in the end of the day its the last data
that been uploaded to the table
its east when its going year by year as i can just go one year
before,and pull information but its becomes more complicated when the
year before might consist 2 data uploading when i'm not really sure
when it have been uploaded.
i hope it spread more light on my issue

Larry Linson ???:
 
T

thread

this is the work environment i'm working on and thats it,you cannot
make a company change their way of working only find solution for this
thanks

Aaron Kempf כתב:
 
Top