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 strongm 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: *

  • Users: VMRao
  • Order by date
  1. VMRao

    Is there any cast operator for inserting comma (,)

    Yes, you are right..I used the second query ...and got the result.. select substring(convert(varchar (10),convert(money,sum(dis)),1),1,(select len(convert(varchar (10),convert(money,sum(dis)),1 ) )-3 from master_file where year(h_date) = '2001' and cat in ('371','372','373') and sex = 'f'...
  2. VMRao

    Is there any cast operator for inserting comma (,)

    Hi DBomrrsm, Are you sure both queries you posted are correct? VMrao
  3. VMRao

    Is there any cast operator for inserting comma (,)

    I mean i don't want decimal value as the result. I am looking for 21,340 instead of 21,340.06 sorry, i should have mentioned it in the last thread only. Malli. When the going gets tough, Tough gets going..........
  4. VMRao

    Is there any cast operator for inserting comma (,)

    Thanks DBomrrsm, My query is: select convert(varchar (10),convert(money,sum(dis)),1) from master_table where year(h_date) = '2001' and cat in ('370','371','372') --------- 55,581.00 (1 row(s) affected) I got (,) But still i have problem with decimal values. Malli. When the going gets...
  5. VMRao

    Is there any cast operator for inserting comma (,)

    Hi all, Can anybody tell me how to put a comma between the digits of a number which i got from the query.I mean is there any CAST/CONVERT/...? FUNCTION TO DO THIS. Ex: I have to print 10000 as 10,000 7896 as 7,896 Thanz in Advance... Vmrao. Malli. When the going gets...
  6. VMRao

    unable to run multiple queries/connections

    Nothing has been changed...everything is same as before. My query is of 1031 lines ....Is this anyway related(1031 lines) Malli. When the going gets tough, Tough gets going..........
  7. VMRao

    unable to run multiple connections

    Sorry.... Malli. When the going gets tough, Tough gets going..........
  8. VMRao

    unable to run multiple queries/connections

    Thanks Kusch ...No.. the database is accessible by many machines on the network..Multiuser mode Malli. When the going gets tough, Tough gets going..........
  9. VMRao

    unable to run multiple queries/connections

    hi I'm working on MS SQL server 7.0/client machine.Actual server is on some other machine on the network. protocol used: named pipes everything worked fine till yesterday. now i am unable to run multiple queries/connections.If i try to run a second query in query analyzer, the connection is...
  10. VMRao

    unable to run multiple connections

    hi I'm working on MS SQL server 7.0/client machine.Actual server is on some other machine on the network. protocol used: named pipes everything worked fine till yesterday. now i am unable to run multiple queries/connections.If i try to run a second query in query analyzer, the connection is...
  11. VMRao

    Changing the image on the form header bar

    I think it's just changing the icon property..... put the path of an icon in ur system in the icon property field bye
  12. VMRao

    which grid is best to view access database in VB form?

    I wanted to know which grid is best to view access database table ?and i'm using check boxes in my table for one field Thanks in Advance Malli.

Part and Inventory Search

Back
Top