No problem. Don't forget to shape your sample data so that...

In grown-up SQL Server folks often use

RAISERROR('Almost instant screen print',10,1) WITH NOWAIT;

rather than PRINT.

mario.balatellii (12/7/2011)

---

Hi Chris ..is it possible to get the output in a different way.

I want the heading to be like

TYPE BANKNAME ...

Rixxe (12/7/2011)

---

ChrisM@Work (12/7/2011)

---

Let me ask another question. This looks like a single step in the creation of a complex cross-tabbed report. Is this the case?

If so, is the data you're...

Ah, an overrun, from the bit which records the position in the substring of '='.

SELECT

[No.],

MsgType,

MsgTimeStamp,

split.Item,

Pos,

en.[Entity code],

en.[Entity name],

Attribute

FROM #SampleTable s

CROSS APPLY dbo.DelimitedSplit8k(s.[Description],'') split

CROSS APPLY (

SELECT...

It's possibly worse than that:

56=DEB 34=293131=0018000 47992N1 297=5

There are clearly defined entity-attribute pairs at the beginning and the end, but what's in between? Even by eye it's not possible to...

Could be tab. Try copy-paste into a function:

SELECT ASCII('')

SELECT CHAR(7)

Copy and paste the space between the quotes in this - SELECT ASCII('') and run it in SSMS.

You're welcome.

The function looks up to date. Where are we with this? Did you change the sample data to uniquely identify each row?

It's fine for now Mario. There's a slightly newer, faster version, I'll find a link. Or the code.

Many thanks, Mario, that's just about perfect. Here's your table integrated into that code I posted earlier. First thing you will notice is that the data requires partitioning - there's...

Let me ask another question. This looks like a single step in the creation of a complex cross-tabbed report. Is this the case?

If so, is the data you're inserting into...

Have you tried running the sample table code?

INSERT...SELECT will insert rows from the output of the SELECT. If there are no rows returned by the SELECT, then no rows will be inserted.

In your case, you want...

Heh Mario, take a look at the second paragraph in the forum etiquette article I pointed out to you! You might then read the third 😛

Hi Paul

Have a read of Gails blog post on the subject of non-existence here[/url]. Armed with your new knowledge you will choose the best option.