You could use: var total = dbo.PrecisionArchive.Where(p => p.AgencySourceId == 7) .Where(p => p.EventType == “R” || p.EventType == “ONS”) .Select(p => p.SampleDateTime) .Distinct() .Count(); 1 solved How to convert SQL query into LINQ?
Your question is very unclear. If i understand your question correctly, this is what you want right? You didn’t mention to SUM up the values in Field3 or MAX, MIN or etc. SELECT Field1, Field2, Group_Concat(Field3) FROM tableName GROUP BY Field1 Result: Field1 Field2 Field3 a x 10, 20 b g 30, 40 c u … Read more
ypercube’s suggestion is exactly correct. Here is an implementation: DECLARE @searchText VARCHAR(100) SET @searchText=”Assumed Life Claims” DECLARE @sqlText VARCHAR(8000) DECLARE @MaxId INT DECLARE @CurId INT DECLARE @possibleColumns TABLE (Id INT IDENTITY(1, 1) NOT NULL PRIMARY KEY ,sqlText VARCHAR(8000)) INSERT INTO @possibleColumns(sqlText) SELECT ‘IF EXISTS (SELECT * FROM ‘ + c.TABLE_NAME + ‘ WHERE ‘ + … Read more
Try parametrizing your query; all you should provide is date and let RDBMS do its work (formats, representation etc. included) // using – do not forget to Dispose (i.e. free resources) using (SQLiteCommand command = new SQLiteCommand(databaseConnection)) { // Do not build query, but parametrize it command.CommandText = @”update credits set lastDate = @prm_Date where … Read more
In more layman’s terms, it means that for each record in Table A, you get every record from Table B (all possible combinations). TableA with 3 records and Table B with 3 records gives 9 total records in the result: TableA-1/B-1 TableA-1/B-2 TableA-1/B-3 TableA-2/B-1 TableA-2/B-2 TableA-2/B-3 TableA-3/B-1 TableA-3/B-2 TableA-3/B-3 Often used as a basis for … Read more
Research stored procedures. You can include user input as a parameter and then pass it to a WHERE clause through a declared parameter. So ideally it would go something like (and beware of the INT part it may have to have a different value that corresponds to table.datum: CREATE PROCEDURE dbo.Proc1 @parameter1 INT AS BEGIN … Read more
Here the key is to get the count of Employee doing particular job in each department. In below query, this is achieved by subquery. Then, we want to get the Department with minimum no. of employee doing that job so we ordered the records returned by subquery in ascending and then select the first result … Read more
You are probably passing a value that can’t be parsed into an int for this parameter: pram[5] = new SqlParameter(“@contact”, SqlDbType.Int, 100); Check what you are passing here: pram[5].Value = contact; If contact is a string then do something like: int contactNumber; pram[5].Value = int.TryParse(contact, out contactNumber) ? contactNumber : 0; 4 solved SQL – … Read more
Use a recursive sub-query factoring clause to generate each day within your time ranges and then correlate that with your shifts to restrict the time for each day to be within the shift hours and then aggregate to get the total: Oracle 18 Setup: CREATE TABLE times ( start_date, End_Date ) AS SELECT DATE ‘2017-02-21’ … Read more
This is a pretty common conditional aggregation. Notice how I posted consumable data as a table and insert statements. To be honest it took longer to do that portion than the actual code to select the data. You should do this in the future. Also you should avoid using keywords as column names. declare @Something … Read more
A little-known fact about the Python native pickle format is that you can happily concatenate them into a file. That is, simply open a file in append mode and pickle.dump() your dictionary into that file. If you want to be extra fancy, you could do something like timestamped files: def ingest_data(data_dict): filename=”%s.pickles” % date.strftime(‘%Y-%m-%d_%H’) with … Read more
If I have two columns, how can I select all distinct values of columnA where columnB is never a specific value given that columnA is the same value? solved If I have two columns, how can I select all distinct values of columnA where columnB is never a specific value given that columnA is the … Read more
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ”2′ at line 1 [closed] solved You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use … Read more
Take a look in syscomments for the text and join to sysobjects for the object type and name sysobjects syscomments solved How can I find all occurrences of particular text within all stored procedures in my database? [closed]
You need to place quotes around your date i.e. $timestring as “UPDATE posts SET creatdate=”$timestring” WHERE postid = 1 ” solved How can I set the MySQL date with string like 2015-07-30 18:32:18 [duplicate]