using ignore duplicate index causing problems for Ole db

FAQ

Profile

using ignore duplicate index causing problems for Ole db

Database Help (Home) -> Programming

Next: End of Day, Get 11:59:59PM this evening.

Author

Message

tonybaloneyman

External

Since: May 01, 2008
Posts: 1

(Msg. 1) Posted: Thu May 01, 2008 1:34 pm Post subject: using ignore duplicate index causing problems for Ole db Archived from groups: microsoft>public>sqlserver>programming (more info?)

I have a stored procedure that builds a temp table to filter duplicates before selecting the records I want. The filter is to get the first maximum value in any year. The duplicate key ignored message is returned along with the rows. Ole db sees a return code of db_e_integrityviolation and doesn't appear to have the rowset.(I'm not a C++ programmer, but this is what they tell me) . I read that the IsqlServerErrorInfo interface makes it possible to filter out messages from errors, but how do we get around the return code to get the data? Thanks Anthony >> Stay informed about: using ignore duplicate index causing problems for Ole db

Display posts from previous:

Related Topics:

Ignore Index - How do I specify in a SELECT statement not to use an index? I have a non-clustered index on a column and I do not want to use it so that I can demonstrate how long it will take to execute without the index. I do not want to drop and/or disable the..

Ignore space and dash in search -

select between dates ignore error - i ve got below sp -------------------------------- ALTER PROCEDURE [dbo].[selectBetweenDays] @affid varchar(50), @firstdate varchar(8), @seconddate varchar(8) AS BEGIN SET NOCOUNT ON; SELECT * FROM sales WHERE payTIME >= @firstdate AND payTIME &lt...

Where clause ignore 2nd test - Using Sql Server 2005, I have a query with 2 tests. What I want to do is make sure that if the first test is true, the 2nd test is not even done. SELECT @ApprID=ApprID FROM Apprs WHERE (FileName = @FileName OR FileNumber = @FileNumber) In the above,....

Causing a row in SELECT Statement to appear multiple times. - I'm trying to create a select statement which would allow a given row to appear in the result of an SQL statement multiple times. The number of times the row would appear is based on a field in the row (numEntries). The reasoning behind this is that we..

	Database Help (Home) -> Programming	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum