Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
naren.verma
Starting Member
1 Post |
 Posted - 2013-07-30 : 13:58:40
|
| Hi All,I have a frequency feed column which can have below possible values:1st week-end after the last claim run of the monthEnd of the following monthImplementingMondayMonthlyMonthly (1 month delay)Monthly 1Monthly 10Monthly 10thMonthly 11Monthly 13Monthly 14Monthly 15Monthly 15thMonthly 16Monthly 1stMonthly 1st WeekMonthly 20Monthly 20 (6 month delay)Monthly 22Monthly 3Monthly 30Monthly 5Monthly 6Monthly 7Monthly 8Monthly 9thMonthly Last ThursdayMonthly Last WednesdayMonthly Second WednesdayMonthly Second WeekNO FEEDSNo Feeds (PROSPECT)ProspectWeeklyI would like to covert them into date..if not all of them,then at least maximum of these values.Please assist.ThanksNarenNV |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-07-30 : 14:21:38
|
quote:
Originally posted by naren.verma
Hi All,I have a frequency feed column which can have below possible values:1st week-end after the last claim run of the monthEnd of the following monthImplementingMondayMonthlyMonthly (1 month delay)Monthly 1Monthly 10Monthly 10thMonthly 11Monthly 13Monthly 14Monthly 15Monthly 15thMonthly 16Monthly 1stMonthly 1st WeekMonthly 20Monthly 20 (6 month delay)Monthly 22Monthly 3Monthly 30Monthly 5Monthly 6Monthly 7Monthly 8Monthly 9thMonthly Last ThursdayMonthly Last WednesdayMonthly Second WednesdayMonthly Second WeekNO FEEDSNo Feeds (PROSPECT)ProspectWeeklyI would like to covert them into date..if not all of them,then at least maximum of these values.Please assist.ThanksNarenNV
What is the output you would expect given this sample data? If this is not sample data, can you post representative sample data and the corresponding output you are expecting to get along with the rule you used to calculate the output? |
 |
|
|
|
|
|
alphanumeric to date in SQL