i have created a user defined function that returns a table. There is one parameter (@Job CHAR(10) )
SELECT * from dbo.fproduction_record(123456) returns the correct results for that job # 123456
For testing purposes i want to be able to return all results of the function but when i try to use DEFAULT as the parameter
SELECT * from dbo.fproduction_record(default)it produces zero results.
How should the default parameter be used to return the full dataset
Also, if I also wanted to return the results for a range of jobs, how would i type the select statement?
thanks for any help
SELECT * from dbo.fproduction_record(123456) returns the correct results for that job # 123456
For testing purposes i want to be able to return all results of the function but when i try to use DEFAULT as the parameter
SELECT * from dbo.fproduction_record(default)it produces zero results.
How should the default parameter be used to return the full dataset
Also, if I also wanted to return the results for a range of jobs, how would i type the select statement?
thanks for any help