Thanks everyone for the suggestions ..I will give it closer lock but if I worked on avoiding the cursors would it help solving the problem ??

Thanks

Alaa

Thanks Jeff for your reply,

I have a value for the @geninfo_id but I didn't post it ,actually I thad to take off some of the codes to just simplify it...

Hi,

my code is

-

- VARIABLES

-- Source Table Variables

Declare

 @day_notes  varchar(2500),

 @nite_notes  varchar(2500),

 @general_notes  varchar(2500),

 @info   varchar(8000),

 @bfr_tag  varchar(2000),

 @aft_tag  varchar(2000), 

 @spc_tag  varchar(200),

 @string    varchar(8000) 

-----------------------------------------------------------------------------------------------------------

-- STATIC VARIABLES

Set @bfr_tag = '{\rtf1\ansi\deff0{\fonttbl{\f0\froman Tms Rmn;}{\f1\fswiss Arial;}}{\colortbl\red0\green0\blue0;\red0\green0\blue255;\red0\green255\blue255;\red0\green255\blue0;\red255\green0\blue255;\red255\green0\blue0;\red255\green255\blue0;\red255\green255\blue255;\red0\green0\blue127;\red0\green127\blue127;\red0\green127\blue0;\red127\green0\blue127;\red127\green0\blue0;\red127\green127\blue0;\red127\green127\blue127;\red192\green192\blue192;}{\info{\creatim\yr1996\mo9\dy6\hr10\min22\sec23}{\version1}{\vern262367}}\paperw12240\paperh15840\margl360\margr3300\margt360\margb0\deftab720\pard\ql\li0\fi0\ri2992{\f1\fs20\cf5\up0\dn0 \loch\af1  '

Set @spc_tag='  }{\par}\pard\ql\tx2880{\f0\fs20\cf0\up0\dn0 \loch\af0 '

Set @aft_tag =' }{\f0\fs20\cf0\up0\dn0 \loch\af0  }}'

-----------------------------------------------------------------------------------------------------------

Set NoCount On

Declare...

I dont have any unicode datatype but I do have constant concatenation and I dont see why I shouldn't have any if I'm dumping my 3 fileds + the constant...