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 |
|
maqza
Starting Member
7 Posts |
 Posted - 2011-02-05 : 03:35:39
|
| Hi allI have a problem in using date in sub query Table A Table B Fndcode Fndcode Current date Valuation date Mkt Price Holding Quantity Fund Code Current Date Mkt price Fnd Code Valuation date Holding Quantity 200 01/Jan/10 50 200 15/Nov/09 8500200 05/Jan/10 55 200 04/Jan/10 8502200 15/Jun/10 65 200 31/Mar/10 9000 Display like Fund CodeCurrent Date Mkt price Holding Quantity 200 15/Jun/10 65 * 9000 200 05/Jan/10 55 * 8502 |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2011-02-05 : 07:32:31
|
What is your query? are you asking to produce those results? or are those results you are getting?
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
maqza
Starting Member
7 Posts |
Posted - 2011-02-06 : 01:09:49
|
quote:
Originally posted by dataguru1971
What is your query? are you asking to produce those results? or are those results you are getting?
Poor planning on your part does not constitute an emergency on my part.
|
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-02-07 : 04:25:23
|
quote:
Originally posted by maqza
quote:
Originally posted by dataguru1971
What is your query? are you asking to produce those results? or are those results you are getting?
Poor planning on your part does not constitute an emergency on my part.
You didn't answer to the questionMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Sub Select