SQL Server Performance problem created by the ORDER BY statement

Today I had a problem with a table that has around 5 million records. The table has as primary key “Header No.”,”Transaction No.”.
In the table is a field “Order No.” that at the moment is blank for all records.
I also had an index on that field, because I will need to search for it. I […]

Does this code work or not?

It does compile without errors. But does it also run without errors?
datshipmentdate := 01072012D;
intDateDec := 9999;
intDateDec := (CREATEDATETIME(”datShipmentdate”, 0T) - CREATEDATETIME(010180D, 0T)) / 86400000;
MESSAGE(’%1′,intDateDec);
I’ll give the SQL answer (even if SQL has nothing to do with it): it depends.
It works on 4.0SP3 Build 25638,5.0SP1 Build 26084.
It gives an error on 5.0SP1 Build 30488,NAV2009 build 27808,NAV2009SP1 […]

Bad news about Convergence EMEA 2009

We had an MVP lunch and Kipper York told us that she read yesterday that the Convergence EMEA 2009 has been cancelled. I searched on internet and found some sites with more info.
 
More info:
http://www.microsoft.com/dynamics/convergence/vienna09/default.aspx
http://msdynamicsworld.com/story/dynamics-ax/microsoft-cancels-next-dynamics-european-convergence-event-save-customers-money

The future of Dynamics by Jan Sillemann/Dan Brown

“Directions was a great success.” This is not my statement, but I definitly agree!
Directions EMEA can become bigger then Directions US, because we have a very big community.
MS business solutions guiding principles
-build most recognizable brand in business applications market
-deliver most innovative&easily adaptable platform of ISV’s
-preserve our customer and partner investments while strengthening their overall experience
-enable […]

Create a new blog and join in the fun!