Data type conversion while uploading Help Required!!!!

• DKSINGH

  SSC Eights!

  Points: 921

  More actions

  February 4, 2005 at 1:29 am

  #65976

  Hi,

  i want to upload data in db. see what i did

  using BCP uploaded the file into temp table (varchar 8000)

  Now i have to upload whole Data into different tables depending upon condition, Here i am facing data type conversion problem... Is there any way to come out of this.

  Regards

  Raju

• Ste_P

  SSCarpal Tunnel

  Points: 4430

  More actions

  February 4, 2005 at 2:47 am

  #540632

  Hi Raju,

  A little more information is required here matey.

  What is the problem exactly and an example would be a great help to everyone else understanding.

  Have fun

  Steve

  We need men who can dream of things that never were.

• DKSINGH

  SSC Eights!

  Points: 921

  More actions

  February 4, 2005 at 3:42 am

  #540641

  Hi steve,

  You can see the link http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=159272&p=2

  This will give you the exact scenario...

  In breif i m trying to upload data from a string variable to table like

  @var = 'field1' + 'field2' + 'field3' +'filed4' .............

  I formatted like  @var = ('field1' , 'field2' , 'field3' , 'filed4'..........)

  Putting this into table... this all in character format .... but may be Datetime also.

  How to convert it dynamically.

  Thanks