Need help with conversion

Question

Hi,

 

I am trying to make better performance in our sql statements. We have problems with som queries that has slow performance. It seems regarding to the sql server  estimated execution plan that the problem is implicit conversion.

 

This is my query;

 

select   abbreviation + CONVERT(varchar(23), beginTimestamp, 121) as partof

from      customer

 

abbreviation is a varchar field

beginTimestamp is a timestamp

 

and those two fields I wan't to concatenate in to one field.

In estimated execution plan I got a warning that says:  type conversion in expression (CONVERT (varchar(23), beginTimestamp, 121) may affect CardinalityEstimate in query plan choise.

 

Maybee some one can help me with this!