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!

Recent content by clive

  1. clive

    Needs to list rows as columns and columns as rows

    I've got the cross-tab query working. I'd couldn't find the TRANSFORM or PIVOT key words anywhere in the Microsoft SQL books online. This may be an Oracle thing. This is what I had to do: CREATE TABLE #Temp ( Label1 varchar(50), Month1 money, Month2 money, Month3 money) INSERT...
  2. clive

    Needs to list rows as columns and columns as rows

    I need a query to return the results of something like this: select period, sum(foo), sum(bar) group by period Except I need each period to be listed as a column not a row. Does anyone know how this is done? -Clive
  3. clive

    How I can give an Button a other color ?

    Another good site to get improved Windows components. http://www.codeguru.com/ This site has funky buttons, statis labels, lists, and basically everything.
  4. clive

    Visual C++ vs Standard C++

    I've worked with both. I find Visual C++ has a very very good debugger but I was doing Windows programming with it. Windows programming can be very challenging at times though. If you're possibly going to do some Windows programming with Visual C++, expect a bumpy ride. Hope this helps, -Clive
  5. clive

    How do I sniff a packet?

    Hi all, I'm intending to do a little packet analysis in linux. Can anyone point me to some code that reads packets from an ethernet card. Cheers, -Clive
    • clive
    • Thread
    • Replies: 0
    • Forum: C++
  6. clive

    bsearch( ) with an Ordered Linked List : Can it be Done ?

    Sorry Siddhartha but I tend to agree with amit here. You cannot do a binary search on a linked list. I think Aussie Bill would have to create a binary tree instead. However because you're reading from an ordered text file the binary tree would come out rather unbalanced. If you're unkeen on...
  7. clive

    signed? - what does it mean?

    In simple terms, Signed - Negative and Postive integers. Unsigned - Positive integers only. Here are the number ranges for C/C++ integer types: unsigned char: 0 to 255 signed char: -128 to 127 unsigned short: 0 to 65535 signed short: -32768 to 32767 unsigned long: 0 to 4294967296 signed long...
  8. clive

    How do I add records fast with ODBC

    Some very useful suggestions calahans.<br><br>1) Yes it will be a scheduled task running over night. That is why it uses ODBC. I had to write a win32 application so that it could be scheduled under the windows task scheduler thingo.<br><br>2) These indexes are a big problem. They've been created...
  9. clive

    How do I add records fast with ODBC

    Well, I get the feeling that dropping the indexes isn't going to do much. SQL server seems to be adding indexes automatically when it feels it needs to. For example this one, _WA_Sys_clientid_3D5E1FD2 which I did not create.<br><br>I seems to still be adding records at a rate of 200 per second...
  10. clive

    please help??

    hmmm, sounds tough.
  11. clive

    How do I add records fast with ODBC

    I'm adding about 1 million records to a table using ODBC insert statements. There are also 19 indexes on this table. As you can imagine this takes a while.<br><br>Is there a way to speed things up?<br>Can I stop the indexing till after all the inserts?
  12. clive

    What is the DESCRIBE command for SQL server 7

    How do I describe tables, views, etc in sql server7?<br><br>Is there a list of sql server 7 commands?<br><br>-Clive
See more

Part and Inventory Search

Back
Top