I created a UDF named: [dbo].[RG_DailyShippingSta
When I call the function like:
SELECT * FROM [dbo].[RG_DailyShippingSta
I get: Line 1: Incorrect syntax near '('.
Then I replace GETDATE() with the values Ialso used when testing the function with hard-coded values:
SELECT * FROM [RGMFG].[dbo].[RG_DailyShi
But I get zero results.
I have included a copy of this UDF from when I was using hard coded values. When running it that way, I do get results.
I am also including a copy of it, not using hard coded values.
Would someone be willing to take a look at this and see if you can locate where I am making the mistake?
Thank you very much