Search results for query: *

still wondering what the correct solution is. I thought of another way use streamreaders/writers. that worked out just fine. Cheers,

I'm wondering how to add a new xml node to an existing xml file. then remove it. Heres why. I have a grid that allows a user to save a profile as an xml doc. The user can then load up that profile at a later time. what i would like to do is add one node to this profile so before the profile...

thanks for the info. Here is what I went with. I'm now storing a large sub set of my data in excel (right now it's like 30,000 rows. Think excel has a max row size of ~63,000+ rows. Then I query off excel via a OleDbDataAdapter this works very fast over the xml. Cheers.

I'm having issues on reading in large amounts of data (about 713,162 KB) into a dataset. When I try to it takes a really long time to load, and i get an out of memory exception. Is there better way to view large datasets offline? This data is sales data thus the size. 'gl vars Private dSet...

I'm wondering if it is possible to pull out a distinct resulting set when the data is structured like this: --raw data part Number transType qtyReq qtyRec 1 ISS-SO 2 -2 2 ISS-SO 2 -2 3 ORD-SO -1...

I have a table that has the values of: PalletID, and TransactionType (plus some other data) but what i want to do is have a query that pulls PalletID that only have a Transaction Type of C and 4. (all tags have this data) here's an example of what i'm looking for. PalletID transType 1...

I'm creating a temp table to hold various data from multiple tables. and I'm having a problem with one statement (see code section) in the v_PlannedProduction table it can hold the same item number twice with more than one start date. All i need to do is get the first instance of the start...

thanks!

...resulting 60.. the result set looks like this thus far: select A.OrderNumber, A.PONumber, A.OrderStatus, REPLACE(A.CustomerNumber, 'WALBEN0', 'WAL*MART') AS CustomerNumber, A.ShipToName, REPLACE(A.WarehouseID, 'B03', 'BEL') AS WarehouseID, B.ItemNumber, B.QtyOrdered...

is a sproc faster than querying the view?

nevermind i'm just having a day all ready. select and query my view. which crystal was already doing. i just wasn't passing in all my parms to my crystal report. it was my error. sorry. SELECT v_OutsideBOL.UPC, v_OutsideBOL.ItemNumber, v_OutsideBOL.ItemDescription, v_OutsideBOL.Qty...

i have a crystal report that calls a view on my sql server. the query runs just fine.. but the table is getting a wee bit to big so its starting to hang my report. what i would like to be able to do is pass in a where statement into my select statement, example WHERE F.OrderNumber = '0050517'...

I have a xls file that i wish to import into an existing table. the xls file holds the cols OF: Item Lot tagNumber, and Qty. what i would like to do is import this file via a DTS package. but i have to run each one of these fields in this file through a data scrubber first (which is a sproc i...

got it (sum(cast(B.Quantity as int)) / E.PercentUnitLoadMult) as Unit

I would like to roll up the qty in my Details table and / that by a number by another number stored in another table. the statement checks out when i parse it. but when i run it. i get the error Invalid column name UnitLoads. any suggestions on how to roll up a qty and / it by another value...

...on the shell first. but for some reason i had it in my mind that the args had to be passed with the app string. boy was i wrong. solution: char* result3 = "C:\\client.exe"; stringstream strNew; strNew << _position << " " << pair; HINSTANCE HINSsd = ShellExecute(NULL,"open", result3...

...HINSsd = ShellExecute(NULL,"open", strNew.str().c_str(), NULL, NULL, SW_SHOWNORMAL); //execute it. which nothing happens. I have tried this. char* result3 = "C:\\client.exe 1 12"; HINSTANCE HINSsd = ShellExecute(NULL,"open", result3, NULL, NULL, SW_SHOWNORMAL); //execute it nothing happens...

I'm wondering how to occumiplish this task in C++. what i would like to do is pass two values to another exe. but Every time I go to compile this application I get an error that tells me that I can't add to pointers together. The function with the problem is TS_function on the ShellExecute...

...on this it will be a great help. Or if i need to clear up anything i would love to. thanks. HRESULT SendMessage( WCHAR * wszQueueName, WCHAR * wszComputerName ) { // Validate the input strings. if (wszQueueName == NULL ||...

...return CS_ERROR; } //Fill in the sockaddr_in struct SOCKADDR_IN serverInfo; serverInfo.sin_family = PF_INET; serverInfo.sin_addr = *((LPIN_ADDR)*hostEntry->h_addr_list); serverInfo.sin_port = htons(8888); rVal=connect(theSocket,(LPSOCKADDR)&serverInfo, sizeof(serverInfo))...