yah...! actually you come across that error not from the disturbance of bulk insert or any other thing but its all because you are trying to insert data into a...

Hi.,

if u really want try pivot property in sql server then jst try this.............

select * from

(

select unique_id,parameter_name,parameter_value from dbo.MyTable

) ttbl

PIVOT

(

max(parameter_value) --in case of...