Lowell (7/20/2009)

---

here's my WAG based on your SQL:

UPDATE CP

SET CP.BaseRate = CASE

...

A quick try at modifying your code would go like this. You should test this in a development environment first.

update dbo.tblCoveragePremiums set

BaseRate = BaseRate *...

Could you post the DDL for the table(s) and some sample data? I wouldn't be surprised if your cursor based code could be converted into a set based solution.

For...

Okay, makes more sense now. Now I'd like to see what you have tried so far to solve your problem. In...

How about finding all records matching records between two tables with identical structure? Would you rather write...

shipra20 (7/20/2009)

---

I have query like

select ID,name,code,date from tbl1.

In this each id can have numerous records with diffrent name,code and date.

I want to diaplay the record only with max date.How can...

Or

WHERE

...

and [CORE_CO-PERSON].[D-O-B] <= datediff(yy, -16, getdate()) -- where DOB is less than or equal to todays date 16 years ago.

Edit:

After 3 years,...

I also need to ask a question, what about leaplings? If some one is born on February 29th, when do you need to consider them a year older, on...

Gift Peddie (7/20/2009)

---

No the US education system excludes these...

I was "on vacation" last week having taken the week off to work the PPI. What I joke this year. I worked 3 games on Thursday and 1...

This will also "truncate" the time portion of a datetime value to midnight:

select dateadd(dd, datediff(dd, 0, getdate()), 0)

imSQrLy (7/20/2009)

---

I originally got my MCDBA on 2000 along with my MCSE and MCSA on 2000 OS. I certainly was experienced with Windows and would not have considered myself a...

This is one of the DMV's that you could use. You'll need to figure out exactly how at the moment as I need to head out to work.

sys.dm_db_partition_stats

At this point, then, I suggest you talk to you DBA's as it looks like you are going to need their assistance to accomplish this task since the transaction log...

It is getting late, so what I'm going to do right now is point you in a general direction and let you run with it a bit. You are...