Your return type is void, not string. Change it to: private string SQLSelection() A void is a “returnless” action that is performed upon something and does not “return” back the values of the return statement. If you try to return a value, you get a compiler error as you are experiencing. In addition, you keep … Read more
If you are looking for an update statement that you would run periodically, and that sets the status of newly expired items, that would be: update orders set status=”expired” where curent_date > expired_date and status=”new” On the other hand… In your schema, status is a derived information, that is a column whose value can be … Read more
This query creates a column called COL and puts literal value of ‘ID’ in it. It then provides the first (or highest) ID (numeric or alphabetic depending on what type of field ID is) and places it in the same row as the literal value “ID” under the column named (MAX). It then takes the … Read more
The @search should be an input parameter of the stored proc, (no Declare required), and you need an As between the signature block for the stored proc and the body of the proc. Create PROCEDURE [dbo].[usp_cloud_ClientAllSearch] @Search NVARCHAR(30) As SELECT client_Name, client_Surname, client_CompanyName, clientContact_TelephoneNo, clientContact_MobileNo, clientAddress_PostalCode FROM cloud_Client c Join dbo.cloud_ClientAddresses a ON a.client_ID = … Read more
Use LEFT JOIN: SELECT VA.COL_PERSONNEL_NUMBER, VA.COL_CLOCK_DATE, VA.P10, VA.P20, VR.NAME, VR.UNIT FROM VIEW_ABSEN VA LEFT JOIN VIEW_REPORT VR ON VA.COL_PERSONNEL_NUMBER=VR.ID AND VR.DATE=VA.COL_CLOCK_DATE WHERE VA.COL_PERSONNEL_NUMBER LIKE ‘%521663%’ AND VA.COL_CLOCK_DATE BETWEEN ‘2016-08-01’ AND ‘2016-08-05’ 1 solved How to display data in JOIN, and return null value? [closed]
You can use left() function with charindex() : with t as ( select 5.083 as nr ) select left(nr,charindex(‘.’,nr)-1) as Carton, nr – left(nr,charindex(‘.’,nr)-1) as Loose from t; Carton Loose 5 0.083 Demo solved Split the decimal place from a number using sql [closed]
Here’s a basic structure of how an update query works: UPDATE tableName SET column = value WHERE condition = true; In your case, you’re updating the demo_table new table with a condition of new.trans_type = 9. The tricky thing here is you’re using your sub query as your value to set the columns as. A … Read more
Sorry I was not realising that I aksed a bit too much. I actually figured it out on my own. So i guess I leave the code here in case anyone needs it. Have a nice day! #!/usr/bin/perl # PERL MODULES use strict; use DBI; use DBD::ODBC; use Text::CSV; use List::MoreUtils qw(each_array); # SOME VARIABLES … Read more
The error message seems pretty clear: FactorId is an identity column. You shouldn’t set the value for FactorID yourself. Sql Server will set it for you. But if you really want to set it for some insane reason, you need to include a column list in the query like this: SET IDENTITY_INSERT facetors on INSERT … Read more
The code would look something like the code below. You need to modify the connection string and SQL as required. using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data; using System.Data.SqlClient; namespace ConsoleApplication58 { class Program { static void Main(string[] args) { string connStr = “Enter Your Conneciton String Here”; string SQL = “Select … Read more
You can use the MAX() and MIN() function to get the ids having largest and the id having smallest discount. Select id,discount from customer where discount=(select MAX(discount) from customer) OR discount=(select MIN(discount) from customer); 3 solved select id by the min and max (sql) [closed]
The only difference is that the first query will return a row for each pair of rows in the table where P1.att2 > P2.att2 and P2.att1 = x, while the second query will just return one row for each row in the table where att2 is greater than in some row where att1 = x. … Read more
It is difficult to ans your query without source code, but still try this: Try binding parameters which you pass in query instead of directly passing in it. for example: $query = UserMaster::model()->findAll(’email = :email ‘, array(‘:email’ => “[email protected]”)); Here email id is binded in an array, this will prevent sql injection to much extent. … Read more
I will use postgres for this example, I use row_number() and cte, if you have mySql will need a workaorund You need a table priority CREATE TABLE priority (“PhoneType” int, “Priority” int) ; INSERT INTO priority (“PhoneType”, “Priority”) VALUES (7, 1), (6, 2), (1, 3), (2, 4), (3, 5), (4, 6), (5, 7), (8, 8), … Read more
I’m pretty sure that the problem is the space in the name of your Faculty Name column and that this has nothing to do with the use of AND or OR. Please try: sql = “Update [Sheet1$] set A1 = ‘a’ ” + “where Designation = ‘Prof(senior)’ and [Faculty Name] = ‘bob'”; 1 solved IF … Read more