CREATE TABLE [dbo].[MainPositions](
	[Posit_ID] [bigint] IDENTITY(1,1) NOT NULL,
	[Posit_ID_ex1] [uniqueidentifier] NULL,
	[Posit_ID_ex2] [varchar](150) NULL,
	[PositName] [varchar](250) NULL,
 CONSTRAINT [PK_Posit_ID] PRIMARY KEY CLUSTERED 
([Posit_ID] ASC)) ON [PRIMARY]

CREATE TABLE [dbo].[PosTechList](
	[KeyField] [bigint] IDENTITY(1,1) NOT NULL,
	[CALC_ID] [bigint] NULL,
	[Posit_ID] [bigint] NULL,
	[Posit_ID_ex1] [uniqueidentifier] NULL,
	[Posit_ID_ex2] [varchar](150) NULL)

CREATE TABLE [dbo].[Komp_PrcCardsTechDetal](
	[KeyField] [bigint] IDENTITY(1,1) NOT NULL,
	[CALC_ID] [bigint] NULL,
	[Posit_ID] [bigint] NULL,
	[Posit_ID_ex1] [uniqueidentifier] NULL,
	[Posit_ID_ex2] [varchar](150) NULL,
	[ProductTYPE] [varchar](1) NULL,
	[Product_ID] [bigint] NULL,
	[Product_ID_ex1] [uniqueidentifier] NULL,
	[Product_ID_ex2] [varchar](150) NULL,
	[Kol_1] [float] NULL,
	[Kol_2] [float] NULL) 

CREATE TABLE [dbo].[Products](
	[Product_ID] [bigint] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[Product_ID_ex1] [uniqueidentifier] NULL,
	[Product_ID_ex2] [varchar](150) NULL,
	[ProductName] [varchar](250) NULL,
 CONSTRAINT [PK_Product_ID] PRIMARY KEY CLUSTERED 
([Product_ID] ASC)) ON [PRIMARY]

select *
from MainPositions left outer join PosTechList on PosTechList.Posit_ID=MainPositions.Posit_ID
left outer join PosTechDetal on PosTechDetal.Posit_ID=PosTechList.Posit_ID
                            and PosTechDetal.CALC_ID=PosTechList.CALC_ID
 LEFT OUTER JOIN Products ON Products.Product_ID=PosTechDetal.Product_ID
where MainPositions.Posit_ID=31723

select *
from MainPositions left outer join PosTechList on PosTechList.Posit_ID_ex1=MainPositions.Posit_ID_ex1
left outer join PosTechDetal on PosTechDetal.Posit_ID_ex1=PosTechList.Posit_ID_ex1
                            and PosTechDetal.CALC_ID=PosTechList.CALC_ID
 LEFT OUTER JOIN Products ON Products.Product_ID_ex1=PosTechDetal.Product_ID_ex1
where MainPositions.Posit_ID_ex1='8C9728C1-6073-4412-8E7F-E7840542C506'

select *
from MainPositions left outer join PosTechList on PosTechList.Posit_ID_ex2=MainPositions.Posit_ID_ex2
left outer join PosTechDetal on PosTechDetal.Posit_ID_ex2=PosTechList.Posit_ID_ex2
                                      and PosTechDetal.CALC_ID=PosTechList.CALC_ID
 LEFT OUTER JOIN Products ON Products.Product_ID_ex2=PosTechDetal.Product_ID_ex2
where MainPositions.Posit_ID_ex2='8C9728C1-6073-4412-8E7F-E7840542C506'

declare @i int
declare @PosGuid uniqueidentifier
declare @ProductGuid uniqueidentifier
set @i=50000
while @i<>0 
begin
set @PosGuid=NEWID();
set @ProductGuid=NEWID();
insert into MainPositions (Posit_ID_ex1,Posit_ID_ex2) 
values (@PosGuid,@PosGuid)
insert into PosTechList (Posit_ID_ex1,Posit_ID_ex2) 
values (@PosGuid,@PosGuid)
insert into Products (Product_ID_ex1,Product_ID_ex2) 
values (@ProductGuid,@ProductGuid)
insert into PosTechDetal (calc_ID,Posit_ID_ex1,Posit_ID_ex2,Product_ID_ex1,Product_ID_ex2) 
values (1,@PosGuid,@PosGuid,@ProductGuid,@ProductGuid)
set @i=@i-1

print @i
end;

UPDATE PosTechList 
SET Posit_ID=
(SELECT Posit_ID FROM MainPositions WHERE MainPositions.Posit_ID_ex1=PosTechList.Posit_ID_ex1)

UPDATE PosTechDetal 
SET Posit_ID=
(SELECT Posit_ID FROM MainPositions WHERE MainPositions.Posit_ID_ex1=PosTechDetal.Posit_ID_ex1)

UPDATE PosTechDetal 
SET Product_ID=
(SELECT Product_ID FROM Products WHERE Products.Product_ID_ex1=PosTechDetal.Product_ID_ex1)

SELECT * ... 

CREATE NONCLUSTERED INDEX [Posit_ID] ON [dbo].[PosTechList] 
(
	[Posit_ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [Posit_ID_ex1] ON [dbo].[PosTechList] 
(
	[Posit_ID_ex1] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [Posit_ID_ex2] ON [dbo].[PosTechList] 
(
	[Posit_ID_ex2] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [Posit_ID] ON [dbo].[MainPositions] 
(
	[Posit_ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [Posit_ID_ex1] ON [dbo].[MainPositions] 
(
	[Posit_ID_ex1] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [Posit_ID_ex2] ON [dbo].[MainPositions] 
(
	[Posit_ID_ex2] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [Posit_ID] ON [dbo].[PosTechDetal] 
(
	[Posit_ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [Posit_ID_ex1] ON [dbo].[PosTechDetal] 
(
	[Posit_ID_ex1] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [Posit_ID_ex2] ON [dbo].[PosTechDetal] 
(
	[Posit_ID_ex2] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [Product_ID] ON [dbo].[PosTechDetal] 
(
	[Product_ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [Product_ID_ex1] ON [dbo].[PosTechDetal] 
(
	[Product_ID_ex1] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [Product_ID_ex2] ON [dbo].[PosTechDetal] 
(
	[Product_ID_ex2] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [Product_ID] ON [dbo].[Products] 
(
	[Product_ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [Product_ID_ex1] ON [dbo].[Products] 
(
	[Product_ID_ex1] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [Product_ID_ex2] ON [dbo].[Products] 
(
	[Product_ID_ex2] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO