score:0
select *
from dimensiondata d
where d.width in (@p1, @p2, @p3, ...)
and d.height in (@p4, @p5, @p6, ...)
score:0
exec sp_executesql n'declare @hdoc int;
execute sp_xml_preparedocument @hdoc output, @p0;
with source as
(
select width, height from openxml(@hdoc, ''/data/row'', 1) with ( width int, height int )
)
select *
from dimensiondata d
where exists (
select *
from source s
where d.width = s.width and d.height = s.height
);
execute sp_xml_removedocument @hdoc;',n'@p0 nvarchar(111)',@p0=n'<data>
<row width="1" height="1" />
<row width="2" height="1" />
<row width="3" height="1" />
</data>'
go
Source: stackoverflow.com
Related Query
- EF LINQ to SQL is getting whole table from DB instead of selection - where clause contains list with Any statement
- Linq group by multiple columns and getting extra values from table before group by clause
- Using value from related table in LINQ where clause
- Get Records from table where quantity is not between fromquantity and ToQuantity using Linq to SQL
- LINQ query to conditionally filter on a where clause and select the values from another table
- LINQ to SQL omit field from results while still including it in the where clause
- Getting actual value from a column in SQL BD table via linq
- linq left join with where clause show all from left table regardless
- Getting rows from a SQL table matching a dictionary using LINQ
- Linq to SQL - Order By related Table using a Where Clause
- SQL to LINQ - multiple tables left outer join with where clause referring right table
- Where Clause is not applied when converting the query from LINQ (EF) to SQL
- LINQ to SQL Where Clause Optional Criteria
- LINQ to SQL Every Nth Row From Table
- Dynamic Where Clause over relational tables with LINQ to SQL
- When to use lambda expressions instead of a Where clause in LINQ
- Linq to SQL: Where clause comparing a Nullable<DateTime> with a SQL datetime null column
- LINQ to SQL MAX in WHERE clause
- LINQ to SQL Data Context logs don't show the WHERE clause
- LINQ equivalent of SQL IsNull(..,..) in the Where Clause
- Convert SQL to Linq where there is in clause
- SQL INNER JOIN with WHERE clause to LINQ format
- Getting SQL string from LINQ to EF query
- Cannot cast from generic to get LINQ where clause
- Update query in LINQ contains all columns in WHERE clause instead of just the primary key column
- How to recursively call Where clause in Linq or SQL
- 3 Table LINQ query with a where clause
- LINQ Where clause throws casting exception from string to Guid even though comparison only contains Guids
- Combining two datatable and getting the amount from second table by using linq
- LINQ select from table where fieldValue is in another tables list of values
More Query from same tag
- Sum property based on existance in list and quantity
- I need help re-writing a SQL query into LINQ format
- Find a value between a List's upper and lower limits
- How to return all ranges that are not included in any other range C# list
- LINQ to XML - parent's attribute in where clause
- In MVC how can I return a IQueryable result and display it in a view using actions
- How to get top 1 records from a query
- Trouble binding XML child to DataList using ReadXML()
- How to get field as result of LINQ
- Converting SQL to LINQ with Multiple Tables and Group
- how to build Expression<Func<x,y>> with no input parameters?
- checking if all the items in list occur in another list using linq
- Dynamic Linq query Contains List
- linq any function vb.net
- receiving an entity error after using a db.find
- LINQ Entities build Query at Runtime 'The parameter is not in scope.' LinqKit
- `Only primitive types or enumeration are supported in this context` error whilst seeding ASP.NET MVC using AddOrUpdate match on multiple fields
- Fast join on Multiple IEnumerable
- Inlined operations when creating new dynamic object
- Group linq results by value and group null or invalid values and do counts
- SQL Query to Linq query with cast as real
- LINQ GroupBy x where there is more then one x and y is unique
- How do I get LINQ to order according to culture?
- XDocument duplicate namespace with different Local Name
- Select all flagged values in enum using LINQ
- Linq DataTable and Take Method
- Querying container with Linq + group by?
- Convert type in Expression<Func<T1, bool>> to Expression<Func<T2, bool>> (LINQ to SQL)
- Rename object, or change it's primary key (_id) value
- How fast is LINQ?