SQL Code Problem

USE [RohanNet]
GO
/****** Object: StoredProcedure [dbo].[BuyItem] Script Date: 06/12/2017 11:49:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[BuyItem]
@login_id nvarchar(50)
AS
BEGIN
DECLARE
@i as integer,
@counter as integer,
@user_id as INTEGER,
@row as integer,
--
@item_id as integer,
@stack as integer,
@price as integer,
@item_name as nvarchar(50),
@user_point as integer
--
Set @user_id = (Select user_id from RohanUser..TUser where login_id = @login_id)
Set @i = 0
Set @counter = (SELECT COUNT('a') FROM RohanNet..UserCart where login_id = @login_id and active = 1)
while @i < @counter
BEGIN
Set @row = (Select TOP(1)[id] from RohanNet..UserCart where login_id = @login_id and active = 1 order by id asc)
Set @item_id = (Select [item_id] from RohanNet..UserCart where id = @row)
Set @stack = (Select [quantity] from RohanNet..IM_list where item_id = @item_id)
Set @price = (Select [price] from RohanNet..IM_list where item_id = @item_id)
Set @item_name = (Select [item_name] from RohanNet..IM_list where item_id = @item_id)
Set @user_point = (Select [im_points] from RohanNet..UserInfo where login_id = @login_id)
Insert into RohanMall..TItem(type,attr,stack,rank,equip_level, equip_strength,equip_dexterity,equip_intelligence, user_id,date)
Values(@item_id,0x00,@stack,0,0,0,0,0,@user_id,GET DATE())
Insert into RohanNet..Point_Log(login_id,description,price,dat e)
Values(@login_id,'Purcharsed - #' + CAST(@item_id AS VARCHAR) + '# ' + @item_name,-@price,GETDATE())
Update RohanNet..UserInfo set im_points = @user_point - @price WHERE login_id = @login_id AND user_id = @user_id
Update RohanNet..UserCart Set active = 0 where id = @row AND login_id = @login_id
Set @i += 1
END
select @counter, @i, @user_id, @row, @item_id, @stack
END