Madhivanan (9/24/2008)

---

Lynn Pettis (9/24/2008)

---

There is another side to this. If the date fields are currently varchar(8) with the dates formatted yyyymmdd, what effect will changing the data type to...

Agree with the above, but be sure to add the /3GB switch to the boot.ini file or the extra memory...

Adrian Nichols (9/24/2008)

---

Lynn,

I believe that the records, 2 and 4, correspond...

There is another side to this. If the date fields are currently varchar(8) with the dates formatted yyyymmdd, what effect will changing the data type to datetime have on...

I'm getting confused. The original post asked to find records for year-long policies, yet the post with sample data seemed to be asking to find the policies that AREN'T...

Looks good to me.

😎

create table #TestTab (

RowNum int,

AddressIdent int,

Address1 varchar(50),

DateChanged datetime);

insert into #TestTab (RowNum, AddressIdent, Address1, DateChanged)

select...

Here is another way to skin a cat. I'm sure some of the gurus out there may come back and say this is still rebar, but it eliminates a...

Actually, what I think is that the OP needs to post additional information, including sample data and expected results. This would greatly assist in determining a solution.

😎

bcronce (9/23/2008)

---

1,1,1234 park st,1-1-2000

2,1,1234 park st,1-2-2000

3,1,1234 park st,1-3-2000

4,1,2345 park ave,1-4-2000

5,1,1234 park st,1-5-2000

6,1,1234 park st,1-6-2000

The correct result should be 5.

originally my set based logic would return the correct result for anything...

This won't work if partial years span years. Example, datediff(yy,'2008-10-01','2009-01-31) = 1.

😎

bcronce (9/23/2008)

---

When i tried to solve this based on just a table with (rownumber, addressident, vchaddress, datechanged), I ran into grouping problems. I could try to find the max rownumber...

The above is not quite right. If you do the following:

select datediff(dd,'2008-01-01','2008-12-31')

the result is:

365

If...

Instead of waiting for confirmation, here is the code I was working with:

create table #TestTab (

id int,

totvisits int,

score...

garypete (9/22/2008)

---

Thanks for the post, I had two objectives here from the large data collection.

One was multiple visits (gt 2) and the other was to have a score above 4.

I...