You could use a SUM (not COUNT!) combined with a CASE statement, like this: SELECT SUM(CASE WHEN myColumn=1 THEN 1 ELSE 0 END) FROM AD_CurrentView Note: in my own test NULLs were not an issue, though this can be environment dependent. You could handle nulls such as: SELECT SUM(CASE WHEN ISNULL(myColumn,0)=1 THEN 1 ELSE 0 … Read more
With a report (rdl) file selected in your solution, select View and then Report Data. It is a shortcut of Ctrl+Alt+D.
Here is the best example of Cross Join and Inner Join. Consider the following tables TABLE : Teacher x————————x | TchrId | TeacherName | x———-|————-x | T1 | Mary | | T2 | Jim | x————————x TABLE : Student x————————————–x | StudId | TchrId | StudentName | x———-|————-|————-x | S1 | T1 | Vineeth | … Read more
That’s pretty much all you need: mysql> select * from t; +——+——-+ | id | data | +——+——-+ | 1 | max | | 2 | linda | | 3 | sam | | 4 | henry | +——+——-+ 4 rows in set (0.02 sec) mysql> update t set data=concat(data, ‘a’); Query OK, 4 rows … Read more
From the MySQL manual INSERT statements that use VALUES syntax can insert multiple rows. To do this, include multiple lists of column values, each enclosed within parentheses and separated by commas. Example: INSERT INTO tbl_name (a,b,c) VALUES(1,2,3),(4,5,6),(7,8,9);
What you have there will return no row at all if the user doesn’t exist. Here’s what you need: SELECT CASE WHEN EXISTS ( SELECT * FROM [User] WHERE UserID = 20070022 ) THEN CAST(1 AS BIT) ELSE CAST(0 AS BIT) END
SUBSTRING(str_col, PATINDEX(‘%[^0]%’, str_col+’.’), LEN(str_col))
For workdays, Monday to Friday, you can do it with a single SELECT, like this: DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME SET @StartDate=”2008/10/01″ SET @EndDate=”2008/10/31″ SELECT (DATEDIFF(dd, @StartDate, @EndDate) + 1) -(DATEDIFF(wk, @StartDate, @EndDate) * 2) -(CASE WHEN DATENAME(dw, @StartDate) = ‘Sunday’ THEN 1 ELSE 0 END) -(CASE WHEN DATENAME(dw, @EndDate) = ‘Saturday’ THEN 1 … Read more
If you are looking for a one-size-fits-all, I’d suggest DECIMAL(19, 4) is a popular choice (a quick Google bears this out). I think this originates from the old VBA/Access/Jet Currency data type, being the first fixed point decimal type in the language; Decimal only came in ‘version 1.0’ style (i.e. not fully implemented) in VB6/VBA6/Jet … Read more
You want a parameter source: Set<Integer> ids = …; MapSqlParameterSource parameters = new MapSqlParameterSource(); parameters.addValue(“ids”, ids); List<Foo> foo = getJdbcTemplate().query(“SELECT * FROM foo WHERE a IN (:ids)”, parameters, getRowMapper()); This only works if getJdbcTemplate() returns an instance of type NamedParameterJdbcTemplate