How to use SQL function in joins

[rahulken]

Currently facing problem while using sql function in joins. It is giving mw the error as "Invalid object name dbo.<functionname>

I have following query as

Select E.EmpId,

          D.DeptName

from Employees E cross join dbo.GetEmployeeDetails(E.EmpId)

[rupamjyotidas]

Maybe this

Select E.EmpId,

          D.DeptName

from Employees E cross join

Select your fieldname

From dbo.GetEmployeeDetails(E.EmpId)

But are you sure you want to do cross join. I fear that join.

[#3]

Use apply instead of join  when joining table valued functions. 

Select E.EmpId,

           D.DeptName

  from Employees E cross apply dbo.GetEmployeeDetails(E.EmpId)

[Anil_Babu_Samineni]

Does GetEmployeeDetails is a table name or what.

Would you describe more means share the screen which you get the error.

[jayanttibhe]

Hi,

Maybe you want something like this :

Select E.EmpId,

          D.DeptName

from Employees E

cross join

dbo.GetEmployeeDetails D

OR

Select E.EmpId,

          D.DeptName

from Employees E ,

dbo.GetEmployeeDetails D

I dint get why you want to specify dbo?  normally if we want to specify specific table in specific Data base then we use this syntax :  dbo.DB_Name.Table_Name

Thanks

Jayant

[Gysbert_Wassenaar]

Try asking this question on a SQL Server support site. It has nothing to do with Qlikview. Once you have figured out what the correct sql statement is you can use it in Qlikview as it is. Qlikview only passes the sql statement to the oledb or odbc driver and receives the results from the driver.

[rahulken]

I am still facing the problem (I tried all the flows mentioned here). Please find the screen shot of the error.

[rahulken]

Here I tried apply also still faced this error.

[jonathandienst]

You did try a SQL support site as Gysbert suggested right?

[rahulken]

I tried it on SQL and it works in query analyser.