Search results for query: *

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

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

I have a view that i'm setting up. the query works but i would like to add a qty that is rolled and subtracted out per line. An example is: say i have item 11081 with a qty of 100, and i have two orders that ask for that item. one asking for a qty of 70, and the other asking for a qty of 40...

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

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

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

ok i'm going crazy here. i'm praying that someone can help me. please... i sooo new at c++ and i have a deadline looming. i bagged the socket idea. I thought i would try my next thought on application communication. which is MSMQ cause i know how to use the MSMQ through vb.net very well. I...

I have a C++ client app that needs to communicate to a vb.net server application via a socket. I found some code that shows me how to create a c++ socket and send data.The connection seems to be working, just the sending of data is off. On my vb.net server application i see that a connect was...

I am trying to create application dashboard for our internal applications. This dashboard will have to load up user controls all of which were wrote in VB.Net. Right now i have to go into my application and manual add the reference to the new user control (dll) and then add the link code to...

I am trying to write a query that will find all the items found in one table but not in the other. For example say i have two table as such: Table 1 ------- item1 item2 item4 item1 Table2 ------ item3 item2 now i would like to query my tables in such a way that only item3 shows up in the...

I need help rolling up some numeric data from my tables. what i have is two tables. One holds a Unique pallet ID/Location, the other table holds the items on that pallet and the qty's. now when i run this query select tblPalletInventory.ItemNumber as ItemNumbers...

I have a question about SPROC best practices. I have read that you should never name your SPROCS with a sp_ as stated: "Do not prefix your stored procedure names with "sp_". The prefix sp_ is reserved for system stored procedure that ship with SQL Server. Whenever SQL Server encounters a...

I have a question about SPROC best practices. I have read that you should never name your SPROCS with a sp_ as stated: "Do not prefix your stored procedure names with "sp_". The prefix sp_ is reserved for system stored procedure that ship with SQL Server. Whenever SQL Server encounters a...

I was reading a article on best practices found here: http://www.extremeexperts.com/SQL/Articles/BestPractices.aspx and i have a couple of questions from this article i hope someone can give me a better explanation/example. On number 5 it states "5. Analyze deadlocks Access your tables...

I need some help with encoding a text that is a textbox. The encoding char set that i need to use is 437. example of the set can be found at http://www.georgehernandez.com/xComputers/CharacterSets/OEM.htm What I have are some line printers that take in ascii text and create a label from that...

I am having a problem reading in a pcx file, and sending it's binary data to a printer. I have a printer class that takes in a string with no problems. but i am having a problem converting the image here is what i need to accomplish. "to send the data in binary format, the software must convert...