CLOSE Writer  

DECLARE @adres varchar(40),
		@Name varchar(40),
		@Surname varchar(40),
		@Patronymic varchar(40),
		@Phone varchar(20),
		@ID_CL int


DECLARE Writer CURSOR SCROLL READ_ONLY FOR 
SELECT c.addres  , c.name,  c.surname , c.patronymic , c.phone ,c.client_ID
FROM client as c

OPEN Writer

FETCH NEXT FROM Writer INTO  @adres ,@Name ,@Surname,@Patronymic ,@Phone , @ID_CL
 WHILE @@FETCH_STATUS <> -1
BEGIN
	
    PRINT  + @Surname + ' ' + LEFT(@Name,1) + '. ' + LEFT(@Patronymic,1) + '. Проживает по адресу :' + @adres
    PRINT 'Контактный телефон -' + @Phone
    
    DECLARE @Model varchar(40),
		@Make varchar(40),
		@wheel varchar(40),
		@box varchar(40),
		@date date,
		@body varchar(10),
		@engine varchar(10),
		@CAR_ID int 
		PRINT '________________Информация об автомобилях клиента________________'
		DECLARE WriterCar CURSOR SCROLL READ_ONLY FOR 
			SELECT m.make , mod.model , w.wheel , b.box , a.manufactureDate ,  body ,  engineNumb , auto_id
			FROM auto as a , box as b ,  make as m , model as  mod , wheel as w
			WHERE a.box_ID = b.box_ID AND  m.make_id = a.make_id AND mod.model_id = a.model_id  AND w.wheel_ID = a.wheel_id AND a.client_ID = @ID_CL
		FETCH NEXT FROM WriterCar INTo @Model , @Make, @wheel , @box , @date , @body , @engine , @CAR_ID
		WHILE @@FETCH_STATUS <> -1 
		PRINT '      ' + @make + ' ' + @model + 'c ' + @wheel +'рулем'
		PRINT '      ' + 'Год выпуска : ' + YEAR(@date)
		PRINT '      ' + 'Коробка передач : ' + @box
		PRINT '      ' + 'Номер кузова - ' + @body
		PRINT '      ' + 'Двигатель - ' + @body
		
	PRINT '__________________________________________________'	
		FETCH NEXT FROM WriterCar INTo @Model , @Make, @wheel , @box , @date , @body , @engine , @CAR_ID
		END 
		CLOSE WriterCar
		DEALLOCATE WriterCar

    PRINT '**************************************************'
    PRINT ''
    
    

    FETCH NEXT FROM Writer INTO  @adres ,@Name ,@Surname,@Patronymic ,@Phone 
    END
    CLOSE Writer    
DEALLOCATE Writer

		FETCH NEXT FROM WriterCar INTo @Model , @Make, @wheel , @box , @date , @body , @engine , @CAR_ID
		END 
		CLOSE WriterCar

DECLARE WriterCar CURSOR SCROLL READ_ONLY FOR 
			SELECT m.make , mod.model , w.wheel , b.box , a.manufactureDate ,  body ,  engineNumb , auto_id
			FROM auto as a , box as b ,  make as m , model as  mod , wheel as w
			WHERE a.box_ID = b.box_ID AND  m.make_id = a.make_id AND mod.model_id = a.model_id  AND w.wheel_ID = a.wheel_id AND a.client_ID = @ID_CL
		FETCH NEXT FROM WriterCar INTo @Model , @Make, @wheel , @box , @date , @body , @engine , @CAR_ID
WHILE @@FETCH_STATUS <> -1 
BEGIN
		PRINT '      ' + @make + ' ' + @model + 'c ' + @wheel +'рулем'

DECLARE
  @priceWork int , 
	    @Discription varchar(100),
	    @priceDetail int , 
	    @Detail varchar(30),
	    @payStatus int
	    
	    
	    DECLARE TotalCount CURSOR SCROLL READ_ONLY FOR 
	    SELECT (
			SELECT  w.price , w.description
			FROM service as s,  work as w , estimate as e
		    WHERE  e.service_ID = s.service_ID  AND s.work_ID = w.work_ID  AND e.auto_id = @CAR_ID)
		    ,
		    (SELECT d.price  , d.description 
		     FROM detail as d , estimate as e 
		     where e.detail_ID = d.detail_ID AND e.auto_id = @CAR_ID)
		     ,
		     (SELECT payStatus_ID FROM estimate where  e.auto_id = @CAR_ID)