November 15, 2011 at 10:20 am
i have table result like
contractid timeid expirydate
1 null 2012-12
but i need result like
1 201111 2012-12
1 201112 2012-12
1 201201 2012-12
.
.
1 201212 2012-12
November 15, 2011 at 10:47 am
Try using DatePart function to seperate the Month and Year from date column.
November 15, 2011 at 1:42 pm
We need some use cases. Please post up what your current source table(s) look like and the query as it has been developed so far. It would also be nice to see the expected result for each row in the source table. We don't need all the rows, a half dozen or so would be sufficient.
I am assuming you want to look up the expiration year and month for each date on a row-by-row basis. This can be done, but more information is required.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply