as i explained before i received docno with different transmittalno and then send them by different transmittaltoCon.

docno is parent of transmittal and transmittal is parent of transmittaltocon.

for excample

today i...

Hi

excuse me the problem of ddl was about (IDENTITY) that used previous values when we inserting data, so i change the value to (1) and now is ok when we...

i checked my ddl again and it works and it returns sample data

This query returns below data:

DocNoTransmittalNoTransmittaltoCon

Doc-001tt-0002con-0003

Doc-001tt-0002con-0007

Doc-005tt-0002con-0005

I like to make a query that returns also below data:

IDPARENTPOSITION ...

thanks,

i try to provide create table and insert value statements

tblDocuments:

USE [EDMS]

GO

/****** Object: Table [dbo].[tblDocuments] Script Date: 06/25/2013 23:44:17 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE...