I am exporting records by using Stored procedure. The master table contains many coulmns, I needed to export all master table columns (10 columns) into .dat file,
eg of the master table.,
Column names: FirstName, LastName, Address, Phone, Pin
so all these result set sould be pipe delimited in the .dat file.,
SELECT ISNULL(FirstName,'') + CHAR(124) + ISNULL(LAstName,'')+ CHAR(124) +ISNULL(Address,'')+ CHAR(124) +ISNULL(Phone,'') from table.
A ship in the harbour is safe . . . but that's not what ships were made for.