Hi ,

Yes, that is exactly what I was trying to achieve.

Thank you so much !

----------------------------------------

stiil not clear...........

is this the expected output ...eg a table of results?

USE [tempdb]

GO

CREATE TABLE [dbo].[TBL](

[Cust...

Okay , let me give you another example.

In BANKING :

Joe Bloggs has 3 different type of accounts at the same bank.

He has a 1) Credit Card 2) Cheque Account 3)...

LOLz .

Nope its not.

Its actually a learning curve ( Cold Coffee nailed it ).

I am using this ficticious example so I can apply it to real live data.

So, once I...

Sorry for being ambigious ....

Ignore the | characters , that was just to seperate the data.

So, I need it to be

Paul Oranges ...

Hi,

Your output is correct. I got confused with my own fictional tables. 🙂

But I am still looking for an output like below.

Peter| Apples | Plums ( No NULL Value inbetween...

Hi PG,

I still get the Items in the wrong place.

NAMEDistributorID123

Peter1 1 NULLNULL

Paul2 ...

Welsh Corgi (9/12/2011)

What if they decided that they want to start selling more than six types of fruit? 😀

What if they decided that he wanted to...

😀 Munches Away

Great Reply thanks !

/me Adds some more to the Learning Curve .

:w00t:

Okay I made the NULLS go away but it still not correct.

NameFruit1Fruit2Fruit3Fruit4Fruit5Fruit6

PaulOranges

PeterApples Plums

Thanks ColdCoffee, I get the following answer

Actual Output

NameFruit1 Fruit2 Fruit3 Fruit4 Fruit5 Fruit6

Paul:NULL:Oranges: NULLNULLNULLNULL

PeterApples:NULL: Plums NULLNULLNULL

Which brings me to the...

@ Welsh Corgy

Hi,

Thanks for your reply.

The post was just a " example " ( made up ) database.

The real DB is more structured and has all the suggestions that you...

Its a Learning Curve 🙂 So I am still working on it, but you have pointed me in the right direction....

Nope, not homework. A newbie question 🙂

Thanks for the help. This will help me a lot .

😀

Maximum of 6 Fruit.

Okay, time to figure this out then.

Cheers !

😛