Viewing 15 posts - 1,816 through 1,830 (of 2,645 total)
CROSS APPLY is a row level operator. So your table_valued_function will be run once for each row the rest of the query returns.
So my guess is that the query:
January 14, 2019 at 10:35 am
January 14, 2019 at 7:06 am
January 14, 2019 at 5:06 am
January 14, 2019 at 4:24 am
Your jpg file attachment is showing a later date for CF, is this what you meant. I've assumed you didn't?
Here are two different ways to get the results:
January 14, 2019 at 3:52 am
This is an example where De morgan's law can be applied.
(not A) AND (not B) = not (A OR B)
So the expression
...
January 12, 2019 at 11:49 am
January 12, 2019 at 8:29 am
January 12, 2019 at 7:45 am
If you have performance problems with a query like this it's probably due to missing indexes. Do you have indexes on the tables?
Have you tried executing a query and...
January 12, 2019 at 7:17 am
If you run the stored procedure with SET STATISTICS TIME ON you will be able to work out which statement(s) is/are taking up the time.
January 11, 2019 at 6:48 am
;WITH CTE AS
(
SELECT UserKey,
COUNT(*) Count
FROM UserTable
GROUP BY UserKey
)
January 11, 2019 at 2:25 am
I would also take the elapsed times of the query.
What is the query you were running?
January 10, 2019 at 6:17 pm
January 10, 2019 at 10:33 am
Viewing 15 posts - 1,816 through 1,830 (of 2,645 total)