1. I just have modified my select statement a bit like iam just taking all now

means...

bcp "Select * from CurveTempDB.dbo.tLoanVectors where cusip='86359B6G1' " queryout C:\Sample.txt -T -c

for which am still...

VALEK (2/21/2008)

---

I am thinking about it, but the management would argue that I am distorting/abusing the concept of ETL, SSIS and all the rest of it.

It would be great if...

Muhammad Furqan (2/21/2008)

---

oh man ! you are missing a point.

i know about that simple query that you hace written, but problem with me is that the "table_name" and "column_name" are...

Ok... first, we have to determine precisely what the problem is... correct identification of the problem will be 90% of the solution....

1. Are you still using this exact syntax?...

It was easy for us... we had a great junk yard dog for a DBA who said "Sure... I can keep anything out that doesn't have a signed off ticket"....

I'd recommend that you post the code that doesn't work along with any error messages you may receive...

One more thing... the ticketing system should have the concept of "Parent Tickets" and "Projects" associated with it. Seriously, this is the only way to keep a handle on...

Eric Peterson (2/21/2008)

---

Does anyone have some standard forms for deployment of SQL DBs, DTS, Etc.

We need to better document user requests comming into the system and a good...

Gosh... can't you just make a linked server and write a proc that would maybe use a little dynamic SQL to just copy everything it sees on the linked server...

Yes, you can save the result set in a table by using a kind of "back door" way using a call to OSQL....

--===== Create a temp table to hold the...

Yeah... I know, I know... thanks guys...

Sticknyn... don't let them scare you off, Man... if you know a way to pass a table variable in 2k5, you've just gotta tell...

You can? And it works? Would you mind...

All I can say is, CRAP!!!!!

As pjancicka states, it works fine on 2K SP3a, and doesn't work correctly on anything after that!

Hey! Some of you MVP's...

Myschif,

Adam and the other folks are too kind with their words about my articles. The articles do, however, explain some major pitfalls with the performance of some of the...

I saw you in the post, Adam... I knew you would do as good as I could. And, thanks for the plug!