Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.
I want to call it for all the patients in my database that are women.
CREATE FUNCTION [dbo].[ReadControlMeasurement] ( -- Add the parameters for the function here @pat_id int, @StartMonth int, @EndMonth int )
i was thinking along the lines of using a cte:
select pat_id from Patients where gender = 'W'
but this does not seem to have a valid syntax.
with Women as ( select distinct pat_id from Patients where Gender = 'W' ) select B.* from Women W inner join dbo.ReadControlMeasurement( W.pat_id, 0, 1 ) B on W.pat_id = B.pat_id
|kill all other existing SQL server connection except the login started by current session||65||101|
|Excel conversion issue with Sql server||14||50|
|Unable to save view in SSMS||21||60|
|SQL Error in WHERE Clause||5||42|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
22 Experts available now in Live!