I have this Select statement where it gets the value that I need [FILE_ID]:
TBL_STAT = 'purge_elig' And
TBL_Typ = 'Claim'
I would like to use [FILE_ID] as a parameter to pass to other Stored Procedures...
How do I do this???
I can see the:
but I am not sure on how to use it...
I quess it would be a output parameter at this point???
Variable Name: Add: FILE_ID - but it says: A variable value must be specified for the selected variable type, I selected Int32 (because it is a Int type).
Date Type: ???
Parameter Name: NewParameterName???
Parameter Size: -1???