create table [dbo].[users]
[userid] [int] identity(1,1) not null,
[username] [varchar](255) not null,
constraint [pk_users] primary key clustered


create table [dbo].[links]
[linkid] [int] identity(1,1) not null,
[linkname] [varchar](255) not null,
constraint [pk_links] primary key clustered


create table [dbo].[userlinks]
[userid] [int] not null,
[linkid] [int] not null,
[repeat] [int] not null


create procedure [dbo].[sp_GetLinks]
@userid int
as
begin
set nocount on;
--here i need to be able to add one to the repeat or add to the table if doesn't exist
--plus i don't know how to add one to repeat for each row selected
select top 10 *
from links
where linkid not in
     (
      select top 10 ul.linkid
      from userlinks ul
      where ul.userid = @userid
      order by ul.repeat desc
     )
order by (newid())
end