I want to write validation Query which should return invalid parents I If any

• manoj.ramaiah

  SSC Eights!

  Points: 864

  More actions

  May 27, 2013 at 1:16 am

  #277985

  I have a table for which I want to validate where each parent intermediary is also a parent to itself. I want to write a query to validate this...

  COLUMN DATATYPE DESCRIPTION

  IntermediaryPK int

  SourceSystemID tinyint Intermediary source

  IntermediaryID nvarchar(20) Intermediary ID

  IntermediaryName nvarchar(200) Intermediary name

  IntermediaryTypeID nvarchar(1) Intermediary type

  ParentIntermediaryID nvarchar(20) Intermediary parent

  IntermediaryTypePK tinyint Intermediary type

  IntermediaryCategoryPK smallint Intermediary category

  ParentIntermediaryPK int Parent intermediary PK

  GrandParentIntermediaryPK int Grand parent intermediary PK

  I want to write validation Query which should return invalid parents I If any..

• Bhaskar.Shetty

  Hall of Fame

  Points: 3054

  More actions

  May 27, 2013 at 1:19 am

  #1618694

  duplicate post, already explained to your previous post.