Viewing 9 posts - 31 through 39 (of 39 total)
It's not a question of there being an advantage of one over the other, since they do different things. CROSS APPLY is very similar to INNER JOIN, but with the...
May 25, 2016 at 6:21 am
Todd Reddinger (9/2/2015)
handkot (9/1/2015)
I think the same thing
AS AliasAndAS 'Alias'also i can write
AS [Alias], or write CTEso there are only three ways: "=", "AS" and column
+1
I agree...
September 3, 2015 at 6:23 am
I didn't see a correct answer. The table is created with PK, which implies an index. A CLUSTERED index is created. Both indexes are active. The first insert works (why...
June 10, 2015 at 5:58 am
I think I prefer [/url] as a better reference for character naming.
0022, ", is QUOTATION MARK.
0027, ', is APOSTROPHE.
The other two you mentioned are 2017 and 2018, LEFT and RIGHT...
May 28, 2015 at 5:20 am
So it does. I read through it several times, and didn't catch it. D'oh! Thank you Hugo. I must stand embarrassed for the appropriate amount of time.
May 14, 2015 at 6:20 am
Interestingly enough, the documentation on CREATE PROCEDURE don't say anywhere, that I could find, that it had to be the the only statement in the batch. The links provided in...
May 14, 2015 at 6:11 am
This looks like Dynamics AX, right? It looks like you don't have enough conditions in your JOINs.
The first join, from LedgerAccountCategory to LedgerTable, is on DataAreaId only. This means, within...
May 8, 2015 at 6:53 am
paul 17028 (5/6/2015)
Hi... I have been looking around and I have found this "collate Latin1_General_CI_AS" but I have bean unable to implement it if it is at all possible. ...
Your...
May 7, 2015 at 6:26 am
Actually, I'm wondering if many who got the previous post wrong was because we weren't familiar with the '^' operator. I incorrectly assumed it meant exponentiation.
Granted, not useful in everyday...
December 8, 2014 at 6:56 am
Viewing 9 posts - 31 through 39 (of 39 total)