1. 

   vittorio, Member

   dear sir
   I have
   Report table A with sp_DBR_xxxxx (user report 50 rows)
   Report Table B with sp_DBR_yyyyy (assignment report (500 rows)

   Table A has Column 2 of my interest.

   I have to insert Column A2 into Table B matching per User_ID.

   Reports created with SP called A & B have different lenght .Field B2 need to be populated by A2 data where

   A2.user_ID= B2.username

   Both are list of users per ID.

   I've tried to Call SP_DBR_xxxx and SP_DBR_yyyy in order to inser the column "A" into B joining them together but I cannot go through.

   pls provide support if you can.

   thanks
2. 

   myDBR Team, Key Master

   myDBR generates the reports that are shown on the screen directly from the output of our stored procedures. This means that if you want to make a join between two tables you would have to make that join inside the procedure.

   The procedure itself only returns a result which cannot be joined anymore with another table.

   So instead of calling the second procedure you would just add the join to the select statement in the second report procedure.

   Best Regards,

   myDBR Team
3. 

   vittorio, Member

   can you give me a quick example please.

   thanks
4. 

   vittorio, Member

   it is not a matter to simply join two tables together but spreading into one column of a table A other data indexed in the Table B.

   please make sure you understand what is the need.

   thanks

Reply

You must log in to post.