No problem.

I can't see anything wrong either. If you replace the sp_executeSQL with Print, what's the resulting statement? (checking to see that nothing strange has snuck into the variables)

That would be true, if there wasn't a TOP 1 in each of the subqueries.

The final order of the union is undefined, but it consists of the first records in...

This however does work

select Col1, Col2 FROM

 (select top 1 Col1, Col2 from TableA order by Col2) a

UNION

select Col3, Col4 FROM

 (select top 1 Col3, Col4 from TableB order by Col4) b

How many processors does your server have?

What connection settings/SET options is the app using?

At first glance (no coffee yet) I'd guess it has something to do with the fact that you have two tables with the same alias. You have both SupplierItemAttributeValue sv...

Profiler should work. Capture the SP:StmtStarting event (under stored procedures)

Otherwise you can create a 'debugging' table and have the stored proc insert the query that it's about to execute in...

Home machine: (custom built)

Athlon 3200 XP

 1.5 GB memory

 220 GB hard drive (1x200 GB, 1x20 GB)

 DVD reader

 CD Writer

 Soundblaster Live

 GeForce 6800 LE

 17" monitor (don't have space on desk for larger)

 + accessories...

Please don't cross-post. Most people here read multiple forums.

Besides, this belongs in the Job Postings forum, not here.

This should get you what you want.

SELECT MasterTable.Name, DetailTable.Id, DetailTable.Day, DetailTable.Result, DetailTable.Campaign, DetailTable.PhoneNumber FROM DetailTable INNER JOIN

(SELECT MAX(ID) AS LatestID, PhoneNumber

   FROM DetailTable

   GROUP BY PhoneNumber) LatestEntry ON...

Could you please post the DDL of your tables and some example data? It'll make things a lot easier for us to come up with a solution.

What do you mean...

Thanks. Didn't know that the number was actually a page number.

Never seen that DBCC command before either. (even in the list of DBCC commands that I found)

Thanks.

I can't answer your conversion question, but I was faced with a similar problem a few months ago. What we decided to do was to add an additional step at the...

That works great. Thank you very much.

Would you mind explaining what/how the xpath works there?

Rather don't use the ansi_nulls setting and write your stored proc as follows

Create Procedure TestNulls

As

Begin

  Select * from T1 Where (C1=C2 OR (C1 IS NULL AND C2 IS NULL))

End

DECLARE @Value DECIMAL(8,0)

SELECT @Value = 10005555

SELECT CAST(SUBSTRING(CAST (@Value AS VARCHAR(8)),1,4) AS DECIMAL(4,0)) AS FirstHalf,

 CAST(SUBSTRING(CAST (@Value AS VARCHAR(8)),5,4) AS DECIMAL(4,0)) AS SecondHalf

HTH