Hi,
SET NOCOUNT ON
DECLARE @name varchar(50)
DECLARE @DepartmentCode varchar(50)
Declare StudentIDCursor CURSOR FOR
SELECT name,DeaprtmentCode
FROM Student,[Subject]
Open StudentIDCursor
Fetch Next from StudentIDCursor into @name,@DepartmentCode
While(@@FETCH_STATUS = 0)
Begin
INSERT INTO [Class]([Name],[DepartmentCode])
VALUES
(@name,@DepartmentCode)
Fetch Next from StudentIDCursor into @name,@DepartmentCode
End
CLOSE StudentIDCursor
DEALLOCATE StudentIDCursor
SET NOCOUNT OFF
Here is the o/p
====================
Name DepartmentCode
vani ENG-001
vani MATH-002
vani SOCIAL-003
vani GENSCIENCE-004
vani GEOGRAPHY-005
soni ENG-001
soni MATH-002
soni SOCIAL-003
soni GENSCIENCE-004
soni GEOGRAPHY-005
ravi ENG-001
ravi MATH-002
ravi SOCIAL-003
ravi GENSCIENCE-004
ravi GEOGRAPHY-005