we have a stored procedure in which we insert some data
into a temporary table

if we make a insert like :
   insert into #tmp(field1) values('aaaa')

it works fine, but if we insert data from variables like

we get an error :"check the messages
between Crystal Report and sql server"

does someone have any idea?

thanks