You can use tally table. Do a a not in with the tally table and your table.

You can read about tally table here - http://www.sqlservercentral.com/articles/T-SQL/62867/

Ping back if you...

Check this out but it is not simpler than Dave's solution. There are no assumptions here. I assume that if you have a group classification, you would like a Group...

Chandradyani (3/26/2010)

---

Dear Arjun,

Well, I still don't understand. If I should got that result like that from DB then I don't understand why I got to pivot that query?

Is there any...

I am guessing here, aided by faint memory from a past experience. So you may want to check this with someone who is better equipped.

If you need to display it...

Can you post some data?

The input data as you get from DB and the output as you want to display it in SSRS.

- arjun

Ok, i see. Let me check around. But i think it won't be possible straightaway.

- arjun

Paul White NZ (3/25/2010)

---

Ah, I see! Thanks for clarifying that. Just for completeness, all we...

Do you need this row-wise?

By 'this' I mean

xxxx

Productname unitprice

pppp 50

zzzz 10

yyyy

Productname unitprice

qqqq 20

If you need it column-wise, you can simply add a group by in your table or matrix. And...

If you expect an answer, you should do better than that Mr Raja.

- Arjun

Cool, just let us know if you face any roadblock.

-Arjun

Check out the following query to get a hang of pivot. It is part of a solution that i suggested for a post.

When you run it, you will get to...

Hey no problem buddy 🙂

You can use tally table and pivot to get the output mentioned. I don't have much time to give you a query as of now. I could probably post a...

If you want the data in separate columns, try this:

create table #t(customernumber varchar(10), notes varchar(10), lastvisitdate smalldatetime, nr int)

insert into #t values(100000, 'text 1', '10.feb.2010',1)

insert into #t values(100000, 'text 2',...

Did that solve your problem Jagger?

I don't quite understand what you mean by

If the...