Thanks a million, peter.

You enlightened me on CTEs. Although I have read a little on CTE, I haven't really used it so far. You let me see how powerful...

gserdijn (4/29/2009)

---

Regarding the duplicate DataIDs: Well, then we can use a UNION.

SELECT TestData.RowNumber, TestData.DataID, FactRL.DataTime,TestData.Name NameFrom, FactRL.DataText

FROM TestData

JOIN FactRL ON TestData.DataID = FactRL.DataID

UNION

SELECT TestData.RowNumber, TestData.DataID, NULL ,TestData.Name...

SELECT TestData.RowNumber, TestData.DataID, FactRL.DataTime,TestData.Name NameFrom, COALESCE(FactRL.datatext,factsl.datatext) DataText

FROM TestData

LEFT JOIN FactRL ON TestData.DataID = FactRL.DataID

LEFT JOIN FactsL ON TestData.DataID = FactsL.DataID

ORDER BY TestData.RowNumber

I think there is a few...

As I have been convinced yesterday that cursor should be eliminated whenever possible. I have another cursor which I would happy to get rid of if I can.

-- create...

My previous post was actually trying to ask if cursor still has its use in certain circumstances. And to my particular case, it does weigh performance over scaling, and the...

Thanks Samuel and Peter.

The real environment where this function to be used, the 'TestData' table is not really large. Or to be exact, the TestData table is large, but this...