We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [cross-apply]

The tag has no usage guidance.

3 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
1answer
61 views

is there a way to improve this query by not re calculating functions? cross apply?

when I set up replication I like to take a count of each table in the publisher, then I go to the subscriber I do the same thing in order to compare both pictures. this is the picture from the ...
0
votes
0answers
350 views

Using clustered columnstore indexes in conjunction with non-clustered columnstore indexes

Table A has approximately 500 million records in it and is of the form similar to the following | ID | FirstName | LastName | MiddleName | ------------------------------------------ | 1 | John |...
0
votes
1answer
52 views

How to use reference to another table in aggregate function

I have following easy-to-explain task: we have a table, and we should calculate total count of rows grouped by columns. Column number is fixed so we write: SELECT [GroupId] = cr.[GroupId], [...