Question

How to convert a Cross Apply to a Pivot for Performance reasons

score 67 · Answer 1 · 2024-01-03T16:35:44.497000

67

Views

How to convert a Cross Apply to a Pivot for Performance reasons

Published on 03 January 2024 at 16:35

score 62 · Answer 2 · 2023-11-11T06:43:21.487000

62

Views

SQL Unpivot Rolling Date/Week Calculation

Published on 11 November 2023 at 06:43

score 112 · Answer 3 · 2023-10-27T16:20:10.063000

112

Views

Cross apply: Select vs Values

Published on 27 October 2023 at 16:20

score 742 · Answer 4 · 2023-09-08T11:42:51.897000

742

Views

Is there a way to use CROSS APPLY from SQL to Spark SQL?

Published on 08 September 2023 at 11:42

score 42 · Answer 5 · 2023-07-03T15:50:43.967000

42

Views

Add new variable in where clause with cross apply

Published on 03 July 2023 at 15:50

score 324 · Answer 6 · 2023-06-27T20:20:04.760000

324

Views

Using CROSS APPLY to more easily "UNPIVOT" a wide table in Snowflake?

Published on 27 June 2023 at 20:20

score 68 · Answer 7 · 2023-06-07T14:16:03.257000

68

Views

SQL cross apply and unpivot function

Published on 07 June 2023 at 14:16

score 89 · Answer 8 · 2023-05-09T12:42:07.043000

89

Views

The LINQ expression could not be translated in CROSS APPLY

Published on 09 May 2023 at 12:42

score 216 · Answer 9 · 2023-04-30T15:58:44.933000

216

Views

Function that receive table name as input variable to be used in CROSS APPLY

Published on 30 April 2023 at 15:58

score 62 · Answer 10 · 2023-04-27T18:12:47.683000

62

Views

How to select value from column based on value in aggregate column?

Published on 27 April 2023 at 18:12

score 122 · Answer 11 · 2023-03-31T00:11:36.927000

122

Views

split row to multiple rows based on datediff

Published on 31 March 2023 at 00:11

score 32 · Answer 12 · 2023-03-06T10:32:30.930000

32

Views

What does the "B" mean in the linked answer, when the query still works however I name it?

Published on 06 March 2023 at 10:32

score 44 · Answer 13 · 2023-02-28T11:02:59.503000

44

Views

Navigating nodes for select in XML (Crossapply,XMLnamespaces) SQL

Published on 28 February 2023 at 11:02

score 286 · Answer 14 · 2023-01-26T07:48:43.140000

286

Views

Why is CROSS APPLY resulting in one less row?

Published on 26 January 2023 at 07:48

score 60 · Answer 15 · 2023-01-24T15:25:19.093000

60

Views

Apply function to vector of values instead of single value in R

Published on 24 January 2023 at 15:25

score 83 · Answer 16 · 2023-01-21T08:06:31.767000

83

Views

Rewrite of query with correlated subquery in join condition

Published on 21 January 2023 at 08:06

score 36 · Answer 17 · 2022-12-28T16:47:43.607000

36

Views

Flatten and group a set of data using PIVOT twice

Published on 28 December 2022 at 16:47

score 48 · Answer 18 · 2022-11-21T19:39:19.253000

48

Views

How can I update a table using the following CROSS APPLY?

Published on 21 November 2022 at 19:39

score 452 · Answer 19 · 2022-11-01T01:11:41.040000

452

Views

How can I implement Dijkstra's Algorithm in T-SQL to find the shortest route through my data-points?

Published on 01 November 2022 at 01:11

score 97 · Answer 20 · 2022-10-29T18:28:44.183000

97

Views

Using STRING_SPLIT to normalize data in temp tables?

Published on 29 October 2022 at 18:28

List Question

How to convert a Cross Apply to a Pivot for Performance reasons

SQL Unpivot Rolling Date/Week Calculation

Cross apply: Select vs Values

Is there a way to use CROSS APPLY from SQL to Spark SQL?

Add new variable in where clause with cross apply

Using CROSS APPLY to more easily "UNPIVOT" a wide table in Snowflake?

SQL cross apply and unpivot function

The LINQ expression could not be translated in CROSS APPLY

Function that receive table name as input variable to be used in CROSS APPLY

How to select value from column based on value in aggregate column?

split row to multiple rows based on datediff

What does the "B" mean in the linked answer, when the query still works however I name it?

Navigating nodes for select in XML (Crossapply,XMLnamespaces) SQL

Why is CROSS APPLY resulting in one less row?

Apply function to vector of values instead of single value in R

Rewrite of query with correlated subquery in join condition

Flatten and group a set of data using PIVOT twice

How can I update a table using the following CROSS APPLY?

How can I implement Dijkstra's Algorithm in T-SQL to find the shortest route through my data-points?

Using STRING_SPLIT to normalize data in temp tables?

Trending Questions

Popular # Hahtags

Popular Questions