Question : I have a very small table with 12 rows in it that can be created with the following […]
Tag: cross-apply
Insert a range of numbers from a call to sp_sequence_get_range
Question : Given the following code: CREATE SEQUENCE dbo.NextTestId AS [bigint] START WITH 10 INCREMENT BY 2 NO CACHE GO […]
Most efficient way to generate a diff
Question : I have a table in SQL server that looks like this: Id |Version |Name |date |fieldA |fieldB ..|fieldZ […]
Two OPENJSON, return each array element in separate rows
Question : I have a table where I save in JSON format the quantity that exit and return of a […]
Select with CROSS APPLY runs slow
Question : I am trying to optimize the query to run faster. The query is the following: SELECT grp_fk_obj_id, grp_name […]
Build a three table join with a recusive table in the middle?
Question : I have three relevant tables: Parts, PartGroup, and MarkupGroup. Parts is simple. PartID artificial primary key Part part […]
Add query hints to a CROSS APPLY [duplicate]
Question : This question already has an answer here: Use NOLOCK hint when calling table valued function (1 answer) Closed […]
Build a three table join with a recusive table in the middle?
Question : I have three relevant tables: Parts, PartGroup, and MarkupGroup. Parts is simple. PartID artificial primary key Part part […]
Performance improvement Outer Apply
Question : I have a query which runs little slower. SELECT b.BreakdownClassificationId, k.IsinCode, k.SedolCode, ClassificationDate, NAME, InstrumentType, GeographicalLocation, CapSize, Currency, […]
Outer Apply vs Left Join Performance
Question : I am Using SQL SERVER 2008 R2 I just came across APPLY in SQL and loved how it […]
- 1
- 2