I have two tables ta, tb. ta columns - cId, c1, c2. c1 and c2 contain nulls and need to be filled with data. tb columns - cId, c3, c4. The data for c1 and c2 will come from c3 and c4 respectively.
So, I tried to do a simple inner join first. Both tables were aliased as al_ta and al_tb respective...
I'm creating a function in postgres and getting strange error. What am I doing wrong? I also would like to see your variants how to do it
CREATE OR REPLACE FUNCTION export_csv(request TEXT, filename VARCHAR(255))
RETURNS VOID AS
$$
BEGIN
EXECUTE 'COPY (' || request || ') TO "/home/r90t/work/s...
1# I realized that if I use postgis it is very fast, but how can I optimize queries?
SELECT ID,
ST_Y(ST_Transform(ST_SetSRID(ST_MakePoint(lon/100.0,lat/100.0),900913),94326)),
ST_X(ST_Transform(ST_SetSRID(ST_MakePoint(lon/100.0,lat/100.0),900913),94326))
FROM planet_osm_nodes AS nodes INNER...
I have a table that records the diagnosis of patient for each attendance. Patients can have more than one diagnosis.
I want one row per attendance with all diagnosis (up to 12 diagnosis). The below brings back more than one row.
select
dg.AttendanceID
, dg.PatientNumber
, dg.Diagno...
SELECT distinct loc.name,
loc.imageurl,
tu.userid,
tu.fname,
(SELECT TOP(1) [time]
FROM tblcheckin
WHERE userid = tf.followerid and flag ='C'
ORDER BY [time] DESC) A...
I get this error while scheduling a backup
Error evaluating parameter sources/security checks/locks
ORA-04098: trigger 'SYSMAN.MGMT_JOB_PARAM_UPDATE_LARGE' is invalid and failed re-validation
How can I fix this?
Would running a SQL Profiler in Microsoft SQL Server Management for SP_Counts on a live database cause noticeable performance issues?
The hour and minute are in parts, and you may want to GROUP BY the [Server] as well.
SELECT SUM([Number]), [Date], DATEPART(hour, [Time]), DATEPART(minute, [Time]), MAX([Server])
FROM [Table]
GROUP BY [Date], DATEPART(hour, [Time]), DATEPART(minute, [Time])
We get questions like this where it is immediately obvious that the OP has a much bigger issue than they realise, and they need a consultant or vendor support, much hand holding and hands-on access to their systems:
In this case they've probably ran catproc in from another version, or been cr...
I wrote this query for a ssrs report dataset. The report works fine for single parameter value and error is populated when multiple values are selected for parameter.
@iteration is a multivalued report parameter.
create table #hftable
( id int ,startdate datetime, environment nvarchar(50), ite...
I'm trying to shrink my database like the following:
USE Db;
GO
-- Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE Db
SET RECOVERY SIMPLE;
GO
-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (Db, 100);
GO
-- Reset the database recovery model.
ALTER DAT...
I am trying to understand how this works?
So in this example: Cartesian or Cross Join
I do not understand how the DML expresses the relation between the two tables. In my SELECT statements, how does the DB know which columns are from which table?
Example: What if I had an AMOUNT column on eac...
I have a list of 1 to 10 million domains and need to import it to a DB and then retrieve via some search. Currently thinking about doing it with mySQL because that is the only thing that I know but is there anything that will work faster? NoSQL, txt file and regex, php array?
I am almost new user in MySQL and I have find in a WordPress plugin this code, but I cannot undesrtaint what does it mean or how it can be read. This syntax is very new to me, and I cannot evaluate it.
Can somebody to help me underdstaint this code :?
IF(agr_sam_ads.ad_users = 0, TRUE, IF(agr_s...
i am stuck with a query where i need to change data into columns, i dont know how to use pivot since i am not using Aggregate functions.
My tables are like
Name Number DID DID_description value date
1 1234 01 counts
2 1456 02 quantity
3 1678 03 dollars
Desired table...
I'd like to insert a date field into a SQL server table form Proc SQL in SAS. Here is my code for Proc SQL:
proc sql;
insert into CFS_SQL.Data_DSB_Raw(sasdatefmt=(TheDate='mmddyy10.'))
select TheDateIncoming
from Work.Upload;
quit;
According to the SAS help documentation (http://su...
