Try: (df[‘A’] + df[‘B’]).where((df[‘A’] < 0) | (df[‘B’] > 0), df[‘A’] / df[‘B’]) The difference between the numpy where and DataFrame where is that the default values are supplied by the DataFrame that the where method is being called on (docs). I.e. np.where(m, A, B) is roughly equivalent to A.where(m, B) If you wanted a … Read more
Try this SELECT DateAppr, TimeAppr, TAT, LaserLTR, Permit, LtrPrinter, JobName, JobNumber, JobDesc, ActQty, (ActQty-LtrPrinted) AS L, (ActQty-QtyInserted) AS M, ((ActQty-LtrPrinted)-(ActQty-QtyInserted)) AS N FROM [test].[dbo].[MM] WHERE DateDropped = 0 AND ( (ISNULL(@JobsOnHold, 0) = 1 AND DateAppr >= 0) OR (ISNULL(@JobsOnHold, 0) != 1 AND DateAppr != 0) ) You can read more about conditional WHERE … Read more
Short answer: Use let without in in the body of a do-block, and in the part after the | in a list comprehension. Anywhere else, use let … in …. The keyword let is used in three ways in Haskell. The first form is a let-expression. let variable = expression in expression This can be … Read more
This feature has now been added to Entity Framework core 5. For earlier versions you need a work-around (note that EF6 is an earlier version). Entity Framework 6 work-around In EF6, a work-around is to first query the required objects in a projection (new) and let relationship fixup do its job. You can query the … Read more
You can either use GROUP BY and HAVING COUNT(*) = _: SELECT contact_id FROM your_table WHERE flag IN (‘Volunteer’, ‘Uploaded’, …) GROUP BY contact_id HAVING COUNT(*) = 2 — // must match number in the WHERE flag IN (…) list (assuming contact_id, flag is unique). Or use joins: SELECT T1.contact_id FROM your_table T1 JOIN your_table … Read more
You need to move the WHERE filter to the JOIN condition: SELECT c.Customer, c.State, e.Entry FROM Customer c LEFT JOIN Entry e ON c.Customer=e.Customer AND e.Category=’D’ See SQL Fiddle with Demo
You can certainly do it within a Where clause (extension method). If you need to build a complex query dynamically, though, you can use a PredicateBuilder. var query = collection.Where( c => c.A == 1 || c.B == 2 ); Or using a PredicateBuilder var predicate = PredicateBuilder.False<Foo>(); predicate = predicate.Or( f => f.A == … Read more
You can do like this DELETE FROM table WHERE id NOT IN ( 2 ) OR DELETE FROM table WHERE id <> 2 As @Frank Schmitt noted, you might want to be careful about the NULL values too. If you want to delete everything which is not 2(including the NULLs) then add OR id IS … Read more
In the default configuration of a SQL Server database, string comparisons are case-insensitive. If your database overrides this setting (through the use of an alternate collation), then you’ll need to specify what sort of collation to use in your query. SELECT * FROM myTable WHERE myField = ‘sOmeVal’ COLLATE SQL_Latin1_General_CP1_CI_AS Note that the collation I … Read more
You need to identify the primary key in TableA in order to delete the correct record. The primary key may be a single column or a combination of several columns that uniquely identifies a row in the table. If there is no primary key, then the ROWID pseudo column may be used as the primary … Read more