varunkum (1/19/2011)

---

Hi. I want to find address duplicates. ACCOUNT and ADDRESS are columns(all the addresses are formatted perfectly, don't worry about that). Take some fictitious table name(table_name). Now i want...

Give this a try

DBCC SHRINKFILE (N'Test001' , 1000)

the 1000 is the size MB can not be smaller then used space

But sir, I am not so expert to use all this, will you please help me.

Just compare four columns of table PendingClaims to OldAr table. if any change in columns...

I would not use this method you will get false/positives with...

The only time I have seen the model database change is when someone added objects to it by accident or when source control software added objects to the model

I agree hit refresh or F5

Hi

I have seen some issue like this, but have been able to find and fix the issue, most of the time it something wrong with the data.

Is there...

I deal with this very often with data from my clients, If you take large vendor master you may have 25 different vendor numbers for same vendors. There is so...

A Simple way to test what you are building in your @SQL is to

PRINT(@SQL) --I use this to debug the statement

--EXEC(@sql)

Did you try the Ex I posted I have not had time to test

petervdkerk (11/19/2010)

---

Ah, I didnt see all the code, my bad.

Anyway, your code seems to do [almost] what I need.

Currently your code shows: #duplicate records - 1, meaning that if I...

See if this works for you

INSERT INTO @prosp(Id,companyname,cnt)

SELECT

P.Id,

P.companyname,

P.cnt

FROM

prospects P

INNER JOIN

...

Paul White NZ (11/19/2010)

---

There is a complete explanation and script in the following SSC article by Lynn Pettis:

http://www.sqlservercentral.com/articles/67898/

The...

I am not sure if this correct and would need to test but if you give it a try I would think something like this...

hard to say with out sample data and no table structure

a very simple way is

top 10000 control with a WHERE effdat <> enrolldat

If you give me some more info...