You need to define the submissionbatch you want to return if there is more than one. You could either use MIN(),MAX(),SUM() or any other aggregation you like.

But then you'd need...

Here's a script to query the data per SQL instance:

EXECUTE sp_msforeachdb 'USE ? SELECT DB_NAME(); SELECT *

FROM sys.extended_properties'

Is it possible the Excel file is still open (= in use by another application)?

You could use

Select DISTINCT a.*,b.SubmissionBatchID

If you still get more than 2219944 then you have more than one distinct value of b.SubmissionBatchID per submissionID.

As a side note: I...

Would you please be a little more specific? What error message (exactly) do you get?

@SUPER SQL STAR:

May I kindly ask you to change your avatar?

The avatar you're using at the moment is connected to WayneS since "ages"...

Ninja's_RGR'us (3/29/2011)

---

LutzM (3/29/2011)

---

Please ask your tutor to rephrase this question. It will make it easier for you to google for...

Please ask your tutor to rephrase this question. It will make it easier for you to google for an answer...

[SET...

Are you sure this qustion belongs to a SQL forum? :ermm:

Probably better to ask in a C# forum...

Wouldn't it be also an option just to remove the redundant CASE expression?

Something like

CASE

...

Did you try the good old Divide'n'Conquer approach?

As far as I see each subquery is limited by at least the TaskId = @TaskId condition, so you'd end up with smaller...

mattias 58533 (3/28/2011)

---

Hi all experts!

I have a machine that needs to be tuned perfectly.

My questions: Are there any good sources/ebooks how to do this from the start?

We don't have any...

You don't really expect us to analyze over 3000 lines in French(?), do you?

It would be much more helpful if you could describe the kind of performance problems you're dealing...

That's just part of the stuff Wayne asked for...

Please provide table def and sample data for dbo.MRec_Gather_Med_Reconcilation_1 as well as your expected output.

I would recommend to unpivot your table. While doing so, you should adjust the column size and/or data type (I don't think NVARCHAR(255) is an appropriate data type). Maybe even...