Actually this is REALLY SIMPLE using plain old SQL. Just use bitwise ANDs. I was a bit amazed that there wasn’t a simple solution posted online (that didn’t invovled UDFs). In my case I really wanted to check if bits were on or off (the data is coming from dotnet eNums). Accordingly here is an … Read more
select DateAdded, count(CustID) from Responses WHERE DateAdded >=dateadd(day,datediff(day,0,GetDate())- 7,0) GROUP BY DateAdded
Chances are that you are hitting on a problem with parameter sniffing. I suggest reading Slow in the Application, Fast in SSMS? by Erland Sommarskog to get a full understanding of the issue (long article but very good).
You can (should) use CROSS JOIN. Following query will be equivalent to yours: SELECT table1.columnA , table2.columnA FROM table1 CROSS JOIN table2 WHERE table1.columnA = ‘Some value’ or you can even use INNER JOIN with some always true conditon: FROM table1 INNER JOIN table2 ON 1=1
UPDATE public.clean_trips_byobu SET trip_dist = clean_trips.bktp_mt_total FROM public.clean_trips WHERE public.clean_trips.obu_id = clean_trips_byobu.obu_id AND clean_trips.bktp_trip_id = clean_trips_byobu.trip_id; Hope it will work for you.
You can use @@ROWCOUNT server variable immediately after the insert query to check number of affected rows by the insert operation. declare @fName varchar(50) = ‘Abcd’, @lName varchar(50) = ‘Efgh’ INSERT INTO myTbl(fName,lName) values(@fName,@lName) PRINT @@ROWCOUNT –> 0- means no rows affected/nothing inserted –> 1- means your row has been inserted successfully For your requirement, … Read more
That isn’t quite an SQL file, that contains a bunch of MySQL-specific stuff some of which SQLite will accept and some it won’t. We’ll start at the top. You don’t need create database or use with SQLite. If you want to create a database just name it when you run sqlite3 from the command line: … Read more
Apparently the looping construct in SQLite is the WITH RECURSIVE clause. That documentation link has sample count-to-ten code, a Mandelbrot set plotter, and a Sudoku puzzle solver, all in pure SQL. Here’s an SQLite query that computes the Fibonacci sequence to give you a feel for it: sqlite> WITH RECURSIVE …> fibo (curr, next) …> … Read more
I’m not an SQL tuning expert, but joining hundreds of millions of rows on a VARCHAR field doesn’t sound like a good idea in any database system I know. You could try adding an integer column to each table and computing a hash on the NAME field that should get the possible matches to a … Read more
If create_time is of type TEXT with valid date value, it’ll be easier to proceed with the change as follows (Be advised to first do a table dump as a backup): — Create a temporary TIMESTAMP column ALTER TABLE AB ADD COLUMN create_time_holder TIMESTAMP without time zone NULL; — Copy casted value over to the … Read more