You actually posted the way to export a query and the link specifies all the options available.

Maybe you found this version more readable.

To copy the previous version is really easy....

It would be something like

EXEC xp_cmdshell 'BCP.exe "Test.dbo.Table" Out "C:\Table.csv" -c -t"****%*****" -SMyTestServer -T -m10 -e"C:\Table.err" -o"C:\Table.out"'

I linked the article on bcp utility in my previous post. It will...

That code is from Sybase.

To export to csv, you need to use the bcp utility. If you want to call it from SSMS, you have to use xp_cmdshell.

Enjoy the trip as you might...

Jeff Moden (2/26/2015)

---

Moin Ul Haque (2/26/2015)

---

Jeff Moden (2/25/2015)

---

Moin Ul Haque (2/25/2015)

---

I can quote my own experience here - Out of need, I was asked to develop a database maintenance solution...

Something like this?

WITH SampleData AS(

SELECT 'DANIEL SHAFFERS, INCORPORATED.' AS CompanyName UNION ALL

SELECT 'BUFFETS, INCORPOR. ' UNION ALL

SELECT 'WAYNE,...

No, column order is irrelevant.

Also does order of columns matter in join...

When you included the column from table2 in the WHERE clause, you converted your OUTER JOIN into an INNER JOIN.

This articles explains what happened: http://www.sqlservercentral.com/articles/T-SQL/93039/

And here's an example of how...

Lynn Pettis (2/26/2015)

---

Yes, I should get one...

I'm not sure what you're talking about. Can you be more explicit? Where do you want to display the column alias?

Sean Lange (2/26/2015)

---

Stewart "Arturius" Campbell (2/26/2015)

---

Sean Lange (2/26/2015)

---

BWFC (2/26/2015)

---

Sean Lange (2/26/2015)

---

There was no alternative other than 42 given the context of the question. I didn't even read the question before...

I'm not sure what you're doing or how you're getting that. Maybe you have an empty column at the end which simulates a trailing comma.

Using this code, I didn't got...

Are you using a format file?

Could you post the bcp command that you're using (obfuscating paths and filenames)?

This is a possible option.

CREATE TABLE SetsItems(

SetId int,

ItemCode varchar(10))

INSERT INTO SetsItems

SELECT 1,'A' UNION ALL

...

Sean Lange (2/25/2015)

---

I didn't look at the new sample data until after you posted Luis. I assumed this was the very common "I have data that is mangled all over...