In ServiceStack.OrmLite v4, as specified by mythz in the comments, everything should work as-is. In v3, if you want to have byte arrays serialized as binary instead of base 64 strings, you should inherit from SqliteOrmLiteDialectProvider and override the functions responsible for converting CLR values from and to SQL values to handle byte arrays. public … Read more
I’m assuming your datetime variable is a VARCHAR – this can be directly cast via CONVERT: Declare @YourVariable Varchar (15) = ‘JAN 01 1996’ Select Convert(Date, @YourVariable) 1996-01-01 2 solved Converting datetime variable format
Assuming that I understand the problem: you have a number of rows with sections (“Cates”) and symbols (“Type”); if there are any symbols ending in a minus sign then these indicate a row without a minus sign should be removed; symbols are never “mixed” per section, i.e. a section can never have “A” and “B-“; … Read more
First, I created a single table database to mimic the data structure: static void CreateAndSeedDatabase() { Context context = new Context(); TimeTracker entry1 = new TimeTracker() { UserId = 1, LoginTime = new DateTime(2000, 1, 1, 0, 0, 0), LogoutTime = new DateTime(2000, 1, 1, 1, 0, 0) }; TimeTracker entry2 = new TimeTracker() { … Read more
SELECT * FROM yourTable WHERE (FilteredPhoneCall.createdon >= dateadd(day,datediff(day,1,GETDATE()),0) AND FilteredPhoneCall.createdon < dateadd(day,datediff(day,0,GETDATE()),0)) OR (FilteredPhoneCall.modifiedon >= dateadd(day,datediff(day,1,GETDATE()),0) AND FilteredPhoneCall.modifiedon < dateadd(day,datediff(day,0,GETDATE()),0)) solved select yesterday date in where condition
In SQL Server, the update should start: update TBLSurvey set Status = -1 from TBLSurvey . . . The syntax for update in SQL Server is here. If I had to guess, it looks like you are confused with aspects of MySQL syntax. solved Incorrect syntax near the keyword ‘set’ and ‘as’ [closed]
Here is the query for the exact results you are looking for. select A.id, sum(A.sal + ISNULL(B.sal, 0) + ISNULL(C.sal, 0) ) sal from TableA A left join TableB B on A.id = B.id left join TableC C on A.id = C.id group by A.id Also, in case TableC or TableB were to contain records … Read more
This is for MS SQL Server. You can easily replicate this if you use any other RDBMS declare @email varchar(100) set @email=”[email protected]” select substring(@email,1,charindex(‘@’,@email)-1) 3 solved Select @ before values
When averaging speeds, the harmonic mean is in need. The straight forward AVG() approach is wrong, the arithmetic mean yields the wrong result for average velocity. There is no predefined function for the harmonic mean, but it could be achieved with this query: SELECT segment, COUNT(*)/SUM(1e0/speed) AS avg_speed FROM T GROUP BY segment SQL Fiddle … Read more
Try this with myTable ( numberid, startDate, endDate ) as( select numberid, CONVERT(DATETIME,startDate), CONVERT(DATETIME,endDate) from ( values (4405598510,’2011-08-06 00:00:00′,NULL), (2418680054,’2011-08-06 00:00:00′,’2011-12-28 00:00:00′), (4405598510,’2011-08-06 00:00:00′,NULL), (1810168034,’2011-08-06 00:00:00′,NULL), (6849266569,’2011-08-06 00:00:00′,’2014-09-02 00:00:00′), (2682265222,’2011-08-09 00:58:00′,’2012-09-20 00:00:00′), (6253123963,’2011-08-09 00:00:00′,’2011-07-01 00:00:00′), (8276745680,’2011-08-10 00:00:00′,’2014-06-27 00:00:00′), (3873103800,’2011-08-10 00:00:00′,’2013-07-16 00:00:00′), (3703761027,’2011-08-06 00:00:00′,NULL), (1810168034,’2011-08-06 00:00:00′,NULL) ) [ ] (numberid,startDate,endDate) ) select Numberid, startDate, endDate, case … Read more
If the possible values are only ‘Breachend’ and ‘Not Breached’, you can GROUP BY incident_number and get the minimum as ‘Breached’ < ‘Not Breached’. SELECT incident_number, min(has_breached) has_breached FROM elbat GROUP BY incident_number; 1 solved Need SQL Script
You have two froms in the query. FROM FROM table1 –change this solved Incorrect syntax near the keyword ‘FROM’. No clue [closed]
You didn’t tell what is wrong exactly but I see a few things wrong in your code. You should always use parameterized queries. This kind of string concatenations are open for SQL Injection attacks. I assume your Scor and ID columns are numeric, not character. That’s why you should not use single quotes with it. … Read more
Join the tables, concatenate the strings and use LIKE to look for the “certain text”. SELECT p.path + ‘\’ + d.filename FROM documents d INNER JOIN documentsinprojects dp ON dp.documentid = d.documentid INNER JOIN projects p ON p.projectid = dp.projectid WHERE p.path LIKE ‘%certain text%’ AND d.filename LIKE ‘%certain text%’; 4 solved Microsoft SQL Server: … Read more
The problem is not at the procedure it is at the calling. When you call the stored procedure, you need to declare and pass in the required parameter declare @NAME VARCHAR(50), @CITY VARCHAR(200), @MOBILE NUMERIC(20) execute GETDETAIL @AGE = 21, @NAME = @NAME OUTPUT, @CITY = @CITY OUTPUT, @MOBILE = @MOBILE OUTPUT SELECT @NAME, @CITY, … Read more