T2102 wrote: I have gotten some pivots to work with arbitrary # of columns, but I've had to use dynamic sql. Yea if the columns before execution time are not known then you will need to resort to dynamic SQL. Common sense is admitting there is cause and effect and that you can exert some control over what you understand.

You're welcome, glad it got solved :) The need to optimize rises from a bad design.My articles[^]

I didn't occur to me at the time, but you're not going to find a 2 socket 1155 board because it's not a supported configuration (no QPI to link the chips). On the Intel side you'll have to wait until Q3 for LGA 2011 to launch before you can get multi-socket support for Sandybridge. 3x12=36 2x12=24 1x12=12 0x12=18

Thanks for the input. The code works after I separate it into two dlls. The particular function queries multiple webpages on separate threads and webclient was the only CLR functionality I utilized. I then processes the data after all of the threads come back since the processing time is small fraction of the runtime. I also am thinking of building XLL's with functions that retrieve data from the web, require multiple database calls/queries, and do array function computations simultaneously. The .NET threads cannot be utilized in the XLL project, so I have to use Boost threads or some other thread library. The Boost threads cannot be utilized inside the CLR project, but I am not using much more native than .NET code. So I created another dll that makes a native wrapper around the small # of functions I use with CLR.

Thanks

try with the following: System::Convert::ToInt32 System::Convert::ToDouble System::Convert::To......

You probably have a hardware failure that's going to get worse and worse. From the description you gave, I be worried about an actual drive failure, RAID controller failure, and a power supply failure. So, take appropriate steps to protect your data and consider your options for continuing functionality. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008 But no longer in 2009...

If the files are large you may need to read them in a line at a time. me, me, me "The dinosaurs became extinct because they didn't have a space program. And if we become extinct because we don't have a space program, it'll serve us right!" Larry Niven

I use SQL Express with no problem and it does most jobs. I tried to install the developer version but it was not an option with the download I was using so I stuck with Express Never underestimate the power of human stupidity RAH

Wouldn't only string functions work? Just guessing.

The query with the distinct is below. However, this returns an error unless distinct is removed. I am using Provider=Microsoft.Jet.OLEDB.4.0 SELECT DISTINCT ID_BB_SEC_NUM_DES FROM Curncy_FORWARD2010020801.csv WHERE ID_BB_SEC_NUM_DES LIKE '%HKD%' AND NAME NOT LIKE '%/%' AND NAME NOT LIKE '%+%' AND UCASE(NAME) NOT LIKE '%FWD POINTS%' AND UCASE(NAME) NOT LIKE '%IMPLIED YLD%' AND UCASE(NAME) NOT LIKE '%OUTR%' AND LEN(ID_BB_SEC_NUM_DES) BETWEEN 5 AND 10 AND UCASE(MARKET_SECTOR_DES( = 'CURNCY' AND SECURITY_TYP='FORWARD' AND ID_BB_SEC_NUM_SRC IS NOT NULL AND RIGHT(ID_BB_SEC_NUM_DES,1) IN ('W','M','Y') ORDER BY RIGHT(ID_BB_SEC_NUM_DES,1)<>'W' DESC, RIGHT(ID_BB_SEC_NUM_DES,1), LEFT(RIGHT(ID_BB_SEC_NUM_DES,LEN(ID_BB_SEC_NUM_DES)-3),LEN(ID_BB_SEC_NUM_DES)-4)+0

I am using System::Data::OleDb::OleDbConnection. I know SQL; the problem is that some SQL code does not work fully with some .NET providers. I will try the database forum.

You have an empty loop here, and it has 'eaten' all your processor in the release mode: while (!!G_OPT.Running); It's not a good way to do such loops for wait until other operation completes. In such cases synchronization must be used, like events, or AsyncCallbacks. See my article about Windows 7 Taskbar timer here on CodeProject

sorry - I was out at the physio and then to dinner, so I didnt get a chance to follow up - iirc, Perc 3/DI is 'Integrated/Internal', 3/DE is 'External' (To The Motherboard) So, the 3/DI Could be disabled (reboot the system, watch the prompts and it should tell you which keys to get into the controller), and a replacment put in - Dell used to use some other brand or make American Megatrends Cards avail on request - these were slightly better becuase they had a Recover Config option. As Jörgen Andersson points out, I think your best bet is still with Dell to start with - Dell have been pretty good to us in the past, (ok, the scale is different, we are a large corporate), but even if you get a replacement motherboard, it would be interesting to copy the raid config without their help (I cant remember how it works/where its stored) If you could lay your hands on another P/E 4600 with motherboard, memory, but no DASD/Disk, you might be able to set it up as per your current system, then move your DASD/Disks across to it At least you have backups, it really depends on what hardware you can lay your hands on - I dont think its a total loss yet. Last of all, I hate to be a p.i.t.a. - keep your maintenance up to date - it might be $$ xyz per year, but how much is this exercise going to cost you in lost productivity, or worse (hopefully not) lost data 'g'

Yes, I already have checked connectionstrings.com. They have examples with Tab, semi-colon, and comma. I have not gotten a space delimiter to work however.

I just found out that there is SQL Server Options -> Query Execution -> Advanced has the option to set NOCOUNT