Search results for query: *

I need some help with this problem it's driving me crazy. I have a Bulk Insert statement which uses a format file. Everything works fine except the application I'm exporting the text file from creates a eof marker at the end of the text file. This cause the Bulk Insert to fail with an...

O.K. Found the problem...The problem is that using an ORDER BY in the select statement causes an implicit conversion of the cursor from Dynamic to Static... Check out this link... http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_con_07_66sz.asp Thanks for your help...

I really just simplified this code to explain my point but in this code. Let's say there are 10 records and the last record has the date 9/24/2002, and it is the only record with date 9/24/2002. This is why I'm using fetch last. We could assume that the result of the select is one record...

Adding the Fetch_Status = 0 has no effect...Update is still not shown in the cursor...Were you thinking that the second fetch was failing?

I'm having a bit of a problem using a dynamic cursor where I update the underlying data but the cursor does not show the update on the second fetch. Although books can be incorrect the following sysntax is just as it is shown in the book I have: If original value of flag is 'A' Declare @date...

Yeah, that was obvious to me...Why would I want to create a foreign key relationship that doesn't enforce replication. As it relates to query performance my query is much more efficient with the foreign key established with this box unchecked. I'm obviously violating textbook normalization...

If you look at the properties of a foreign key relationship in a diagram there is a check box for "Enforce Relationship for Inserts and Updates."When I do a CREATE TABLE and add a foreign key constraint I want to have this box unchecked. In my Create I include ON UPDATE NO ACTION, ON...