SQL code query to work within Oracle Responsys Email Software

  • Posted:
  • Proposals: 4
  • Remote
  • #1631317
  • Expired
Sandeep S.Russell L.Jaden F.Venkatavijaykrishna N. have already sent a proposal.
  • 0

Description

Experience Level: Expert
I am looking for a developer to write piece of SQL code to use within the Oracle Responsys Email software.

The full specification is attached however in summary:

- We have built a program within Responsys that is set up to automatically send emails to a set list of email addresses on a certain day.
- This list of email addresses is currently pulled into the program via a filter. - We need to be able to cap the number of emails that are sent out, however it is not possible to do this within the programs interface eg. if the filter has 1000 email addresses, we may need to cap the number of emails sent out to 500 email addresses for example.
- We would like a piece of code written, which would enable us to cap the sends
- It must be easily possibly to duplicate this code so we can use the same method in other projects

Please can you let us know:
- If this is possible? (If this is not possible using a filter we can also pull the data in via a PET table)
-How much would it cost?
- How long will it take to deliver?

It would be preferable to work with a developer who has worked with Oracle's responsys product before. Please specify if you have this experience.

I look forward to hearing back.

New Proposal

Create an account now and send a proposal now to get this project.

Sign up

Clarification Board Ask a Question

  • Ajay K.

    Sorry for being so absurd .
    Are you talking about selecting the top 500 records and ignore the rest of the records in one go?



    SELECT a.ROW_COUNT,COUNT(*) AS TOTAL_NUM FROM
    (
    SELECT CUSTOMER_ID_, COUNT(*) AS ROW_COUNT
    FROM $A$
    GROUP BY CUSTOMER_ID_
    HAVING COUNT(*) <= 500
    )
    a
    GROUP BY a.ROW_COUNT

  • Ajay K.

    Sorry for being so absurd .
    Are you talking about selecting the top 500 records and ignore the rest of the records in one go?



    SELECT a.ROW_COUNT,COUNT(*) AS TOTAL_NUM FROM
    (
    SELECT CUSTOMER_ID_, COUNT(*) AS ROW_COUNT
    FROM $A$
    GROUP BY CUSTOMER_ID_
    HAVING COUNT(*) <= 500
    )
    a
    GROUP BY a.ROW_COUNT