You...

You actually named a table "OrderLookup" to hold Purchase Orders and gave it a Primary Key on a column called...

Will C2 Auditing help in this area?

Ummmm... let me get this straight... you got a job as a designer and you don't really know how to design?

SELECT CAST('2007' AS DATETIME)

SELECT DATEADD(yy,1,CAST('2007' AS DATETIME))

Oral meds? Lucky... at least they weren't supositories 😉

michael.esposito (3/10/2008)

---

Thanks all...but it seems BCP and BULK INSERT require the data to come from data files, not an instance of SQL. Is there a way to copy it from...

Could be done in plain ol' T-SQL... but would require either a trip through xp_CmdShell or would need to be called externally in a batch file.

Heh... yeah... I can see that... my question would be why? And if what you say were true, why list all of the users instead of just the most...

Markus2006 (3/10/2008)

---

In the first version I was using native format but than I found out that national charactes are not transferred correctly despite the fact that I provided correct code...

nicolas.pages (3/10/2008)

---

All right, thanks for that answer. The only thing is I am using sql server 2000, so i need to look if pivoting tables is possible there, but i...

Well? Does it do what you want, now?

You explained what you're doing but not why... I'm still worried that you're building RBAR. If it's for a GUI, probably...

Lookup RAISERROR in Books Online... that should do it.

If the rest of the query is correct for it, yes.

Ajay Varma (3/10/2008)

---

hi ...

I have understand u r problem...

while exporting table data to text file ,

we get the Text Qualifier drop down list with options like double quote,single quote ,none...