I am working for a company that uses both SQL server and Progress dbs.
The progress db's are for one of our apps that is going to be around
for a long time.
They want to use SQL Server Reporting Services to generate a whole
bunch of reports, and I have been asked to set up some kind of dump
from Progress to SQL Server on a monthly basis.
I'm using DTS to do it all, but I am finding a problem getting some
syntax to work.
I'd like to
select etc
from pub.table
where column1 = X
where X is the sysdate, but I need to format it. The data in progress
is saved with a period which is just YEAR-1-MONTH. Why they use the
first of the month I am not sure, but that's the way it's laid out.
I'd like to somehow pull the month and year out of sysdate and concat
them
YEAR-1-MONTH
with the month being the month before so I guess it'd have to be
YEAR-1-(MONTH-1)
But I would have to take into consideration what happens in January as
well.
I saw some posts on ADD_MONTHS(MONTH, -1), but the sql statement didn't
like it.
Thanks!
M@
Matthew,
You make like to look at page 291 of the SQL Reference Manual which you will find here: http://bedford.psdn.com/library/entry.jspa?externalID=112&categoryID=194
I don't think it completely answers your specific question but it may give you an avenue to explore.
Phil
That makes sense, thanks for sending that. My issue is that I have to use it in the where clause to look for specific days.
I need to look for data between the 16th of last month and the 8th of this month. I'll try string them together.
thanks for replying!
M@