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 solved I need to convert … Read more
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 solved Pass data from ajax in php
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 subqueries … Read more
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 solved SELECT * FROM table WHERE column = 1,2,3,4 [duplicate]
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
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 solved Stored … Read more
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 SUBSTRING(Column1, … Read more
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 ; Note … Read more
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 action=”update_student.php” … Read more
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 solved … Read more
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(*) desc, … Read more
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 findSaveByPagesByFilters() … Read more
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 solved how to update multiple ids with different value
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 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
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