Viewing 15 posts - 1 through 15 (of 21 total)
Is that going to be "or" or "and"? If its and, more trouble :w00t:
April 17, 2008 at 10:18 pm
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...
April 17, 2008 at 6:53 pm
We cannot use aggregate functions when using schemabinding.
April 6, 2008 at 12:06 pm
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...
March 25, 2008 at 9:56 am
If joining columns are not present in both streams, you can choose to ignore the columns. It will be considered as nulls instead.
March 13, 2008 at 1:40 pm
Could you try giving full access to that network share for your user id.
March 13, 2008 at 1:35 pm
Attached a sample with ADO.net and OLEDB samples. Hope this helps.
You can check this link for more detailed information
March 13, 2008 at 1:32 pm
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...
March 12, 2008 at 1:39 am
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...
March 12, 2008 at 12:04 am
If visual studio is available, you could always use it to debug the SP. My 2 cents.
March 11, 2008 at 8:55 pm
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)...
March 11, 2008 at 4:08 pm
Aggregate in the sense concatenate rows? Or :unsure:
March 11, 2008 at 4:04 pm
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.
March 11, 2008 at 3:57 pm
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,...
March 10, 2008 at 9:28 pm
Viewing 15 posts - 1 through 15 (of 21 total)