Search results for query: *

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

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

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

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

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

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

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

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

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

hmmm, sounds tough.

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?

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