Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Delfie
Starting Member
2 Posts |
 Posted - 2002-05-20 : 19:38:44
|
| Hi,I am trying to figure out 2 problems in relation to Business Objects and free-hand SQL and would really appreciate any feedback anyone has :)Firstly I am trying to include in a report for Broadcast Agent, the name of the person who submitted the report to Broadcast Agent. Under DS_PENDING_JOB there is a table called USER_SUBMIT_ID (numeric) and apparently I need to reference a value under the table OBJ_M_ACTOR in order to have the users name displayed. I know how to join tables but am unsure of how to go about this problem?I was thinking I would need to convert the numeric to a char seeing as tho I want a name displayed.e.g.select convert(char(20),user_submit_id)from ds_pending_jobwhere ds_pending_job.docserver_id = obj_m_actor.m_actor_n_id Also, in order to get the 'scheduled date' in a Broadcast Agent report I am aware that I need to combine BEGIN_DATE, BEGIN_TIME and FREQUENCY but I am unsure of the free-hand SQL I should be using. Has anyone come across queries such as these? Regards, Delfie |
|
|
Delfie
Starting Member
2 Posts |
Posted - 2002-05-21 : 02:15:46
|
| Another alternative a colleague gave me for the submission owner was:select m_actor_c_namefrom ds_pending_job,obj_m_actorwhere ds_pending_job.user_submit_id = obj_m_actor.m_actor_n_idhowever, it appears it works in SQL ADV but not in Business Objects, as I am getting the error 'no data to fetch'.Regards Delfie |
 |
|
|
|
|
|
SQL syntax query in relation to Business Objects