harishgg1:
Thanks, that's what I was looking for
this is how
Cast ( Your years calc as varchar)
+ ' years ' +
Cast ( Your months calc as varchar)
+ ' months' +
Cast ( Your days calc as varchar)
+ ' days'
Reply
Bookmark Share Flag Reply
Watching
You will receive notifications because you created this topic.
Suggested Topics
| Topic | Replies | Views | Activity |
|---|---|---|---|
| SP with 4 select statements not returning records from one of the 4 issue -VB.NET 1 |
Transact-SQL|8|544|Apr '17|
|Get latest record for each customer 1
Transact-SQL|6|707|May '16|
|Get max value from datareader results 1|1|293|Nov '16|
|Close id gaps
Transact-SQL|3|13|6m|
|Add a running number column based on a text value