Hi, i also having the same error.iam able to login sqlserver with my windows account but iam not able to login with sa account.even thogh i changed password and...

Nice question.Its new for me

Hi,

I didn't that this question is rubbish.Because there is no clarity for relation between question and answer.But this is an intresting topic.What is my intension is question sholud be...

Dear all,

SET NOCOUNT ON

Does not reset the @@rowcount to 0.

@@rowcount is zero when we execute the system Defaults like as shown

set ansi_padding on

select @@rowcount

set nocount on

select @@rowcount

set...

It is correct.

I also confused the same.but the question is improper.because if we execute the query it shows the result as 1,1.but it will show 0,1 for your case.the result...

yaa there is no use for putting order by but for checking purpose i put order by.

i for got to delete.

this is my query

with Duplicaterecords as

(

select br_beneficiaryname,br_beneficiarysurname,br_fathername,br_dob,br_districtid,br_mandalid,br_villageid,br_servicepointcode,br_beneficiaryid,br_dateofregistration,br_visitdate,

row_number() over(partition by br_districtid,br_mandalid,br_villageid,br_dob,br_beneficiaryname,br_beneficiarysurname,br_fathername order by br_districtid,

br_mandalid,br_villageid,br_beneficiaryname,br_dob,br_servicepointcode) as row from TELEMONITORING.beneficiaryregistration

where br_beneficiarytypeid=6

)

select * into #temp1 from Duplicaterecords

where row>1

order by br_servicepointcode

select a.br_beneficiaryname,a.br_beneficiarysurname,a.br_fathername,

a.br_dob,a.br_districtid,a.br_mandalid,a.br_villageid,

masterdata.hihlmain.district.districtname,...

Hi jeff,

yaa your solution is absolutly correct and i found the solution my self and writing the query like your same as your posted query.and this is a simplest solution...

even i tried like this alo but i have unique identifier for a column name benfiaryid in the above result i want show the unqiue identfier for that colmun.iam not...

ok i did not hijack others thraed

but this is my urgent requirement report in company.

so i posted here understanding me

ok sorry.

ok but this is my exact query and i do not cross apply.because this post is some what matching my requirement but not full fledged.

the above post is my...

Hi ,

i searched the duplcate calls but in my table i have an unique identifier and also i want to dsiplay like this

br_benficiaryname br_village br_id

malli ...

no that all the article are not working for my request.i want to show all duplicates instead of that.

i already showed the above pattern how ca you achieve this.

br_beneficiarysurnamebr_dobbr_servicepointcodebr_beneficiaryidbr_dateofregistrationbr_visitdaterow

G8/27/1944SP3139010T03013900079583002428/27/20098/27/20092

G8/27/1944SP3139010T03013900079583002408/27/20098/27/20093

iam getting all duplicate using this query but i didi not got this only two duplicates but there are three duplicates.

with Duplicaterecords as

(

select br_beneficiarysurname,br_dob,br_districtid,br_servicepointcode,br_beneficiaryid,br_dateofregistration,br_visitdate,

row_number() over(partition by br_districtid,br_dob,br_servicepointcode order by...

yaa,

what you told is correct. i permissions and iam able to call RPC. which will executed as same time.

and also removed the date conversion. thanks alot