I've been studying your solutions mate - finally saw the light 😛

You've posted a third method for resolving this job, late on a...

lmu92 (3/6/2010)

---

I'm by far not at the level of Jeff...

Here's a CROSS APPLY version of Jeff's derived table solution:

drop TABLE #AAATable

CREATE TABLE #AAATable(

[col1] [int] NULL,

...

There are two distinct stages to this problem, data selection, then transformation. This query makes a start on data selection based on Lutz' suggestion of using ROW_NUMBER():

DROP table #Accounts

create table...

TOP1, preferably with ORDER BY regardless of whether or not the returned values are the same. Just good practice.

Run this part:

select adminpermission from appadmin where addId=1

If the returned values are different, then you will have to decide which to use, using MIN()/MAX() or ROW_NUMBER() with OVER() or GROUP...

lmu92 (3/2/2010)

---

Why not joining the temp table directly to the query?

Something like

SELECT *

FROM cElements A

LEFT JOIN sectionList D ON D.sectionID = A.sectionID

LEFT JOIN fList E ON E.fID...

Magy (3/2/2010)

---

It is an ugly query...I know

In English it would be like:

Is 2006 in the temp table? Then add this to the query....

Is 2007 in the temp table? ...

Pritesh, I know you've provided sample data in a spreadsheet, but I simply don't have the time to turn the...

pritesh-807803 (3/1/2010)

---

Hi Chris,

My above posted query is wroking fine. I have problem with order by Status.

I wand distinct CandidateIDs from Candidate and CandidateProject table where i want to give...

Well done - but your observation that rebuilding the db solved the problem is almost...

ma-516002 (2/28/2010)

---

No, your suggested command has the same result as the auto generated one, an empty table.

This looks like there is something missing to sp_executesql or the target procedure in...

ma-516002 (2/28/2010)

---

No, your suggested command has the same result as the auto generated one, an empty table.

This looks like there is something missing to sp_executesql or the target procedure in...

Thanks for the extra info.

I think the problem is with setting up the command string in your interface code....

ma-516002 (2/28/2010)

---

I have a stored procedure which expects a few parameters, all have a default value. The procedure returns a table, that is it ends with SELECT ... FROM. I...