Does that mean all the orders will get the same invoice numbers?

J Livingston SQL (5/19/2016)

---

yahya-236450 (5/19/2016)

---

Hi

First time they would all be null then we start with Invoice No = 1 for first row that falls under the criteria when the query...

J Livingston SQL (5/19/2016)

---

bit confused...are you saying that initially every row in Orders table has the InvoiceNo as 'NULL' and then based on a specifc WHERE clause you want an...

Hi Kevin

Invoice numbers are assigned when the above query is run on order delivery etc. Before that invoice number has no value. We can start with zero value fro invoice...

Hi

First time they would all be null then we start with Invoice No = 1 for first row that falls under the criteria when the query is run and then...

Hi Drew

DDL and DML code below.

Your first link end up at the MSDN Order By page; https://msdn.microsoft.com/en-us/library/ms188385.aspx?f=255&MSPPError=-2147217396

Regards

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Orders](

[ID] [int] IDENTITY(1,1) NOT NULL,

[DeliveryDate] [datetime] NULL,

[InvoiceNo] [int]...