I would also avoid the four round trips to tblAdContactInfo:

;

WITH cte AS

(

SELECT [Value],ContactTypeId

FROM tblAdContactInfo

WHERE AdInfoId=@AdInfoId AND ContactTypeId IN (5,6,7,8)

)

Select

@Building= MAX(CASE WHEN ContactTypeId = 5 THEN [Value] ELSE NULL...

Given the table structure you posted there's no way to find the rows that should match.

Let's assume there are four rows, all having the same values for Server,LogDate,ProcessInfo.

How would you...

Without knowing the table structure it's hard to tell what needs to be changee in the code snippet I provided.

I'm sure it can be modified to meet your criteria.

Theory first:

In a table, there is no natural "above" or "below". It all depends on the ORDER BY criteria.

Ok, end of theory. Unfortunately, the wErrorLog table in the link you...

The examples you mentioned usually refer to data transfer or database recovery.

Data migration usually involves two different systems (e.g. two different SQL server versions or to migrate from Oracle to...

It's a rather vague description o what you're trying to do. So the answer will be vague, too:

You could use the OUTPUT clause together with the first statement to capture...

Here are some resources for cte:

BooksOnLine and a article[/url] here at SSC.

and ROW_NUMBER

BooksOnLine and a related article

Did you try the code I posted?

I'm not sure if my approach is waht you're lloking for, but I think the ROW_NUMBER approach will help here:

;

WITH cte AS

(

SELECT

Student_ID,

Exam_ID,

Admission_Exam_Code,

Admission_Exam,

Admission_Exam_Type,

Admission_Exam_Date,

Admission_Exam_Score,

ROW_NUMBER() OVER(PARTITION BY Student_ID,Exam_ID ORDER BY Admission_Exam_Date desc...

To expand on what Gail already recommended:

Even though there might be objects that never show up you'll need to investigate the purpose of each of those objects. Some might be...

Is this still the same issue as the one you posted a few days ago?

Something like this?

SELECT

t1.col_1 AS col_1a,

t2.col_1 AS col_1b

FROM SourceTbl t1

INNER JOIN SourceTbl t2

ON t1.col_2=t2.col_2

AND t1.col_3=t2.col_3

AND t1.col_1<>t2.col_1

Are you looking for something like the following code snippet?

I decided to use a solution that is based on a given @Fname parameter.

I would wrap this code in a separate...

I'm just wondering if he's interested in learning this stuff since he's been missing it...

Why not create the xml structure without the namespace reference, but with the nil element and replace < sourcename > with < sourcename xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" > and nil="true" with "xsi:nil="true" ?

Edit:...