Lab Sql

I want to create some test cases for Entity Framework queries that surely generate SQL commands tha… Read more Entity Framework And Cross/outer Apply

Performance issue with XML cross apply: DataTable has 1300 entries and the field xmldata has 250 n… Read more Performance Issue With Cross Apply While Reading Xml Nodes For Large Dataset

I have a problems this mornig , I have tried many solutions and nothing gave me the expected result… Read more Sql Select First Column And For Each Row Select Unique Id And The Last Date

I'm trying to understand the table operator APPLY. Here is the example: CREATE TABLE #y ( Name … Read more When To Use The Table Operator Apply

Is it possible to take a table that is structured in the following fashion: ID Month Info1 I… Read more Mutiple Columns With Independent Where Clause - Sql Pivot?

Trying to write a query which will behave like a foreach Query : select label ,NTILE(10) over(or… Read more Loop Through A Table Using Cross Apply And Union All The Results

I am calling Scalar UDF from a stored procedure to get a column value. Inside the scalar UDF I have… Read more Get Comma Separated Values From An Xml In Sql