Yes, I read the question as multiple rows per InvoiceID,...

I would use a unique index on InvoiceID filtered where LineitemNumber is not null;

This way you can have as many Null LineitemNumber rows as you like for each InvoiceID, but...

I can't see anything wrong with that expression, so maybe the problem is elsewhere.

Are you trying to insert that data into another uniqueidentifier column?

The referencing works just fine on 2016, so maybe it was a bug in that version?

Absolutely the right way to go, I just wanted to clarify the problem with the code presented as getting the right data type in a recursive CTE is one of...

You need DECIMAL(4,2), and to ensure the recursive part of the query conforms to that data type...

You can't put 1.00 into DECIMAL(2,2), when you try, this errors:

SELECT @Start=1.00, @End=20.00

DECLARE @Start...

I've not seen any problems lately, thanks.

You can also improve on that a bit Alan, it won't scale at all well (try it for a sample of 700 rows)

I would always try and keep a WHILE...

Hi Robert,

I hadn't noticed that about the delay! I'll check next time whether there are multiple tabs open and check in another browser as well.

For me, yes, the problem only...

robinwilson (9/12/2015)

---

Hello

I recently moved to a new organisation and one of my first tasks was to work out why the main software the organisation uses is, and has always been,...

And another ... over a minute to open a thread at about 01:26 (London) 12 sep 2015

Anyone hear squeaking at around 1:16am (London time)?

I had a long delay when I clicked Reply on a thread, it felt like upwards of 30 seconds or so before...

If this is a one time copy of only ~100 rows, then why go to all the bother of scripting/exporting and importing?

Right click your source table in SSMS, and choose...

I agree with...

Yes, make the documents available on a web page/service or SharePoint.