The tag has no wiki summary.

learn more… | top users | synonyms

4
votes
1answer
317 views

NEWID() In Joined Virtual Table Causes Unintended Cross Apply Behavior

My actual work query was an inner join, but this simple example with cross join seems to nearly always reproduce the problem. SELECT * FROM ( SELECT 1 UNION ALL SELECT 2 ) AA ( A ) CROSS JOIN ...
3
votes
1answer
184 views

How Can the Same Query in Two Nearly Identical Instances Generate Two Different Execution Plans?

Server A and Server B have identical hardware and instance configurations (A is Production, B is QA). B's DBs were restored from A's backups from one week ago. I was provided this query by the ...
2
votes
2answers
241 views

Cross Apply without a function

I would like to run a query very similar to this on one of my production databases: -- Setup the table (Already there in my real scenario) create table dbo.MyTable(MyValue int, MyGroup varchar(5)) ...
0
votes
3answers
107 views

How to convert query results into groups of common results

I have a query that returns results like this: MyValue MyGroup _______________|_______________ 56 | I _______________|_______________ 12 | I ...
4
votes
1answer
328 views

Build a three table join with a recusive table in the middle?

I have three relevent tables: Parts, PartGroup, and MarkupGroup. Parts is simple. PartID artificial primary key Part part number PartGroupID Foreign key sample data: 1 ...
3
votes
1answer
891 views

CROSS APPLY-ing a parameterised function

Given the following definitions: CREATE TABLE MyTable ( col1 int, col2 int, col3 int, col4 int ) CREATE FUNCTION fn_MyFunction ( @Param1 int, @Param2 int ) RETURNS TABLE AS ...
2
votes
0answers
447 views

how to split the column with cross apply in sql server 2008 [closed]

I have a table like this VM1 SPLA - WINSVRSTD #P19-9999 QTY 1 VM2 SPLA - WINS ST #P29-9 9 QTY 2 : SPLA - WINSVRENTAAA #P39- 9 9 99 QTY 3:SPLA - WINS ST #P29-9 9 QTY 2 : SPLA - WINSVRENTAAA ...