Solved

Help with computed column

Posted on 2015-01-14
3
85 Views
Last Modified: 2015-01-15
I have a table that has a date column. I want to add a computed bit column that indicates which record has the latest date, i.e., the "active" record.

How can I do this?
0
Comment
Question by:HLRosenberger
3 Comments
 
LVL 12

Accepted Solution

by:
FarWest earned 500 total points
ID: 40549446
if you have duplicate rows with different dates (example client info multiple records) in the table and you want computed column to test if this record is the last one, I think this is not possible,
using views  is better to  achieve this,
0
 
LVL 1

Author Closing Comment

by:HLRosenberger
ID: 40551471
ok thanks.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction Hi all and welcome to my first article on Experts Exchange. A while ago, someone asked me if i could do some tutorials on object oriented programming. I decided to do them on C#. Now you may ask me, why's that? Well, one of the re…
IntroductionWhile developing web applications, a single page might contain many regions and each region might contain many number of controls with the capability to perform  postback. Many times you might need to perform some action on an ASP.NET po…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now