I'd like to see an analysis regarding the offshore projects (in relative number and relative volume) distributed over the various types of companies (e.g. family-owned enterprize, a stockholder company or...

Unfortunately, your sample data and expected output doesn't really match and there was some fine tuning required to get your sample data inserted (wrong column order).

But here's what I came...

Now, all that's still missing are some sample data (in an INSERT INTO SELECT format) to play with that would match your expected result so we have something to test...

No problem.

The reason why some of us tend to add the "duplicate post" information ist to make sure the answers are all within one thread. That makes it easier for...

If you would provide table definition, sample data and expected result in a ready to use format as decribed in the first link in my signature I'm sure there will...

duplicate post.

Discussion already started here.

Lowell (6/1/2010)

---

CREATE TABLE [Test] (col1 bit)

DECLARE @endDate datetime

SET @endDate = DATEADD(hh,8,GETDATE()) -- 8 hours from now

WHILE GETDATE() < @endDate

BEGIN

INSERT INTO [Test]...

Ok, here's what I came up with: It's a "double self referencing" table.

The first one (sub) is used to eliminate consecutive rows and the second one (final select) gets the...

I've been trying to come up with a self referencing solution, but I'll give up now since I won't be able to come even close to your solution. :crying:

Jeff Moden (5/31/2010)

---

That seems to loose the bubble when the ranges on the same...

I'm not sure if this is the fastest way, but at least it's an option... 😉

;

-- unpivot and group the values

WITH upvt AS

(

SELECT Val

FROM

(SELECT START,[END]

FROM @rangeTable)...

Please be a little more specific regarding the table/data structure you want to insert.

Otherwise, you might see a script like the following to enter a few thousand rows into a...

You're very welcome 🙂

daniarchitect (5/30/2010)

---

Unfortunatley our company uses DB2 as main database ,

but they have sql server on side which is version 2000.

I ask apology for posting it here,but that was the only...

You need to use the real file names instead of @txtFile and @xmlFile.

The following should work:

SET @SQLString = 'INSERT INTO competition (Competition_ID,Competition,Title,Parent_ID) '

+ 'SELECT Competition_ID,Competition,Title,Parent_ID '

+ 'FROM OPENROWSET(BULK '...