Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

  • RE: Charindex() in Import/Export wizard

    I've found the answer to this.

    It appears that the Import/Export wizard uses the Access database engine and so the Access dialect of SQL has to be used. This means that...

    January 4, 2012 at 5:37 am

    #1428218

  • RE: Charindex() in Import/Export wizard

    bwoulfe (12/20/2011)

    Can you import the data into a staging table, do your data cleanup, and then insert the data into your intended target table?

    That's what I've always done when inserting...

    December 21, 2011 at 3:04 am

    #1424100

  • RE: Charindex() in Import/Export wizard

    nellisjp (12/20/2011)

    Just a stab in the dark - what data type is the column being cast to? If it's text (not varchar or char), the left function won't work.

    The...

    December 21, 2011 at 2:51 am

    #1424094

  • RE: Help with query

    Hi Ram

    I'm not in a position to try this at the moment but you could try making your query a sub-query as follows

    select count(*) from (your query here)

    Hope this helps

    Dave

    December 19, 2011 at 9:46 am

    #1423184

Viewing 4 posts - 1 through 4 (of 4 total)