Revisions to exporting data from SQL query

deleted 4 characters in body

Source Link

edited Apr 18, 2023 at 19:32

3
2

I have a SQL CmdExec Job set up to run a query however the output data contains headers, job information and total numbers of returned rows as part of the output file and I am trying to figure out how to exclude this, this project calls for only the raw data to be returned.

Based on other suggestions I've tried adding "sqlcmd -Q set nocount on; " before my query as well as "-S localhost -D master -o" at the end of the query but the extra data remains in the results.

Any suggestions are greatly appreciated.

sqlcmd -Q set nocount on;   
SELECT
cast(coalesce(ARMASTER.CUSTNO, ' ') as char(20)) as [CUSTNO],
cast(coalesce(ARMASTER.INVOICE, ' ') as char(20)) as [INVNO],
cast(coalesce(ITEM.PARTNO, ' ') as char(16)) as [ITEM],
cast(coalesce(ITEM.DESCRIPT, ' ') as char(65)) as [DESCRIP],
cast(coalesce(ITEM.DISRATE, ' ') as char(7)) as [DISC],
cast(coalesce(ITEM.PRICE, ' ') as char(20)) as [PRICE],
cast(coalesce(ITEM.SHIPQTY, ' ') as char(12)) as [QTYSHP],
cast(coalesce(ITEM.TOTPRICE, ' ') as char(20)) as [EXTPRICE],
cast(coalesce(ITEM.CUSERLINE, ' ') as char(10)) as [SEQNUM]

FROM ITEM
JOIN 
armaster ON ITEM.fcinvoiceinvoice = ARMASTER.fcinvoiceinvoice

ORDER BY ARMASTER.INVOICE
-S localhost -D master -o

I have a SQL CmdExec Job set up to run a query however the output data contains headers, job information and total numbers of returned rows as part of the output file and I am trying to figure out how to exclude this, this project calls for only the raw data to be returned.

Based on other suggestions I've tried adding "sqlcmd -Q set nocount on; " before my query as well as "-S localhost -D master -o" at the end of the query but the extra data remains in the results.

Any suggestions are greatly appreciated.

sqlcmd -Q set nocount on;   
SELECT
cast(coalesce(ARMASTER.CUSTNO, ' ') as char(20)) as [CUSTNO],
cast(coalesce(ARMASTER.INVOICE, ' ') as char(20)) as [INVNO],
cast(coalesce(ITEM.PARTNO, ' ') as char(16)) as [ITEM],
cast(coalesce(ITEM.DESCRIPT, ' ') as char(65)) as [DESCRIP],
cast(coalesce(ITEM.DISRATE, ' ') as char(7)) as [DISC],
cast(coalesce(ITEM.PRICE, ' ') as char(20)) as [PRICE],
cast(coalesce(ITEM.SHIPQTY, ' ') as char(12)) as [QTYSHP],
cast(coalesce(ITEM.TOTPRICE, ' ') as char(20)) as [EXTPRICE],
cast(coalesce(ITEM.CUSERLINE, ' ') as char(10)) as [SEQNUM]

FROM ITEM
JOIN 
armaster ON ITEM.fcinvoice = ARMASTER.fcinvoice

ORDER BY ARMASTER.INVOICE
-S localhost -D master -o

I have a SQL CmdExec Job set up to run a query however the output data contains headers, job information and total numbers of returned rows as part of the output file and I am trying to figure out how to exclude this, this project calls for only the raw data to be returned.

Based on other suggestions I've tried adding "sqlcmd -Q set nocount on; " before my query as well as "-S localhost -D master -o" at the end of the query but the extra data remains in the results.

Any suggestions are greatly appreciated.

sqlcmd -Q set nocount on;   
SELECT
cast(coalesce(ARMASTER.CUSTNO, ' ') as char(20)) as [CUSTNO],
cast(coalesce(ARMASTER.INVOICE, ' ') as char(20)) as [INVNO],
cast(coalesce(ITEM.PARTNO, ' ') as char(16)) as [ITEM],
cast(coalesce(ITEM.DESCRIPT, ' ') as char(65)) as [DESCRIP],
cast(coalesce(ITEM.DISRATE, ' ') as char(7)) as [DISC],
cast(coalesce(ITEM.PRICE, ' ') as char(20)) as [PRICE],
cast(coalesce(ITEM.SHIPQTY, ' ') as char(12)) as [QTYSHP],
cast(coalesce(ITEM.TOTPRICE, ' ') as char(20)) as [EXTPRICE],
cast(coalesce(ITEM.CUSERLINE, ' ') as char(10)) as [SEQNUM]

FROM ITEM
JOIN 
armaster ON ITEM.invoice = ARMASTER.invoice

ORDER BY ARMASTER.INVOICE
-S localhost -D master -o

edited body

Source Link

edited Apr 18, 2023 at 19:31

theHydra

3
2

I have a SQL CmdExec Job set up to run a query however the output data contains headers, job information and total numbers of returned rows as part of the output file and I am trying to figure out how to exclude this, this project calls for only the raw data to be returned.

Based on other suggestions I've tried adding "sqlcmd -Q set nocount on; " before my query as well as "-S localhost -D master -o" at the end of the query but the extra data remains in the results.

Any suggestions are greatly appreciated.

sqlcmd -Q set nocount on;   
SELECT
cast(coalesce(ARMASTER.CUSTNO, ' ') as char(20)) as [CUSTNO],
cast(coalesce(ARMASTER.INVOICE, ' ') as char(20)) as [INVNO],
cast(coalesce(ITEM.PARTNO, ' ') as char(16)) as [ITEM],
cast(coalesce(ITEM.DESCRIPT, ' ') as char(65)) as [DESCRIP],
cast(coalesce(ITEM.DISRATE, ' ') as char(7)) as [DISC],
cast(coalesce(ITEM.PRICE, ' ') as char(20)) as [PRICE],
cast(coalesce(ITEM.SHIPQTY, ' ') as char(12)) as [QTYSHP],
cast(coalesce(ITEM.TOTPRICE, ' ') as char(20)) as [EXTPRICE],
cast(coalesce(ITEM.CUSERLINE, ' ') as char(10)) as [SEQNUM]

FROM ITEM
JOIN 
armaster ON ITEM.fcinvoice = ARMASTER.fcinvoice

ORDER BY ARMASTARMASTER.FCINVOICEINVOICE
-S localhost -D master -o

I have a SQL CmdExec Job set up to run a query however the output data contains headers, job information and total numbers of returned rows as part of the output file and I am trying to figure out how to exclude this, this project calls for only the raw data to be returned.

Based on other suggestions I've tried adding "sqlcmd -Q set nocount on; " before my query as well as "-S localhost -D master -o" at the end of the query but the extra data remains in the results.

Any suggestions are greatly appreciated.

sqlcmd -Q set nocount on;   
SELECT
cast(coalesce(ARMASTER.CUSTNO, ' ') as char(20)) as [CUSTNO],
cast(coalesce(ARMASTER.INVOICE, ' ') as char(20)) as [INVNO],
cast(coalesce(ITEM.PARTNO, ' ') as char(16)) as [ITEM],
cast(coalesce(ITEM.DESCRIPT, ' ') as char(65)) as [DESCRIP],
cast(coalesce(ITEM.DISRATE, ' ') as char(7)) as [DISC],
cast(coalesce(ITEM.PRICE, ' ') as char(20)) as [PRICE],
cast(coalesce(ITEM.SHIPQTY, ' ') as char(12)) as [QTYSHP],
cast(coalesce(ITEM.TOTPRICE, ' ') as char(20)) as [EXTPRICE],
cast(coalesce(ITEM.CUSERLINE, ' ') as char(10)) as [SEQNUM]

FROM ITEM
JOIN 
armaster ON ITEM.fcinvoice = ARMASTER.fcinvoice

ORDER BY ARMAST.FCINVOICE
-S localhost -D master -o

I have a SQL CmdExec Job set up to run a query however the output data contains headers, job information and total numbers of returned rows as part of the output file and I am trying to figure out how to exclude this, this project calls for only the raw data to be returned.

Based on other suggestions I've tried adding "sqlcmd -Q set nocount on; " before my query as well as "-S localhost -D master -o" at the end of the query but the extra data remains in the results.

Any suggestions are greatly appreciated.

sqlcmd -Q set nocount on;   
SELECT
cast(coalesce(ARMASTER.CUSTNO, ' ') as char(20)) as [CUSTNO],
cast(coalesce(ARMASTER.INVOICE, ' ') as char(20)) as [INVNO],
cast(coalesce(ITEM.PARTNO, ' ') as char(16)) as [ITEM],
cast(coalesce(ITEM.DESCRIPT, ' ') as char(65)) as [DESCRIP],
cast(coalesce(ITEM.DISRATE, ' ') as char(7)) as [DISC],
cast(coalesce(ITEM.PRICE, ' ') as char(20)) as [PRICE],
cast(coalesce(ITEM.SHIPQTY, ' ') as char(12)) as [QTYSHP],
cast(coalesce(ITEM.TOTPRICE, ' ') as char(20)) as [EXTPRICE],
cast(coalesce(ITEM.CUSERLINE, ' ') as char(10)) as [SEQNUM]

FROM ITEM
JOIN 
armaster ON ITEM.fcinvoice = ARMASTER.fcinvoice

ORDER BY ARMASTER.INVOICE
-S localhost -D master -o

added 784 characters in body

Source Link

edited Apr 18, 2023 at 18:45

theHydra

3
2

I have a SQL CmdExec Job set up to run a query however the output data contains headers, job information and total numbers of returned rows as part of the output file and I am trying to figure out how to exclude this, this project calls for only the raw data to be returned.

Based on other suggestions I've tried adding "sqlcmd -Q set nocount on; " before my query as well as "-S localhost -D master -o" at the end of the query but the extra data remains in the results.

Any suggestions are greatly appreciated.

sqlcmd -Q set nocount on;   
SELECT
cast(coalesce(ARMASTER.CUSTNO, ' ') as char(20)) as [CUSTNO],
cast(coalesce(ARMASTER.INVOICE, ' ') as char(20)) as [INVNO],
cast(coalesce(ITEM.PARTNO, ' ') as char(16)) as [ITEM],
cast(coalesce(ITEM.DESCRIPT, ' ') as char(65)) as [DESCRIP],
cast(coalesce(ITEM.DISRATE, ' ') as char(7)) as [DISC],
cast(coalesce(ITEM.PRICE, ' ') as char(20)) as [PRICE],
cast(coalesce(ITEM.SHIPQTY, ' ') as char(12)) as [QTYSHP],
cast(coalesce(ITEM.TOTPRICE, ' ') as char(20)) as [EXTPRICE],
cast(coalesce(ITEM.CUSERLINE, ' ') as char(10)) as [SEQNUM]

FROM ITEM
JOIN 
armaster ON ITEM.fcinvoice = ARMASTER.fcinvoice

ORDER BY ARMAST.FCINVOICE
-S localhost -D master -o

I have a SQL CmdExec Job set up to run a query however the output data contains headers, job information and total numbers of returned rows as part of the output file and I am trying to figure out how to exclude this, this project calls for only the raw data to be returned.

Based on other suggestions I've tried adding "sqlcmd -Q set nocount on; " before my query as well as "-S localhost -D master -o" at the end of the query but the extra data remains in the results.

Any suggestions are greatly appreciated.

I have a SQL CmdExec Job set up to run a query however the output data contains headers, job information and total numbers of returned rows as part of the output file and I am trying to figure out how to exclude this, this project calls for only the raw data to be returned.

Based on other suggestions I've tried adding "sqlcmd -Q set nocount on; " before my query as well as "-S localhost -D master -o" at the end of the query but the extra data remains in the results.

Any suggestions are greatly appreciated.

sqlcmd -Q set nocount on;   
SELECT
cast(coalesce(ARMASTER.CUSTNO, ' ') as char(20)) as [CUSTNO],
cast(coalesce(ARMASTER.INVOICE, ' ') as char(20)) as [INVNO],
cast(coalesce(ITEM.PARTNO, ' ') as char(16)) as [ITEM],
cast(coalesce(ITEM.DESCRIPT, ' ') as char(65)) as [DESCRIP],
cast(coalesce(ITEM.DISRATE, ' ') as char(7)) as [DISC],
cast(coalesce(ITEM.PRICE, ' ') as char(20)) as [PRICE],
cast(coalesce(ITEM.SHIPQTY, ' ') as char(12)) as [QTYSHP],
cast(coalesce(ITEM.TOTPRICE, ' ') as char(20)) as [EXTPRICE],
cast(coalesce(ITEM.CUSERLINE, ' ') as char(10)) as [SEQNUM]

FROM ITEM
JOIN 
armaster ON ITEM.fcinvoice = ARMASTER.fcinvoice

ORDER BY ARMAST.FCINVOICE
-S localhost -D master -o

added 8 characters in body

Source Link

edited Apr 18, 2023 at 15:12

theHydra

3
2

Loading

Source Link

asked Apr 18, 2023 at 14:40

theHydra

3
2

Loading

Stack Exchange Network

Return to Question