Output To a CSV file

• Dave Bailey

  SSC Veteran

  Points: 216

  More actions

  October 31, 2005 at 6:50 am

  #95620

  I have the following query:

   

  select linecost, issuetype, gldebitacct, glcreditacct

  from matusetrans

  where it1 <> 'Y' or it1 is null

  and issuetype in ('ISSUE', 'RETURN')

  and storeloc in ('B631OT', 'B642GB', 'B641GB', 'B681AS', 'B681BS', 'B681CA', 'B681SP'

   

  For each record returned I would Like to add a column named RECTYPE with a default value of "L".  In addition, I would also like to add a column named JEENTRYNO with values that start at 1 and increase by one for each row returned.  I don't want to keep the information in a table but output this information to a csv file for use somewhere else.  Can someone help me with the stored procedure syntax necessary to perform this action?

  Thanks,

  Dave

• rsharma

  SSCarpal Tunnel

  Points: 4865

  More actions

  October 31, 2005 at 7:43 am

  #601293

  Please do not cross-post...see the solution on:

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=233769#bm233777