I have included all data from the table and this is really enough!

This seems a cubic structure.Right?

I think this is not important.The major point is

How can I get

"results" columns as data cells

"StoreID" columns as Columns

"Question" columns as Rows

Is this a multidimensional query? I really dont...

Thank you very much..That's it...

Hello Again,

When I try to add another where criteria then the query does not select the NULL values.

I have changed the code as below:

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

SELECT     TOP 100 PERCENT DATENAME(mm, dbo.MyMonth2.MatchDate) AS...

Hello Again...

Both solutions work like a well designed machine!!!!! Thank you very much.

Yes..You are exactly right.I am trying to get them by day..(including NULL values)

Thank you for your attention

Thank you very much for all friends,

We will enter road distances into a table and then the shortest path info will be calculated from this table.So all your comments will...

I want to show modified column with its original value.That's all..

For example there are some modified values which belong to same OrderID. I want to combine two results into one...

How can I determine the original record value by using a database trigger on SQL Server?

Any idea?

Thank you Karl....You gave me a real starting point

I came to the office right now and applied your solution immediately.

It works like a well designed machine! Thank you for all...And SQLZ, thank you too!

The problem is some voyages include one driver and other voyages include two drivers.

I have already designed a database architecture that works well. And this is final step.If I could...

Wow...really good results...

Is it possible to move a column from second row to first row? I mean suppose that I made a basic select operation and got the result as...

Thank you very much..

This is the solution!!