Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. nyccrystal

    Math overflow error converting to DATETIME from large textfile

    Hooray, it finally worked, using style 120: INSERT INTO CISMast ([Out_date_Billed]) select convert(datetime,out_date_billed,120) from cis_newfile where isdate(out_date_billed) = 1 Thanks, guess it was just a matter of finding the right combo of everything.
  2. nyccrystal

    Math overflow error converting to DATETIME from large textfile

    I've tried the above suggestions, and still keep getting the overflow error. Could it have anything to do with the number of records? Does SQL Server 2005 have some sort processing limitation?
  3. nyccrystal

    Math overflow error converting to DATETIME from large textfile

    I have a file of approximately a million records that was imported from a mainframe file. I'm trying to convert a field that's in a format like 20070530 - ie, YYYYMMDD, in order to be able to do date calculations on it. I don't care how it looks, I just care if internally it's a real datetime...
  4. nyccrystal

    Crystal Reports Version 9 (memo field trucates in sub reports)

    By the way, this isn't only true of subreports. I'm having the same problem with a memo field in my details section.

Part and Inventory Search

Back
Top