Split it into two select statements with Union to combine. First select for specific StyleIDs. Second select for the all encompassing styled ID (0 - though perhaps it should be...

You would need a cursor to step thru each MemberKey value, then update the table the incrementing sequence number within each MemberKey. This is done with the "... set...

Perhaps look at an alternative solution. Extract the list of year.month pairs in your data. Then loop thru each record in the result set, passing the date range as parameters...

I have now found a Microsoft KB that is similar to the condition demonstrated but is for DTS.

Found it whilst scanning kbAlertz.com newsletter of 25th Mar 2002.

Q259304 - FIX:...

My workaround was to output the whole table, then a separate output with only the last record using -L n.

When loading it back use -L n-1 from the first...

Hi again,

I forgot to mention that the script is run whilst in the pubs database. Grabs seed data from the pub_info table present in the pubs database.

Robert

Here is a set of steps used to replicate the problem.

It appears the problem only exists under the following conditions.

;- The Text field is the LAST field in the table...

Hi Antares,

Thanks for the bcp /e switch.

However I was thinking more in the line of using sp_MShelpindex or sp_helpindex to extract the fields that make up each index on each...

The error message is:

---

SQLState = 37000, NativeError = 4813

Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Expected the text

length in data stream for bulk copy of text, ntext, or image data.

BCP copy...