2,812 reputation
1920
bio website datajini.com
location Frösön, Sweden
age 41
visits member for 2 years, 1 month
seen 16 hours ago

I'm an Oracle Database Specialist at DataJini, an Oracle consultancy that specialises in building solutions using MDD techniques.


Aug
18
revised Linked Server using ODBC too slow
edited tags
Aug
18
revised SQL Server SSL connection
SQL is a language, not a DBMS.
Aug
18
revised SQL Server 2012 error when exporting to Excel
SQL is a language, not a DBMS.
Aug
18
reviewed No Action Needed Linked Server and MSDTC on cluster
Aug
18
reviewed Reviewed Combine two mySQL sum queries into one which use different where clauses
Aug
18
comment Combine two mySQL sum queries into one which use different where clauses
And please fix your spelling while you're editing. It all smacks of laziness. We can only help you if you help us.
Aug
18
reviewed Reviewed SQL Server 2008 R2 to 2012
Aug
18
reviewed Reviewed Can a slave with a dynamic ip update the master
Aug
18
comment Can a slave with a dynamic ip update the master
Use dynamic DNS maybe?
Aug
18
reviewed Reviewed How to change the domain name or IP address in mysql database in every tables
Aug
18
comment How to change the domain name or IP address in mysql database in every tables
First of all, this seems to me like an Openfire admin topic: have you asked on an Openfire forum?
Aug
18
comment Update table from different table
I wouldn't add ROWNUM = 1 unless for a single row of the table you're trying to update all rows returned by the subquery have the same values. In that case adding DISTINCT to the subquery would have the same functional effect. So add DISTINCT first. If you still get the same error, than adding ROWNUM = 1 is dangerous as you are selecting the first row of multiple where they are different...
Aug
18
comment Update table from different table
Using MERGE won't help with this, @vegatripy
Aug
18
comment Update table from different table
You need to check the where clause in the subquery to make sure it is returning a single row for each row of the table you're trying to update. In my experience, looking at what the primary or unique keys are helps a lot.
Aug
18
comment Update table from different table
First of all: This is not a syntax error as your statement is syntactically valid SQL.
Aug
18
reviewed Reviewed users and roles in mongodb
Aug
18
revised users and roles in mongodb
edited tags
Aug
18
reviewed No Action Needed Why straight SQL query run faster than stored procedure?
Aug
18
reviewed Reviewed Update table from different table
Aug
18
revised Update table from different table
deleted 5 characters in body