AND EXISTS(SELECT 1
    FROM
     (SELECT DISTINCT
       F_ALIAS,
       F_DATA_CODE,
       STUFF((SELECT ', ' + A.F_DATA
         FROM T_REP_DATA A
         WHERE A.F_ALIAS = RPDS.F_ALIAS

Now i created TVP and procedure also.While executing procedure Values are not passed to the query.Please find the procedure  and Inputs.
CREATE TYPE TableVariable AS TABLE

(
  id...

This stored procedure is used in filter application.Inputs are coming from web page.ASP.Net is front end. Filtering the records based on input parameters(F_id and Value)
F_id is the id(unique and...

Need Procedure for executing dynamic query.
===== Input Parameters
f_id int
value nvarchar(max)
===== Input Parameters accepts more then one values.(Like array)
===== Sample Datas for Input Parameters.

;with cteSampleData

as

(

select id,name,parent_id

from f_groups

where parent_id is null and c_id=83

union all

select s2.id,s2.name,s2.parent_id

from f_groups s2

inner join cteSampleData s1 on s1.id = s2.parent_id and c_id=83

)

select ts.id,ts.name,ts.parent_id

from cteSampleData ts order by parent_id

option...

I checked this query with my data.it is returning the following output.

SELECT last_sign_in_at,

CAST(DATEDIFF(yy, last_sign_in_at, GETDATE()) AS NVARCHAR(4)) + ' years, ' +

CAST(DATEDIFF(m, last_sign_in_at, GETDATE()) AS NVARCHAR(2))...

Thank you

i tried below query

DELETE FROM [TableName]

WHERE id IN(

SELECT id

FROM [TableName]

GROUP BY id

HAVING COUNT(id) > 1)

but it is checking only ID column not NO column.I want to check both columns.