(WARNING – WM_CONCAT is an unsupported function that was removed in version 12c. Unless you’re using a very old database, you should avoid this function. You should probably use LISTAGG instead.) It depends on the version of Oracle you’re using. If it supports the wm_concat() function, then you can simply do something like this: SELECT … Read more
CREATE TABLE AS is the simplest and fastest way: CREATE TEMP TABLE tbl AS SELECT * FROM tbl WHERE … ; Do not use SELECT INTO for this purpose. See: Combine two tables into a new one so that select rows from the other one are ignored Not sure whether table already exists CREATE TABLE … Read more
I’m a little late to the party, but I ran across this thread while experiencing the same errors and found a different resolution. When creating an SSIS 2012 package, in the Solution Explorer window you will see the Connection Managers folder at the project level. This seems like the most logical place to create a … Read more
The @@identity and scope_identity() will hand you the identity of a new row, ie. after an insert. After your update, the identity of the row is… @Customer_ID or @Handle_Id? If it is a different field, you should use the OUTPUT clause to return the ID of the updated row: UPDATE ITS2_UserNames SET AupIp = @AupIp … Read more
Run the following queries to have incremented value in yourField column: SELECT @i:=0; UPDATE yourTable SET yourField = @i:=@i+1;
In Postgres 9.3 or later use a LATERAL join: SELECT v.col_a, v.col_b, f.* — no parentheses, f is a table alias FROM v_citizenversions v LEFT JOIN LATERAL f_citizen_rec_modified(v.col1, v.col2) f ON true WHERE f.col_c = _col_c; Why LEFT JOIN LATERAL … ON true? Record returned from function has columns concatenated For older versions, there is … Read more
This is what you need: Select e.EmpName, e.Address, s.Name, S.Address, s.Project From tbEmployees e JOIN tbSupervisor s on e.id = SupervisorID You can read about this on W3Schools for more info.
When you define a CTE you’re doing so before any of the rest of the query. So you can’t write: LEFT JOIN ( ;WITH CTE … ) As a quick aside, the reason people put ; in front of WITH is because all previous statements need to be terminated. If developers could get in the … Read more
I suspect you want to check that it’s after 11pm or before 7am: select * from MyTable where CAST(Created as time) >= ’23:00:00′ or CAST(Created as time) < ’07:00:00′
Another approach is using ActiveRecord::QueryCache::ClassMethods#uncached Model.uncached do # your code end