skb 44459 (3/18/2013)
Command to run
Exec Rpt_OrderReport '1/1/2013' , '1/31/2013'
Need a code which will save the output to Text file with headers and column data pipe (|) seperated.
Why not use SSIS? You can try bcp out, if your sp is trivial select (not using temp tables) then it will also work without changes in sp.
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]