case when riskno=8

then dateadd(day,30,riskdt)

else dateadd(day,90,riskdt)

end as duedate

try this.

while inserting dont use the column which is identity specific.

for eg: here company id is specified as auto-incremental.

insert into tablename (companyname,Companyaddress) VALUES(@cname,@cadd).

This will auto increment a number in the...