[font="Comic Sans MS"]CRM 2011 uses sequential ID's to number invoices. Instead of merely relying on the next IDENTITY value, CRM calculates and stores in a table the next number available...

TheSQLGuru (6/1/2015)

---

When I want to test the server performance of a large set I usually do it thusly:

declare @var1, @var2, @var3, @var4, @var5 (appropriate definitions here)

SELECT

@var1 = rt.TransactionID,

@var2 =...

Jason A. Long (5/29/2015)

---

j-1064772 (5/29/2015)

---

Eirikur Eiriksson (5/25/2015)

---

[font="Comic Sans MS"]Sinking feeling of...

Eirikur Eiriksson (5/25/2015)

---

[font="Comic Sans MS"]Sinking feeling of reverting back to newbie...

[font="Comic Sans MS"]To Mr. Luis Cazares

I am impressed with the extra effort you took in creating the demo table and test data for the original poster struggling even with the...

[font="Comic Sans MS"]Went for these links you provided and played around a bit with the ROW UNBOUNDED part I had neglected.

[/font]

[font="Courier New"]DECLARE @Tbl TABLE

(

pk BIGINT not...

Thanks for the link to newest string splitter.

The second version has also taught me a lot.

I have been trying to complete the function so that it would return as separate "words" the characters between each delimiter (a...

GilaMonster's warning about poor performance and the link mentioned rates as a most useful answer.

From a total newbie to the fancy world of OData and services: Wunderbar !

So, what is the next step ?

In the meantime, just comment out the 4 lines dealing with the filegroupname, the rest works.

In fact, I would suggest you add Microsoft's own comments on installing 64-bit office

https://technet.microsoft.com/en-us/library/ee681792.aspx

I suggest that you include your reply about the 64-bit in your main article as "qualifier" about your recommendation about using 64-bit - right where your readers can see it,...

Thank you for the code. Just added TOP 500000 to the select statements so I can stay with the 32 bit Excel.

Regards

Great introduction. Thank you.

One thing though: 64-bit Office. The IT manager here views it as nothing but trouble. Incompatible with most other software. Better installed on a separate machine and...