Hi to every one ..I want to get a count from variable ,please check the below query
'DECLARE @PATOIDS VARCHAR(MAX) ' +
'DECLARE @Pat VARCHAR(MAX) '+
'SET @PATOIDS = '''' ' +
'SELECT @PATOIDS = @PATOIDS + CAST(PATIENTOID AS VARCHAR) + '','' ' +
'FROM (SELECT DISTINCT PATIENTOID ' +
'FROM @CNT) TMP ' +
'IF LEN(@PATOIDS) > 0 ' +
'SET @PATOIDS = SUBSTRING(@PATOIDS, 1, LEN(@PATOIDS) - 1)'
In the above query '@PATOIDS' contains multiple values , to print the values in @PATOIDS,am using the statement like
'DECLARE @PATOIDS VARCHAR(MAX) ' +
'DECLARE @Pat VARCHAR(MAX) '+
'SET @PATOIDS = '''' ' +
'SELECT @PATOIDS = @PATOIDS + CAST(PATIENTOID AS VARCHAR) + '','' ' +
'FROM (SELECT DISTINCT PATIENTOID ' +
'FROM @CNT) TMP ' +
'IF LEN(@PATOIDS) > 0 ' +
'SET @PATOIDS = SUBSTRING(@PATOIDS, 1, LEN(@PATOIDS) - 1)'+
+'PRINT(@PATOIDS)'
but the out put contains the values along with comma separated values but I want to print the count of @PATOIDS, so can any one tell me how to get the count??