Progress db DTS To SQL Server for SS Reporting Services

Posted by Admin on 22-Jun-2006 12:57

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@

All Replies

Posted by Phillip Magnay on 23-Jun-2006 13:05

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

Posted by Admin on 23-Jun-2006 14:12

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@

This thread is closed