i think i found it.

http://blog.sqlauthority.com/2008/08/31/sql-server-table-valued-parameters-in-sql-server-2008/

u'r right. It's more of an excercise for my team. It wont be used in production environment. Theying to convert something they do everyday into a "generic" proc call.

So,...

sounds like something from a school lesson. gotta give the kid props for using availible resources.

another option. particularly effective if there is an index on the column in the contraint. Customerid in this instance. Prob better than the cross apply though.

SELECT c.CustomerID, o.OrderDate,

(...

excellent. thank u

thanks guys

here's an example of what i'm trying to do. I'm getting an "Error converting data type nvarchar to int." error. i want the script to be smart enough so that...

u should use perameterized dynamic sql to get away from the sql injection

sorry. dont know what i was thinking. it isnt rolling back any updates from previous loops. please disregard

that stinks. i'm scared to run a trace for an extended period of time too. The issue doesn't happen every day.

Oh well. Thanks.

would they be on the app logs on the sql box perhaps?

thats it. the sql service on this specific box is running off the local system instead of domain account therefore it can acces the share. It doesnt surprise me. This...

does the sql account have permissions to the shared folder?

Do you mean the sql account i'm logged in as when running the bcp? Or the account the sql...

looking at an old post i see where someone posted the below

=============================

Run

exec master..xp_fixeddrives

What is the result?

==============================

when i do this the mapped drive i created doesnt show.

interesting stuff. Thanks guys.....