I have a scalar function created in SQL Server 2016, this will happen three parameters employee code, movement type, cut date, I perform a calculation of total salaries with the cut date, in SQL server, it works for me 100 %, but when I send it or try to call it in VB it does not return anything, I'm using data set.
function:
SELECT dbo.obtenerSalariosLiq ('5488', 1,'2018-02-23')
Call
me.mtaobtenerSalariosLiq.fill(me.dsnomina.obtenerSalariosLiq ('5488', 1,'2018-02-23')
I call it a table adapter, if I enter the code of this function in design time, the system drops because it marks error.
They would guide me that I have bad in the call to this function and what I need is that this function gives me back the value I found.
Greetings