Glad to help

Check this one

declare @IPaddresses TABLE ([IPAddress] VARCHAR(20),[dte] [smalldatetime])

-- Inserting Data into Table

INSERT INTO @IPaddresses(IPAddress,dte)

VALUES('86.148.129.66','20-jun-2014 13:00:00')

INSERT INTO @IPaddresses(IPAddress,dte)

VALUES('86.148.129.66','20-jun-2014 13:30:00')

INSERT INTO @IPaddresses(IPAddress,dte)

VALUES('86.148.129.66','20-jun-2014...

When you say this, how exactly are you recording...

ChrisM@Work (7/17/2014)

---

I understand that you are attempting to get a count of dupes and that the query isn't working for you. That part is easy enough to fix. The problem...

pilla.sree85 (7/17/2014)

---

My Query is i want to pull duplicate records from the table and get the count of each duplicate record from the table.i wrote below query

IF EXISTS(

SELECT L1.AcctNo,L1.ReceivedFileID from...

Let say you have a IP Addess

255.255.255.0

is changed to

255.255.255.1

how would you like to see this result set?

Good Knowledge base question. Thanks for sharing

The value of a custom variable can be a literal or an expression:

If you want the variable to contain a literal value, set the value of its Value property.

If you...

+1, Nice question

what error are you getting

raghuldrag (7/14/2014)

---

Hi Twin Devil,

Here Some Of the accounts are manually defined in sales and maintenance after ...

what exactly the issue you are facing ? as per the query you will get the aggregated result. One question, when you say "Account Type" Maintenance/Sales ? How do u...

Nice question, Thanks for sharing

Nice question, Thanks for sharing

what is your database collation, have you checked it ?