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 |
|
gsnindia
Starting Member
5 Posts |
 Posted - 2005-08-13 : 04:17:56
|
| does this have any error into it select symbol,avg(TOTTRDQTY) as AvgVolume,(select AVG(TOTTRDQTY) from [2005] where timpstamp>'8/11/2005') from [2005] where timpstamp > '5/1/2005' group by symbol |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-08-13 : 05:00:57
|
| Did you get any error when running this query?If so, give more details on what you are trying to doMadhivananFailing to plan is Planning to fail |
 |
|
|
gsnindia
Starting Member
5 Posts |
Posted - 2005-08-13 : 10:29:36
|
| i am getting the folling error Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-08-16 : 00:56:07
|
| Did you get this error in Query Analyser or from your Front End Application?If you assign string value to the integer column, you will get this errorMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Check and reply