Take a look at this little bit of test code and see if you can use what it demonstrates (at least it works on my system here at work).

declare @ADate...

And, to throw more into the mix, actual performance in the OP's environment may be different due to storage/indexing on the tables.

I guess the best way to test would be...

GSquared,

Can you test it with the additional criteria in the original query: where t.fiscal_year = 2008?

This may (or may not) make a difference in the queries.

I'd try, but I don't...

Be sure to test both ways. I'd be interested in knowing which works better/easier for you.

😎

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.

😎