This is how I would rewrite the query you originally posted:

SELECT

eventId

,startTime

...

True, if running x64, you don't need the /3GB switch, but the OP didn't indicate what version they are running.

We are running a mixed environment ourselves; SQL Server 2005 x32...

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...