Database

         Jan   Feb   Mar   Apr
         ---   ---   ---   ---
Budget   10    10    10    10
Actual   10    5     10    0
...      0     0     0     0
...      0     0     0     0
...      0     0     0     0

 MONTH   TOTAL
200901    10
200902    10
200903    10
200904    10

         Jan   Feb   Mar   Apr
         ---   ---   ---   ---
Budget   10    10    10    10
Actual   10    5     10    0
...      0     0     0     0
...      0     0     0     0
...      0     0     0     0

Muammar© wrote:

Is there any way to do it with this structure??

JAN     FEB     MARCH   APRIL
---     ---     -----   -----
10	10	10	10
NULL	20	11	12
20	40	1	1
30	NULL	5	6
NULL	NULL	NULL	NULL

Col1 Col2 Col3 Col4 Col5 Col6

RandomCol

ALTER PROCEDURE InsertRecordsIntoTableA
	-- Add the parameters for the stored procedure here
	(
		@VarCol1 AS VARCHAR(50),
		@VarCol2 AS VARCHAR(50),
		@VarCol3 AS VARCHAR(50),
		@VarCol4 AS VARCHAR(50),
		@VarCol5 AS VARCHAR(50)
	)
AS
BEGIN
	
	-- VARIABLE DECLARATION
	DECLARE @RANDOMCOLUMNVALUES VARCHAR(50)

   -- STEP 1: DECLARE A CURSOR
	DECLARE MYRANDOMCURSOR CURSOR FOR

		SELECT    RANDOMCOL
		FROM      TABLEB

	-- STEP 2: OPEN THE CURSOR
	OPEN MYRANDOMCURSOR 

	FETCH MYRANDOMCURSOR INTO @RANDOMCOLUMNVALUES

	-- STEP 3: START THE LOGIC

	WHILE @@Fetch_Status = 0

	BEGIN

		-- STEP 4: INSERT THE COMBINED RECORDS INTO TABLE A

			INSERT INTO TABLEA(COL1,COL2,COL3,COL4,COL5,COL6)

			VALUES(@VarCol1,@VarCol2,@VarCol3,@VarCol4,@VarCol5,@RANDOMCOLUMNVALUES)
		
	-- STEP 5: GET THE NEXT RECORD
	FETCH MYRANDOMCURSOR INTO @RANDOMCOLUMNVALUES           

   END

	--STEP 6: CLOSE THE CURSOR
	CLOSE MYRANDOMCURSOR

	--STEP 6: DEALLOCATE THE CURSOR
	DEALLOCATE MYRANDOMCURSOR
	
END

Paul Unsworth wrote:

s there a way of copying the source table to the destination regardless of what fields are in it

Paul Unsworth wrote:

I hope not all DBA's are like this