Hmmm....these solutions would work if "CustomerFomm" is always followed by "CustomerDOB", but I don't think we should take that as a constant (without input from the OP). Once you've...

Atrributes are data which are important to the parser, while elements are important to the reader. Think of attributes as information about the data in the XML structure, while...

We've been doing this for several years now in our IT shop. We call it the "Champions Program" and it gives people the opportunity to dive in to something...

I used to work for Harley in the IT department at their KC plant and all employees had to have a Continuous Improvement section, with a minimum of three items,...

The customer who doesn't know what they want:

http://dilbert.com/strips/comic/2006-01-29/

I'm a "grey beard" and I've run my own shop several times. I've always insisted on detailed specifications, signed off by the...

Especially since the OP says:

"for example I have a state column and the values are as;

Ohio

Virginia

Chicago

Florida "

I'd say they have other issues if they have a state of "Chicago" in...

Another useful variation of the INSERT command is the "SIF" format to create a table with fields based on the source table:

SELECT Id, Name, Quantity

INTO SomeOtherTable -- Or...

For example...

-How do want the data from the server to be shown on the PC? Flat file, XML, Excel, CSV, what?

-Do you...

^^^^^

HA! That's exactly what I was thinking! CALENDAR <> CALENDER

(Maybe he drives around in a Camero, too...)

Ephesoft is one that I'm aware of. A team here is working on implementing it to capture information from incoming invoices. There are plenty of others out there...

Another alternative, if you don't want to roll your own solution, is to look at the many document management systems out on the market. Most of them have a...

Just got back from vacation (5400mile motorcycle trip) and had a Rasputin Russian Imperial Stout in New Orleans that was very good.

I've used both Business Objects' ETL tool (Data Integrator/Data Services) and SSIS, and there are strengths and weaknesses in both. The following are my opinions; it's been a year...

There are multi-billion-dollar companies (Cerner, for example) whose sole purpose is to create hospital management systems that cost hundreds of thousands to millions of dollars. It sounds like you're...

^^^^ This is exactly the kind of attitude we DON'T want to have in these forums. I'm sorry @bhuvneshk, but we don't want to confuse laziness with misinterpretation and...