Hi

I agree with Lutz. An XML file does not contain enough information to create tables from. You may need an XSD for this. As you say you are currently experimenting...

Always welcome! That's the reason for sample data! 🙂

DECLARE @t TABLE (Name VARCHAR(30), Reading INT, Result INT)

INSERT INTO @t

...

I remember a case my apprentice told me from one of his teachers, the "IF-loop". Sure a slip of the tongue, but anyway:

DECLARE @i INT

SET @i = 1

START:

PRINT 'Hello'

SET @i...

Kavin (4/11/2009)

---

Yes I can also think the different ways of approaching a problem. As I am new to SQL I hope this website will teach me a lot and correct...

You're welcome. I only did the start-up, Barry found the solution!

I just came back from shopping and intended to start the .Net Reflector to play Sherlock Holmes... So I put...

Hi

Try to handle it with a PIVOT operator.

Greets

Flo

PS: Maybe have a look to the "Best Practices" link in my signature for posting sample data and DDL. This always increases the...

Hi

And a completely set based solution:

DECLARE @t TABLE (Name VARCHAR(30), Reading INT, Result INT)

INSERT INTO @t

SELECT 'UNDRI',...

Hi

Sure you don't know all possible objects (forms) to be created but maybe there are many common business processes as "Claim", "Order", "OrderPosition", "Shipment", "Physical Unit", "Contract", "Partner", "Customer", "Contact",...

Hi Pez

If you just need the available drives try this:

using System;

using System.Collections.Generic;

using System.Data;

//using System.Data.SqlClient;

//using System.IO;

using System.Linq;

using System.Text;

//using System.Net;

using Microsoft.SqlServer.Management.Smo;

using Microsoft.SqlServer.Management.Common;

namespace ConsoleApplication1

{

class Program

{

...

Hi

In SQL Server 2000 I think there is no set based solution. You have to work with WRITETEXT function:

CREATE TABLE #t (Id INT, Txt TEXT)

INSERT INTO #t

...

Hi

The GOTO should always be one...

Hi

An EAV database structure is by design a performance issue.

Maybe you can design a hybrid solution. You create tables for all (or most) possible objects which have to be represented...

Hi jignesh

If you use an IDENTITY column it will be incremented automatically and you can get the value with SCOPE_IDENTITY() function. If you don't have an IDENTITY column use a...

Hi

Try this link:

http://msdn.microsoft.com/en-us/library/s0fk6z6e(VS.80).aspx

Hope this helps!

Flo

Stupid question:

Is the user account configured in SQL Server as login and as user for the database?

Did you try to connect locally with the windows account?

Greets

Flo