Help in Stored Procedure using join

• just.sri

  Grasshopper

  Points: 13

  More actions

  February 21, 2009 at 3:14 am

  #131146

  Hi ,

  I have two tables Company and company details

  Company has columns COmpanyID(PK), EntityId, LastupdatedBy, Lastupdateddate

  I have to populate date into Company details which has columns

  CompanyDetailsID(PK),

  CompanyId,

  ,SubSectorId

  ,StateId

  ,CountryId

  ,RegionId

  ,LastUpdatedBy

  ,LastUpdatedDate

  I am able to write and populate date into my company table using this stored procedure

  INSERT Db_Company.Company

  (

  EntityId

  ,CompanyName

  ,LastupdatedBy

  ,LastUpdatedDate

  )

  Select

  stg.entityid,stg.publishedname,user, dbo.fnDateMap(getDate())

  from stgRating as stg

  left join

  Db_Company.Company as c

  on stg.entityid = c.entityid

  where c.entityid is null

  group by stg.entityid,stg.publishedname

  (Here PublishedName is my Staging table column name which populates my date, so i used it above.)

  I am not able to figure out to use which join in my companydetails table...

  So i used them as foreign keys(In CompanyDetails), Which are primary keys for the tables Sector, Subsectors etc....

  Sector, Subsectors etc are other tables in the db...

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  February 21, 2009 at 2:46 pm

  #948221

  1. I would like recommend you to post such a question in T-SQL forum. People there are more happy for this kind of question.

  2. You need to provide information on other tables in your question.

  3. You cancCheck BOL for the meaning of LEFT/RIGHT JOIN.