Recent content by jcisco2

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!

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

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