I have just received this note: 

“Dear Farlly, you and your Family is very nice. ...

ROFLOL   

(I will note that for future reference...) 

SELECT CONVERT( varchar, SomeDate, 101) FROM SomeTable.  This uses a function as does Remi's [RGR'us] and it is SET BASED. 

Think of this solution in the same manner... (ssshhhh..., don't mention...

I am a bit lost on this statement:

--add rabies tag service

EXEC @return = AddService @animalID=@animalID, @serviceID=@serviceID

Might you want to be using

--add rabies tag service

SELECT @return = AddService

Tested it and it needed a couple of 'slight' tweaks:

DECLARE @TableSource TABLE( [File] varchar(5),

                                           Extension varchar(5),

                                           Version integer, 

                                          Type varchar(10))

INSERT INTO @TableSource

SELECT 'AA',...

See if this helps....

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=228725#bm229100

AAAAAgreed!  I cannot believe that people in positions of authority often write so poorly!   Obviously, they are not checking their own work, yet they will most assuredly, (I checked this...

Yeah..., I did kind of sidetrack us.  I agree with RGR'us. 

OMG!  Was it that long ago?  I am getting old...   

I was in Raleigh, (250 miles inland) and it whalopped us!  We had...

  Oh...., so devout aetheists?  Are they in the same category? 

Thanks PW.  I am set in my ways did not know this...  I will use this approach now...

Why did you chose Dynamic?  Try Fast_Forward and see if it works....

(made a quick read about Dynamic in BOL and not sure if the Commit Transaction is causing the...

DECLARE CURSOR

Defines the attributes of a Transact-SQL server cursor, such as its scrolling behavior and the query used to build the result set on which the cursor operates. DECLARE...

Except I have it backwards...  Oh, dopey me....  

Glad this helps...

Post the code for the Cursor, it may be declared as non-compliant with what you want to do.  (My guess is, you may not need a Cursor).