quote:

---

Declare @email varchar(50)

Declare cursid cursor for
select distinct(right(email, (len(email)-charindex('@', email)))) from smc_new_products.dbo.usr_smc


Open cursid
Fetch next from cursid into @email
while (@@fetch_status<>-1)
Begin

insert into company_activity
select @email, (firstName + ' ' + lastname) as [Full Name], company_name as [Company], configname, requestdatetime
from
smc_new_products.dbo.etechmodelrequests et
join
smc_new_products.dbo.usr_smc us on et.username=convert(varchar(50), us.[user_id])
where
username in
(select convert(varchar(50), [user_id]) from smc_new_products.dbo.usr_smc where right(email, (len(email)-charindex('@', email)))=@email)
and
et.interfacename like '%download%'
order by et.requestdatetime

Fetch next from cursid into @email
End

---

quote:

---

Hi
You havent defined a column list

Quote
"insert into company_activity
select @email, (firstName + ' ' + lastname) as [Full Name], company_name as [Company], configname, requestdatetime"

Should be
INSERT company_activity(email, fullname, company etc)
SELECT @email, .................

---

quote:

---

I'm a little suprised it tried to insert the email into the Identity field though....I would have guessed it'd be smarter than that and try and start the insert at the first open column after the indentity.

---