You are not 🙂 no problem.

As the message says, you can not create ordered view. Ordering has to be done when selecting from the view. You have to leave out the...

OK, that's precisely it. I warned that it only works on posted data... from posted data it looked like the issue id's increase with time.

Try this one:

select  oc.oc_id, i.issue_id, i.issue_date,...

Only now I realized that I should have taken the issue_id (not date) to find "next" row - according to ORDER BY clause. I supposed that the issue_id for higher...

Data as posted:

create table oc (oc_id int)

create table issue (oc_id int, issue_id int, issue_date datetime)

insert into oc values (10)

insert into oc values (25)

insert into issue(oc_id, issue_id, issue_date) values (10, 1234,...

You could find some relevant info or useful links in this discussion:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=274719

... or search the forums for more discussions about this problem. It appears periodically - as most questions...

Hello,

did you post all relevant data in both tables? If yes, then I don't understand why do you want to display the two rows in the result, but not

15/02/2006  | ...

Hi,

it has to be really special database, because I can hardly imagine how all tables can have the same structure... and to be honest it looks like the design of this...

Yes it can be done. It is maybe a bit questionable way of displaying the data, but you can do it.

I suppose your table for Order Lines has line number, or some...

Hello,

I have slightly modified the test data, so that I could ignore the time part and work only with the dates - instead of GETDATE() I entered DATEADD(d, DATEDIFF(d, 0,...

Just a little warning... what do you mean by "first row"? SQL Server does not have any info about order of the rows. Sergiy wrote the query so that it returns...

Ephriam,

I have tried to find out what you need, but I failed. I agree with Pam, that you need to explain more about the situation and required results, if we...

Hello,

I don't think it will be that simple. As I understand the question, this is not just order by - I don't have time at the moment to check it properly, but...

Thanks Michael for catching the grouping, I forgot to clear my GROUP BY after I removed columns I had there for verification purposes. It really is enough to group on...

Hard to answer the question in article... I don't like either of the two variants of solution. Generally, I would prefer Solution1 because of its simplicity, but in my opinion...

We are using maintenance plan, ie. sqlmaint component for the optimization that includes index rebuild (shortly described as "reindexing" in my previous post). For this operation on our database it...