THe Cross apply will only return rows if the function you are calling returns rows that match x.Id. If you want to return all rows from EMP regardless of there...

The problem you are facing is that the TVF returns 2 columns, thus you cannot put it in the Column List, so you must either use a JOIN or APPLY...

As the TVF returns 2 columns you will have to do that as a using a CROSS APPLY

Something like this

SELECT x.Id, x.Name, y.Col1, y.Col2

FROM Emp x

CROSS APPLY udf_GetEmpDetail(x.Id) y

I'm not suprised it took a couple of hours looking at the query you have loops with cursors which is going to drag performance down into the basement and beyond...

I have the unleashed book and there is something in it for developers of all levels, there are some advanced topics but starts with the basics, such as terminoogy as...

You can add in the DBSchema file for the missing references databases, this is then use to validated the references used by the synonym.

I'm afraid you will need to be a little more specific about what you want to know, as its a very broad subject and can cover a multitude of areas...

GilaMonster (1/30/2013)

---

Just bear in mind that...

Mr. Kapsicum (1/30/2013)

---

Thanks uravindarreddy,,, Ur query is Great.

But Can U explain its working to me.,? I m a bit naive to SQL , cant understand its in depth working.!!

Thanks again...

Sorry I spotted that, and just changed them to work. Theres still a problem with the ISNULL though.

this is the isnull

SELECT ID,COLOR

FROM #TBLCOLOR

WHERE ISNULL(COLOR,'')=ISNULL(@COLOR,ISNULL(COLOR,''))

Personally I would try an avoide the COALESCE and ISNULL funtion on a where clause

the simplest way

SELECT Id,Color

From TBLCOLOR

WHERE Color=@Color OR @Color is NULL

with IsNULL function

SELECT Id,Color

From TBLCOLOR

WHERE...

As Gail has said yes, i would caveat that with the in an emergancy on a critical system then you may have no choice but to shrink in order to...

Not exactly, You can create a project level Data Source, then in the connection Managers you can use the New Connection From Data Source option

this will inherit the settings...

This URL may explain it better http://sqlinthewild.co.za/index.php/2009/08/17/exists-vs-in/

Thats the way I would suggest,

Personally I would invest in setting up the SQLServer stored variables, as this way you can store...