Well, you can have the query designer show you the actual query generated to see if it is using inner joins or cross joins.  My guess is that it is...

First, Do you always run the query for a specific PKG.Shipment_No?

Second, could you please post the execution plan?

You have a hypothetical index in the list on the right.  It isn't a real index  Google search the following: MS SQL Server hypothetical indexes

• This reply was modified 4 years, 9 months ago by Lynn Pettis.

Pretty...

Well, if Green Machine doesn't fix his lineup before games start tomorrow I have no chance of sneaking in to the playoffs in 6th place.  Of course I still have...

Or you are doing date arithmetic and the resulting value exceeds the range for date/time data type you are using.

I have a major problem with ego-maniacs that like to hijack meetings. Which is what we had here. I asked for a few practice tests so I can prepare...

Just a suggestion, when dealing with dates it would be best if you used the ISO standard YYYYMMDD and not your regional standard as that can be ambiguous.  When you...

I almost started to answer this until I saw the /sarcasm tag you included.  Of course I have been up all night since I was sleeping on and...

I must admit, I tire of seeing the same questions on SO day in day out at times, along with the lack of people that have heard of a...

If I understand SO correctly, all they want is an answer, not necessarily the best answer.  Also, don't try and have a discussion as they will shut you down.

Weird, the message above is not the message in the email notification which is this:

My new goal is to come up with...

Well, the past two days have been unique.  Started with a call in the morning from a recruiter about a possible position. After a short discussion it was determined that...

Take what Jeff is saying to heart.  I consider him one of my mentors here on sqlservercentral.com and have known him for over 15 years and finally met him in...

Also, I answered saying create a NEW column with a new name using the BIGINT data type with nullable column or a default value, drop the old column, then rename...