SET NOCOUNT ON
GO

DECLARE @user_id int
DECLARE @max_user_id int
DECLARE @max_item_id int

SELECT @max_user_id = MAX(id) FROM users
SELECT @max_item_id = MAX(item_id) FROM diggs

DECLARE @work_Table table(user_id int, friend_id int, item_id int, digdate datetime, friend_name varchar(36))

DECLARE @wanted_item_id int

DECLARE @Count int
SET @Count = 1000


WHILE (@Count > 0)
BEGIN
	SET @wanted_item_id = (RAND() * @max_item_id) + 1
	SET @user_id = RAND() * @max_user_id + 1

	INSERT INTO @work_Table
	SELECT
		@user_id, friend_id,@wanted_item_id, diggs.digdate, friends.friend_name
	FROM
		diggs
		JOIN friends ON diggs.user_id = friends.friend_id
	WHERE
		diggs.item_id = @wanted_item_id
		AND friends.user_id = @user_id
	ORDER BY 
		digdate DESC
		
	SET @Count = @Count - 1
END

SELECT * FROM @work_table