Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. KurtMillikin

    Sub 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...
  2. KurtMillikin

    Sub Query

    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...
  3. KurtMillikin

    browser session

    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
  4. KurtMillikin

    Sum problem

    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...
  5. KurtMillikin

    DataSet Navigation and manipulation

    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)...
  6. KurtMillikin

    Call Pilot 150 and Unified messaging

    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...
  7. KurtMillikin

    Norstar ICS 4.2 Line connection

    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...

Part and Inventory Search

Back
Top