Search results for query: *

Thanks for your reply. I should have put the whole query in. I'm using visual Studio 2003 to create this query. SELECT SUM(s.SHARES) * pf.PRICE AS CASH, lf.ASSET_CLASS AS STYLE FROM lf INNER JOIN lf ON pf.TICKER = lf.FUND_CODE INNER JOIN s ON lf.FUND_NO = s.FUND WHERE...

I'm getting the value "CASH" here "Select SUM(shares.shares)* price AS CASH,LuFund.fund AS STYLE". The result set looks like: CASH STYLE $23,000 Stock $10,000 Bond $43,000 Stock $15,000 Bond I now need to total how much I have in each asset category - Stock, Bond, Etc...

What I think you are talking about is what active server pages do. I'd get a book on ASP.NET / ADO.NET / VISUAL STUDIO.NET & C#. There are many out there. If you are using visual studio.net I'd start with that

I need get a sum of transactions (shares) then multiply it by a price from a specific date then multiply (shares * price) AS CASH. I tried the following just to even get the sum of shares and a price. I wind up with a dataset that contains multiple rows for the same fund (I want a single entry...

I am trying to loop through a dataset table ds.Tables["SHARES"] get a value from columns ["FUND"], ["SHARES"] then locate the share price in ds.Tables["PriceFile"] by locating the result from [FUND"] in PricFile then multiply round((shares * price),2)...

I'm having trouble getting unified messaging to work. One of the help files seems to indicate that desktop messaging and Unified Messaging offer different functionality. I can't find any documentatiom on Unified Messaging. I tried installing desk top messaging but encountered problems with...

I am having trouble connecting incoming phone lines to the system. I have confimed that the lines all work, telephone numbers, cable etc. I connected the white and blue pair and the white orange pair and all was well. The green/white and brown white pairs do not seem to connect. The next...