Another SQL question

[DaShen]

INSERT INTO dbo.CHRONO
(SPN, DateActivity, DateEntry, Act_Type_Primary, Act_Type_Secondary, NxtRptDate, NxtRptTime, POI, Creator)
SELECT SPN, DateActivity, DateEntry, Act_Type_Primary, Act_Type_Secondary, NextRptDate, NxtRptTime, POI, Creator
FROM dbo.ChronoFileArchive
WHERE (NOT (Act_Type_Secondary IS NULL))

Act_Type_Secondary is a varchar of [8000] and there are over 200,000 rows.

It seems the string data wold be truncated, so it does not perform the Insertion.

I was given the go ahead to use the Row ID instead of the Time Stamp. Now I am trying to take the flat file and move it to a more constructed database. The procedure won't even run, although I know that the SQL statement is correct. Any workarounds on this problem. I am running this off of a test box, so resources are not a problem. Any ideas?

 

[sigs3gv]

Wrong forum?

 

[fbrdphreak]

Heh, way wrong 😉