Viewing 15 posts - 19,726 through 19,740 (of 26,490 total)
Here is the code I came up with. Too bad I don't know what you have tried so far to solve your problem. It would have helped to...
July 20, 2009 at 11:58 am
adam spencer (7/20/2009)
relieves me, and keeps my feeling of stupidity a secret to u 'all and...
July 20, 2009 at 11:37 am
Gift Peddie (7/20/2009)
But you have made such generalizations in previous posts
The US celebrates changes and pretend the bad seldom happen.
Again, another generalization. Bad things do happen, and have happened....
July 20, 2009 at 11:26 am
Loner (7/17/2009)
matt, do you mind to share your cv template? 😛
Matt, I have to agree, would you be willing to share your template?
July 20, 2009 at 11:14 am
Gift Peddie (7/20/2009)
I think once you've been discriminated against once it is easy to assume that is the cause for every negative experience, but not necessarily correct.
I don't...
July 20, 2009 at 11:12 am
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
Viewing 15 posts - 19,726 through 19,740 (of 26,490 total)