Dwain,

Thanks. I was presenting the most simplistic example I would need to process. I was hoping once this basic query was working I would be able to increase its complexity...

sqlGDBA,

I am looking for ways to improve the response time of the query. This query takes about 30 seconds. However, this is only one of several dozen similar queries. The...

Lowell,

Yes, the item numbers are char(15) variables. The item numbers follow the format XXX-XXX-XXXX. For simplicity, I dropped the “-“ and the 10th numeric digit because it is rarely present....

Jason,

Thanks for your reply. I do not understand "the index the engine is choosing is 6 in your list (IX_GMFPick_5)". I see several indexes and a Heap. How/why did you...

Jason,

I have executed Reindex on all the indexes. Currently, fragmentation is < .02 or = 0 on every index.

I included the fields suggested in the non clustered Row Index lookup...

I will keep that in mind.

thanks.

Thanks for the additional information.

Do you think if the file is found by the stored procedure that the SQL user would also have access to the file? I do...

Found part of the error.

The format file must have a blank line at the end. I had purposely made sure there was NOT a blank line. My previous experience...

Jasmine D.

Thanks for the reply. To test the Permission theory, I ran my smaller bulk insert and the bulk insert that is the topic of this post from the same...

Jared,

Thank you that worked. I had written a Bulk Import about 2 years ago and I used that as my model. That older import (which still works) only has a...

Jared,

Thanks. That enabled me to get to the original error I needed help with. So that I didn't have to create a second post, I added the date field to...

Thanks everyone for your assistance. That should do it for me.

pat

Gullimeel,

I receive an error, "Invalid object name 'a' ".

If the ItemNo is removed from the Group By in dwain.c's solution, the correct order number is returned.

Thanks,

pat

A slight modification to dwain.c's solution works and seems simple enough.

--Remove ItemNo from the Group By

Select OrdNo

From OrdLine

where ItemNo IN ('A', 'B', 'C')

GROUP BY OrdNo

HAVING COUNT(ItemNo) = 3

Thank...

Thanks for the input.

Here is the code to create a table and populate it.

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[OrdLine](

[OrdNo] [int] NULL,

[ItemNo] [varchar](50) NULL

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

Add...