Viewing 15 posts - 19,726 through 19,740 (of 26,484 total)
Lowell (7/20/2009)
UPDATE CP
SET CP.BaseRate = CASE
...
July 20, 2009 at 11:07 am
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 *...
July 20, 2009 at 11:04 am
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...
July 20, 2009 at 10:59 am
shipra20 (7/20/2009)
sorry for the typo.Given:-
ID--name--code--date
1---abc---A1----01/01/2009
1---xbc---A2----02/01/2009
2---xyz---A3----03/01/2009
2---ayz---A4----04/01/2009
the result should be
ID--name--code--date
1---xbc---A2----02/01/2009
2---ayz---A4----04/01/2009
Thanks
--sh
Okay, makes more sense now. Now I'd like to see what you have tried so far to solve your problem. In...
July 20, 2009 at 10:36 am
Jeff Moden (7/19/2009)
Why would anyone think that INTERSECT is easier than INNER JOIN?
How about finding all records matching records between two tables with identical structure? Would you rather write...
July 20, 2009 at 10:32 am
shipra20 (7/20/2009)
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...
July 20, 2009 at 10:23 am
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,...
July 20, 2009 at 9:49 am
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...
July 20, 2009 at 9:42 am
Gift Peddie (7/20/2009)
Are you implying that woman and minorities are stupid in that they can't pass an exam even with the material available
No the US education system excludes these...
July 20, 2009 at 9:06 am
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...
July 20, 2009 at 8:51 am
This will also "truncate" the time portion of a datetime value to midnight:
select dateadd(dd, datediff(dd, 0, getdate()), 0)
July 20, 2009 at 8:46 am
imSQrLy (7/20/2009)
July 20, 2009 at 7:21 am
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
July 20, 2009 at 7:10 am
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...
July 20, 2009 at 7:02 am
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...
July 20, 2009 at 12:02 am
Viewing 15 posts - 19,726 through 19,740 (of 26,484 total)