I am trying to display the following output from this simple query which writes to a file to display the output horizontally instead of vertically. Is this doable? Below is my query and the current results along with an example of how I would like for it to be displayed. Hoping someone can help. thanks for your time in advance.
Query which writes to a file: Print 'Report AsofDate:' select top 1 convert(varchar,asof_dt,101) from sbc_bdi_db.dbo.Temp999
Results from above query Are:
Report AsofDate: ---------------- 05/31/2013
I would like to results to look like this instead: