Is that going to be "or" or "and"? If its and, more trouble :w00t:

Try this stored procedure, bit complicated though. If you pass itemname, it will return order details for that particular item, or else it will return for all orders.

Create Procedure Usp_OrderDetails...

We cannot use aggregate functions when using schemabinding.

Yea, Right my bad :hehe: Thanks

Once every month.

Unload the file, do some processing, truncate the table, load file back to the table.

I'm not sure how i would implement this with bulkcopy. I have to...

If joining columns are not present in both streams, you can choose to ignore the columns. It will be considered as nulls instead.

Could you try giving full access to that network share for your user id.

Attached a sample with ADO.net and OLEDB samples. Hope this helps.

You can check this link for more detailed information

http://technet.microsoft.com/en-us/library/ms141003.aspx

In parameter name, I think you have to mention the parameters from SP.

For e.g

if your SP is something like this

ODS_VLD_Header (@Parm1 Int,@parm2 Int.. etc)

You would need to mention @Parm1,@Parm2 under...

1) Is this query looking to gain an aggregate of the AVG of BOTH the Categories and Products table column CategoryID?

Its doing an avg of UnitPrice column

2) What exactly is...

If visual studio is available, you could always use it to debug the SP. My 2 cents.

Do you have any hex 0'x in the beginning of the data? If theres x00, the data wont get displayed correctly. This can be verified using a simple convert.

select convert(binary,columnname)...

Aggregate in the sense concatenate rows? Or :unsure:

We had some performance issues in our production database. Microsoft did health checkup and they have been highly recommending us to move to a 64bit setup. My 2 cents.

Is it required to store the country codes as well? If not, you could store the right most 10 digits, that will give the phone number, right? By the way,...