Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Default column value using default or formula properties

Posted on 2006-06-12
5
Medium Priority
?
504 Views
Last Modified: 2010-05-18
I have a date column on my table defined as datetime (call_date) (not necessarily current date)

I also have 2 columns named  call_month and call_year ( both defined as varchar).

I would like the call_month and call_year values to be defaulted to month and year portions of call_date respectively.

Is it possible to do this using the default or formula values for the field definitions?


For example if call_date is 5/24/06....call_month would default to 5 and call_year would default to 06


I know I could do this using a trigger but just curious....
0
Comment
Question by:johnnyg123
  • 2
5 Comments
 
LVL 9

Expert Comment

by:raopsn
ID: 16889728
Yes you can use a trigger to that,
but why you want to store that data ? when you can derive it at any time
0
 

Author Comment

by:johnnyg123
ID: 16889830
I needed it to make it easier to do reporting .....actually...I figured it out


for call_month

(case when ([FOTCCallDate] is not null) then (datepart(month,[FOTCCallDate])) else '' end)


for call_year

(case when ([FOTCCallDate] is not null) then (datepart(year,[FOTCCallDate])) else '' end)


How can I close this case?
0
 
LVL 9

Expert Comment

by:raopsn
ID: 16889856
0
 
LVL 5

Accepted Solution

by:
Netminder earned 0 total points
ID: 16932443
Closed, 500 points refunded.
Netminder
Site Admin
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

927 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