[ad_1] On SQL-Server use CHARINDEX CHARINDEX ( expressionToFind , expressionToSearch [ , start_location ] ) DECLARE @CAMPO30 varchar(64) = ‘2,663.25’; SELECT CASE WHEN CHARINDEX(‘.’, @CAMPO30) > 1 THEN CAST(REPLACE(REPLACE(@CAMPO30,’.’,”),’,’,’.’) AS FLOAT) ELSE CAST(REPLACE(@CAMPO30,’,’,’.’) AS FLOAT) END AS CAMPO30 GO | CAMPO30 | | ——: | | 2.66325 | dbfiddle here 1 [ad_2] solved I need … Read more
[ad_1] use jquery with ajax & call ajax function onclick of submit button $.ajax(‘URL’, { type: ‘POST’, data: { myData: ‘formdata’ }, // data to submit success: function (data) { console.log(data); } }); 2 [ad_2] solved Pass data from ajax in php
[ad_1] ORDER BY, when using a UNION ALL goes at the end of the entire statement, not at the end of each one. You also have a statement terminator (;) after your first query, meaning you have a SELECT TOP(1) query followed by a further query that starts with UNION ALL. You need to use … Read more
[ad_1] The IN operator allows you to specify multiple values in a WHERE clause. Try this query : SELECT * FROM table WHERE column in ($var); Reference-1 0 [ad_2] solved SELECT * FROM table WHERE column = 1,2,3,4 [duplicate]
[ad_1] You should use group by and sum, but before that, you should create two subqueries according to n_txn_type_key and then compare: select txn_type_4.n_event_key, txn_type_4.tran_amount from ( select n_event_key, sum(n_transaction_amount) as tran_amount from TABLE_NAME where n_txn_type_key = 4 group by n_event_key ) txn_type_4 inner join ( select n_event_key, sum(n_transaction_amount) as tran_amount from TABLE_NAME where n_txn_type_key … Read more
[ad_1] I think you didn’t clear the parameters. You should clear it always after your transaction. cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue(“@UserId”, userId); cmd.Parameters.AddWithValue(“@MonthlyIncomeName”, income.MonthIncomeName); cmd.Parameters.AddWithValue(“@MonthlyIncomeAmount”, income.MonthIncomeAmount); cmd.Parameters.AddWithValue(“@TotalMonthlyIncome”, income.MonthIncomeAmount); cmd.Parameters.AddWithValue(“@Month”, insertMonth); cmd.Parameters.AddWithValue(“@Year”, insertYear); cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); // insert this line And search about AddWithValue vs Add like @cha said that check your parameter types. See this. 1 [ad_2] … Read more
[ad_1] try this: DECLARE @YourTable table (Column1 varchar(50)) INSERT @YourTable VALUES (‘Frodo Baggins’) INSERT @YourTable VALUES (‘Samwise Gamgee’) INSERT @YourTable VALUES (‘Peregrin Took’) INSERT @YourTable VALUES (‘Meriadoc Brandybuck’) INSERT @YourTable VALUES (‘aa’) INSERT @YourTable VALUES (‘aa bb cc’) SELECT LEFT(Column1,CHARINDEX(‘ ‘,Column1)) AS Names ,RIGHT(Column1,LEN(Column1)-CHARINDEX(‘ ‘,Column1)) AS Surnames FROM @YourTable –both queries produce same output SELECT … Read more
[ad_1] You can still use having, but test for each product — and for the absence of any other product: SELECT o.order_id FROM orders o GROUP BY o.order_id HAVING SUM( product_id = 222 ) > 0 AND SUM( product_id = 555 ) > 0 AND SUM( product_id NOT IN (222, 555) ) = 0 ; … Read more
[ad_1] There is one problem your not setting value and its empty. By which the values you select wont be added or updated to your database. The second is you have not given the name to your select dropdown by which even if you select the values it wont be posted to your action. <form … Read more
[ad_1] One way would be like this: db.polls.Where(p => p.id == polls.Where(x => x.publish_at == polls.Max(y => y.publish_at)).Max(x => x.id)); Another way like this: from p in db.polls where p.id == (from x in db.polls where x.id == (from y in db.polls where y.publish_at == db.polls.Max(y => y.publish_at) select y.id).Max()) select x.id).Max()) select p; 1 … Read more
[ad_1] You can use group by: select favorite from t group by favorite order by count(*) desc fetch first 1 row only; This is ANSI-standard sequence. Different databases have different ways of expressing the fetch first clause. In MS Access, this would be: select top (1) favorite from t group by favorite order by count(*) … Read more
[ad_1] I assume that you’re within the context of a repository, so in which case I’d advise using the Doctrine Query Builder, it’d help simplify your code flow, and probably would help you with SQL conversions in the future. To answer this specific problem, you’d probably want to do something like the following: public function … Read more
[ad_1] You are doing nothing with $check, Make id like this $ids=””; if(!empty($_POST[‘id’])) { foreach($_POST[‘id’] as $id) { $ids[] = $id; } } $check = implode(“,”, $ids); 0 [ad_2] solved how to update multiple ids with different value
[ad_1] Write a Query in MySql server that prints a list of employee names who have been employed for less than 10 months having salary>2000 [ad_2] solved Write a Query in MySql server that prints a list of employee names who have been employed for less than 10 months having salary>2000
[ad_1] Without a better understanding of the rules and data this is the best I can come up with. It is based on your first array example – SELECT `r`.* FROM `rule_attribute_value` `rav` INNER JOIN `rule` `r` ON `rav`.`rule_id` = `r`.`rule_id` INNER JOIN `rule_attribute` `ra` ON `rav`.`attribute_id` = `ra`.`attribute_id` WHERE (`rav`.`store_id` = 0 AND `ra`.`attribute_code` … Read more