I can't think of any way to generate the extra record that duplicates information from what would be the "previous" record, and have it happen in a query. You could do this with a cursor, but a VBScript might be faster if the number of records of varchar information is large. An SSIS package might be in order...