MSSQL Stored Proc

while (@rowCount <= @maxRecordCount )BEGIN	set @filld = (select filled from buckets where bucket_time = '3/2/2007 12:30:00 PM')	select @c_SID=student_id from Improved_docket_tmpins where rowId = @rowCount	insert into dockets	select * from dockets_tmpins	where student_id = @c_SID	-- Name split logic		select @name=First_Name from Improved_docket_tmpins where student_id = @c_SID	select @lname=item from fnSplit(@name,',') where colId=1	select @tmp_name=item from fnSplit(@name,',') where colId=2	select @fname=item from fnSplit(@tmp_name,' ') where colId=1	select @mname=item from fnSplit(@tmp_name,' ') where colId=2	-- update the entries			update dockets 		set 	status='DOCKETED', 			status_date=getdate(),			interviewer_rating = 0,			committee_rating =0,			first_name = @fname,			middle_name = @mname,			last_name = @lname,			local_street1 = perm_street1,			local_street2 = perm_street2,			local_city = perm_city,			local_state  = perm_state,			local_zip = perm_zip,			local_phone = perm_phone,			local_email = perm_email	where student_ID = @c_SID	-- Call the stored proc to assign the meeting date	exec Assign_meeting_date @c_SID	set @name = ''	set @fname = ''	set @mname = ''	set @tmp_name = ''	set @lname = ''	set @rowCount = @rowCount + 1	ENDdelete from Improved_docket_tmpinsdrop table Improved_docket_tmpins--delete from dockets_tmpinsGO