Kriki’s Dynamics NAV blog

I just read something very interesting:
Backup compression is available in SQL Sever 2008 R2 Standard!  Read more
That is very good news. No more need for Enterprise version for backup compression!
This is the feature I like the most in SQL 2008!
It speeds up backups (most processors are idle anyway) and it takes less time to […]

Filed under: Uncategorized | 3 Comments »

And now that I am busy with recursion:
– recursive CTE to generate numbers like the NAV date table
DECLARE @from AS DATE;
DECLARE @to AS DATE;
SET @from = ‘2009-01-16′;
SET @to = ‘2009-03-20′;
WITH DateTable ([The Date]) AS
(SELECT @to
UNION ALL
SELECT DATEADD(DAY,-1,[The Date])
FROM DateTable
WHERE DATEADD(DAY,-1,[The Date]) >= @from
)
SELECT *
FROM DateTable
ORDER BY [The Date]
OPTION (MAXRECURSION 0)
See also the forum

Filed under: NAVISION, SQL | 1 Comment »

If we want to loop on integers in NAV, we can use the integer table and put some filters on it.
The problem is that in SQL, we don’t have such a table.
It is possible to create the table with a recursive CTE (Common Table Expression).
If you want, you can also put the select into a […]

Filed under: NAVISION, SQL | Make a Comment »

I just got some strange error using STRSUBSTNO:
The text ‘…’ in STRSUBSTNO parameter no. 1 is too long.
Surprise : Is the string I give already longer than 1024 chars? But shouldn’t I have got an error when assigning that value to my variable that I sent into STRSUBSTNO?????
I was wondering if STRSUBSTNO was still limited […]

Filed under: C/AL, NAVISION | Make a Comment »