Re: how to create csv file in DTA

From: Kanan (anonymous_at_discussions.microsoft.com)
Date: 06/03/04

  • Next message: Sharon B: "Rename Destination Columns" 
    Date: Thu, 3 Jun 2004 12:26:03 -0700

    thanks you very much for the info. But I have a query like this. but for some reason, the last 3 columns in my select
    clause don't appear in the output csv file.

    select INTSYSTID, DATEE, cpt_code,
    MOD,COL1,COL2 ,sum(convert(int,Volume,12))
    from dwpublish..KANAN_Q12004
    group by intsystid,DATEE,cpt_code,mod,COL1,COL2
    order by intsystid,DATEE,cpt_code

    any clue would be greatly appreciated.

    thanks
    Kanan

  • Next message: Sharon B: "Rename Destination Columns"

    Relevant Pages

    • Query using ADO returns no data
      ... I know very little about Access, but got stuck trying to support it. ... received the following email and have no clue how to help. ... Query using ADO does not return data. ... clause is removed it again performs as expected. ...
      (microsoft.public.access.modulesdaovba)
    • RE: Any good T-SQL quick reference recommended?
      ... The full syntax of the SELECT ... SELECT Clause ... Specifies the columns to be returned by the query. ... Specifies that duplicate rows can appear in the result set. ...
      (microsoft.public.sqlserver.programming)
    • RE: Xlocking with a select statement
      ... named query expression, order clause, update clause, lock option ... A result table or the underlying base tables are updateable if the query ... A lock can be requested for the ...
      (microsoft.public.sqlserver.programming)
    • RE: Query Problem, Please Help!!
      ... > this table to be laid out the way it is. ... The reason that experts recommend using a query as the Record Source for a ... The query ... will allow the designer to display the data in just about any way needed. ...
      (microsoft.public.access.queries)
    • Re: VB-ADO-SQL Server : SQL Server performs logins after some queries
      ... If you have some joins or WHERE clause in your statement, ... Also try to minimize selection of the records using WHERE ... Incase of actual action query, ... >> of queries and I've concluded that in case of an internet conection the ...
      (microsoft.public.vb.database.ado)