CREATE TABLE [dbo].[student](
	[id] [int] NOT NULL,
	[name] [nchar](10)  NOT NULL,
	[studentcategoryid] [int] NOT NULL
) ON [PRIMARY]


insert into student values
(1,'st1',1)
(2,'st2',1)
(3,'st3',1)

CREATE TABLE [dbo].[studentcategory](
	[id] [int] NOT NULL,
	[name] [nchar](10)  NOT NULL
) ON [PRIMARY]

insert into studentcategory values
(1,'art')
(2,'accounting')

CREATE TABLE [dbo].[award](
	[id] [int] NOT NULL,
	[studentid] [nchar](10)  NULL
) ON [PRIMARY]

quote:

---

Originally posted by nigelrivett

maybe
insert award (studentid)
select id
from student
where studentcategoryid = 1

How do you allocate the award.id?


==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.

---

quote:

---

Originally posted by nigelrivett

>> @studentcategoryid is xml
Not in your structure.

insert award (studentid)
select id
from student
where studentcategoryid = @studentcategoryid


==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.

---