I have data currently in my table like below under currently section. I need the selected column data which is comma delimited to be converted into the format marked in green (Read and write of a …
Tag: sql
PostgreSQL copy/transfer data from one database to another
I need to copy data from one table to another. the two tables have almost the same structure, but are in different databases. i tried wenn i try this, i get error cross database … not implemented Answer This is a really straightforward task. Just use dblink for this purpose: If you need to fetch data fr…
Error in MySQL when setting default value for DATE or DATETIME
I’m running MySql Server 5.7.11 and this sentence: is not working. Giving the error: But the following: just works. The same case for DATE. As a sidenote, it is mentioned in the MySQL docs: The DATE type is used for values with a date part but no time part. MySQL retrieves and displays DATE values in &#…
Postgres: select all row with count of a field greater than 1
i have table storing product price information, the table looks similar to, (no is the primary key) no name price date 1 paper 1.99 3-23 2 paper 2.99 5-25 3 paper 1.99 …
How to set multiple values inside an if else statement?
I’m trying to SET more than one value within the if else statement below, If I set one value it works, but if I set two values, it doesn’t work: Error message: “Msg 156, Level 15, State 1, Line 9 Incorrect syntax near the keyword ‘ELSE’.” However it seems to be possible to …
SBO tables Relationship (AR INVOICE-INCOMING Payment)
am making a query that bring Incoming Payments details , that include payment means , details of payment means , and then some UDFS from the related A/R invoice(s) , in addition to some UDF from an object that relate to a UDF in the AR INVOICE , now every time am running my query it show no result. Am
Get “zero” for a count at dates without records
So I’m counting activity records from users in my system. I get the activity counter for each day in a certain month and year, just like the query that follows SELECT CONVERT(date, VIS_DATETIME) AS …
How to insert in two tables in one time? prepared statements
How to insert two table in one time? I need to insert second table user_information the field user_id with first table user insert returning id, I found this answer but I can’t find how to be with …
Deleting Mode Analytics Bridge Connector
After installing the Mode Analytics Bridge Connector for a remote MySQL database I decided to use another type of connection. I installed this .pkg and ran this code: from this page, which won’t load without an account with Mode. Now I want to completely remove everything installed by that .pkg and undo…
Select record between two IP ranges
I have a table which stores a ID, Name, Code, IPLow, IPHigh such as: Now, if I have an IP address 192.168.2.50, how can I retrieve the matching record? Edit Based on Gordon’s answer (which I’m getting compilation errors) this is what I have: but this gives me an error: Any ideas? Answer Painfully.…