DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 14

Thread: Using SQL to create a flat file and Sequences

Threaded View

  1. #10
    Join Date
    Aug 2003
    Posts
    100
    Interesting... there are 2 lines in the output file. I then spooled my query out to a file with no luck. I've attached the resulting file.

    Could it be because the first part of the query that produces the 'H'eader record does not join to the ITEM table like the second part that produces the 'P' record does?

    Thanks for all your help!
    Last edited by ssmith001; 11-03-2003 at 01:08 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width