Database

INSERT INTO tblX (IDQuote, FieldA, FieldB, ...)
(
SELECT ID_Quote, FieldA, FieldB, ...
FROM QuoteItems [JOIN tableX ON...]
WHERE ID_Quote = @idQuote
)

UPDATE Items SET Field=value WHERE id_item IN (SELECT id_item FROM Orders WHERE ID_order=1);

CREATE PROCEDURE dbo.sp_InsertOrdersItems @ID_quote int  AS

INSERT INTO OrdersItems
(ID_order, Description, Produced)
(
SELECT Orders.ID_order, QuoteItems.Description, false
FROM Orders 
INNER JOIN QuoteItems ON Orders.ID_quote = QuoteItems.ID_Quote
WHERE Orders.ID_Quote = @ID_quote
)

SELECT LG.id_lg, 
       LG.name, 
       SUM(LGL.type_of_hour) AS sum_of_hourtypes
  FROM LG AS LG 
  JOIN LineLG AS LGL
    ON LGL.id_lg = LG.id_lg
 GROUP BY LG.id_lg, 
       LG.name
 ORDER BY LG.name

SELECT LG.id_lg, 
       LG.name,
       COUNT(LGL.type_of_hour) AS count_of_hourtypes
  FROM LG AS LG 
  JOIN LineLG AS LGL
    ON LGL.id_lg = LG.id_lg
 GROUP BY LG.id_lg, 
       LG.name
 ORDER BY LG.name

CREATE TABLE ThatTable
(
   Field_A varchar(25) not null,
   Field_B varchar(25) not null,
   Field_C varchar(25) not null,
   MoreFields varchar(25)
   CONSTRAINT FK_ThatTable_ThisTable
   FOREIGN KEY (Field_A, Field_B, Field_C) 
     REFERENCES ThisTable (Field_A, Field_B, Field_C)
   /* any ON UPDATE, ON DELETE clauses here */
)