Search results for query: *

I wrote the following query to update a table in a mysql database from sql server. I cannot figure out why this wound up updating the updatedate field for some 3000 records on the linked SQL server. It should have been the source of updated fields. I can't tell what it might have updated, if...

Hello, I'm creating a webservice for a customer. I have a small problem - prefer that a domain account be used to authenticate users before the access this service, but they don't have anything suitable in their domain. Seems to me that a domain user that isn't given access to anything except...

I need to create an XML file that looks like this: <ShipControl> <CarrierIdentifier domain="SCAC">FDE</CarrierIdentifier> </ShipControl> I have: Partial Public Class cXMLRequestShipNoticeRequestShipControl <System.Xml.Serialization.XmlElement()> _ Public CarrierIdentifier() As...

VB.net 2008 service, trying to write a file to a directory on another server. I've tried both Dim Filestrm As New FileStream(OutputPath, FileMode.Create, FileAccess.Write) and a simple file copy after writing the file locally first; both get me an "Error 5: Access to the path '(outputpath...

My customer had a certificate on their server 2003 machine. It was called when encrypting and decrypting credit card numbers. The machine inconveniently went kaput this week without warning. OS is apparently trash. We have everything running again, but have no way to access the old credit...

I have XML Data that looks like this. <?xml version="1.0" encoding="UTF-8" ?> <CustomerMapping xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <CustMap NetworkId="AN01000018306-T" CustID="Testing" /> <CustMap NetworkId="AN01000018304-T" CustID="Nobody" /> </CustomerMapping> Over...

I have a new service that watches a directory for new xml files and takes action when one is added/changed. When I add the following code, I find that once I save a file in the watched directory, I'm no longer able to access it. My service has it locked up. Offending code: Dim xpathDoc As...

I need to use a schema in Visual Studio, and VS requires it to be an XSD. I've not done XML in VS before (I'm really a SQL person that used to be a programmer and now I get to wear more hats). I've used both XMLSpy and xsd.exe to convert a DTD to an XSD. But when I do, it always creates THREE...

God, I hate being a newb again! I have successfully avoided all this web-service stuff that started in with programming when I jumped from being a standalone VB6 app programmer to a SQL person. But it turns out that while I've been gone from the developing world, things, um, changed. I need...

I have an xml file for "orders" provided by a customer. This file format is set-in-stone and will always arrive this way. I have an ERP system that can accept an xml file for "orders" in a particular format. Obviously, these formats are not the same. I have used Altova to create an XSLT to...

I have a view that combines shipping information. Worldship calls this view through a map set up in its own program. My customer requires that the shipments import in a specific order. To do this, I set up the view to "select top 100 percent" ... "order by salesorderno, itemid". This used to...

Trying to understand the behavior of between here. I thought that the wildcard % meant 0 or more characters, but I'm running into something I don't quite understand. create table #table1 (nothing int) insert into #table1 values (1) select * from #table1 where 'a' between 'a%' and 'b%' This...

I have a query that spikes the CPU. Working on optimizing it but that's taking awhile. (It only reads - no writes). Is it possible to assign a low priority to this query so that other people can get their work done while this runs in background, even it takes longer? I don't think there is...

I have a view that has been running for six months with no problems. Suddenly today it stops working. I have a table tsoPackage that has a packagekey int. I have another table (call it tableB) with a packagekey varchar(20). They both must be this data type -- an application requires...

Is there a SQL command that will provide a list of views that reference a given table or view? Here's my problem: I added a column to a view in a production database. Normally I don't like to do this, but it's an eensy-weensy change, I've done it before, and they really needed it. And it's...

I have base tables that look like this: table tglAcctHist glacctkey fiscyear fiscper beginningbal creditamt debitamt table tglAcctHistAcctRef glacctkey acctrefkey fiscyear fiscper creditamt debitamt In table tglAcctHist, beginningbal is only given for fiscal period one in each fiscal...

I have an xml file that I am converting to a new xml file. Currently I'm creating an xslt file with MapForce to do this. My issue is that my source file contains data at low-levels of the file, and my destination needs that data grouped at high-level: Source <Receipt> <Receipt Header>...

I started this message on the general SQL programming forum and was referred here... I am working with an application that allows me to run custom VB Scripts. I need a script to take an excel sheet, load it into a SQL table, and then run a stored procedure in the database. However, I can't...

I have a table in SQL that needs to be updated or inserted to based on a given excel sheet. Table Item Price1 Price2 ---- ------ ------ ItemA 3.00 4.00 ItemB 2.99 3.99 Excel A B C 1 Item Price1 Price2 2 ItemA 3.00 10.00 3 ItemB 1.99...

I have an xml file that I am transforming via xslt into another xml file. The new xml file must be in a particular format in order for a calling program to load data, so the xslt is putting it into that format. I need the xslt to preserve null values, though. Right now, if there's no value for...