Tagged Questions

An acronym for "Structured Query Language" (it's not the name of a specific DBMS product), SQL can be used in relational database management systems (RDBMS) to query, update, delete, and insert data as well as modify the structure of the database. It can also be used to manage schemas and data ...

learn more… | top users | synonyms (1)

0
votes
0answers
3 views

Summarizing Pay Checks Based on Employee's Job Code

What I'm trying to do is summarize an employee's earnings for each job code they worked in for the year. Employees are assigned a job code based on an effective date. I'm trying to line up the job ...
0
votes
0answers
4 views

Database Normal Form (financial statement)

I would like some advice on how to design the database for financial statement data which objectively addresses the tradeoffs between usability, performance, maintenance and adherence to normal form. ...
0
votes
0answers
8 views

I'm having a problem connecting SQL Server for internet access

I'm having a problem connecting SQL Server for internet access. I have built a test server so that I can play at home and not kill the works server. I've been trying for days and so far I have: My ...
0
votes
0answers
32 views

Size of Table Now vs 2 Years ago

I am trying to Analyze the growth of the data/tables within a database. I would like to analyze how much Data is currently present in a table and how much there was 2 years ago. There are date fields ...
0
votes
0answers
38 views

How to combine two queries?

I can't explain this very well except by spelling it out. I start a query on ID, and from there I can get TITLE, DATE, and REGNUMBER. The problem is I also want to get 'where,' which is also stored ...
-3
votes
0answers
38 views

Joining Multiple Tables in Sql Query [on hold]

I have four tables with their attributes; namely Check_Gauge, Storage_Facility, Product, Product_Brought. The first three tables are related through their primary keys. Product_Brought is not ...
1
vote
2answers
34 views

How can I simplify this UNION?

Here's the case - I have the following query: SELECT DISTINCT post_id FROM ( ( SELECT DISTINCT rp.post_id, pm.meta_value AS premiere_date FROM wp_related_people AS rp JOIN ...
0
votes
2answers
32 views

Remove duplicates and connect relations to the first one

Guess I can use some help over here. I have split a products table into two tables, products and prices. This is the original table: products: +----+--------+-----------+-----------+-----------+ | ...
0
votes
2answers
24 views

Allowing users access to SQLPLUS and to compile PLSQL

As a DBA - assuming my users are knowledgeable with PLSQL and SQL - why would I not grant my users privileges to compile and run their own PLSQL code. We have an MI database environment where the data ...
0
votes
0answers
12 views

Convert a list into one row with dynamic column in MySQL [duplicate]

I have a list of row to be converted into a dynamic column that depends on the record in one particular column. From this statement FID |Steps | Action ---- |------|-------- 1416 | 1 | Sit ...
1
vote
0answers
17 views

Wich is the most efficient/easy way for end-user to get data from Analysis database?

I know that you can quey a cube by connecting from excel to Analysis database and using formulas like cubevalue() or cubemember(). I also know that after converting the power pivot to formulas you can ...
0
votes
1answer
26 views

How to query sum all the wins of each team

Matches ID| radiant_name | dire_name | radiant_win 1 | LV | LGD | true 2 | LGD | LV | false 3 | LV | LGD | false 4 | LV | LGD | false ...
1
vote
1answer
18 views

How to restrict access to current user record and its rights in postgres

Postgres 9 database contains additional information about postgres users: create table public.user ( user char(10) primary key, -- CURRENT_USER in postgres name char(30) ); and user roles; ...
-4
votes
0answers
30 views

Defining Role of Super Admin, Admin and User from DB table [on hold]

I have a column in my sql table where I want to define the role of the user. If User is SuperAdmin its value will be -> 0. For Admins it will be -> 1 For Users it will be -> 2. Also. I have column ...
2
votes
2answers
35 views

Multiple Instance with different service packs in SQL Server

I would like to install a Default instance with SQL Server 2008 R2 RTM and I want to install another named instance with SQL Server 2008 R2 SP2. Is this possible?
4
votes
0answers
88 views

There is insufficient system memory in resource pool 'internal' to run this query

One of our production servers reporting error in log Error: 701, Severity: 17, State: 123. There is insufficient system memory in resource pool 'internal' to run this query. I searched for ...
0
votes
1answer
14 views

Reviewing Stored Procedure template for handling transaction?

I've prepare a template for SQL Server stored procedures which will have Insert, delete, Update transaction. I have a stored procedure to log error in catch block in a table. How can I improve my ...
0
votes
0answers
36 views

select sequential rows

How would I go about selecting a sequence of rows. Where every row in the sequence: Must only be 1 day apart ~ Thereby the whole sequence of rows must have sequential dates Must have a count higher ...
2
votes
1answer
19 views

Changing feature on a database that is a member of SQL Server AlwaysOn availability group

Our developers need a change on a database that is in the Availability group (they need Service broker in one of the databases to be enabled) but when I try to do it I am getting error saying that I ...
2
votes
3answers
49 views

Bulk Delete for Large Table in MySQL

I have a Notification table contains about 100 million rows host in Amazon RDS with 1000 IOPS, and I want to delete those rows older than one month. If I do DELETE FROM NOTIFICATION WHERE CreatedAt ...
0
votes
0answers
26 views

PL/SQL IDE like C++ compilers [on hold]

Are there IDEs out there like Codeblocks that can help debug syntax errors in PL/SQL scripts? I am currently using Oracle XE and trying to create a PL/SQL script.
1
vote
1answer
21 views

CONCAT() between different alphabet echoes out '&' ampersand

I want to concatenate different alphabet strings and get a weird latin encoding with ampersands after the sixth greek character (I want to concatenate greek and english alphabet strings). Lets say I ...
0
votes
2answers
48 views

How to use max function in such condition?

My query is select * from guestuser union select * from olduser ORDER BY userid DESC LIMIT 1; Is that correct query to find last userid from different table have different userid? can i change ...
0
votes
0answers
55 views

Query that can pick up data that falls between rows having unique parameter [on hold]

Suppose a table has data in the following format: Id Name ----------- Main Abc Check Def Check Ghi Main Jkl Check Mno Check ...
0
votes
0answers
21 views

Need some questions to show some trends [on hold]

I have a college project:create a database from a dataset and normalize it. I also have to do some trend and data analysis via sql queries, reports, etc. Please give me some interesting questions for ...
2
votes
1answer
37 views

I am Trying to Write an Access Query to Get a person having a First Name and Last Name but not all People having any of those names

I am using Microsoft Access. In my search form I have 3 text boxes that I enter text to search for: First Name; Last Name; Last 4 of SSN. With the current query when I enter text into multiple boxes ...
1
vote
0answers
16 views

MySQL - Transactions and causality

I'm new to MySQL's LOCK and TRANSACTION and have a question about different isolation levels of a transaction: Given two transactions executing the same code (auto-commit is false): (1) get data of ...
0
votes
0answers
54 views

Improving Statistics for Query Plan

I have a table with over 2.1 million rows. This table has a column rID, which joins to a PK on another table. As you can see from the distribution below, most rows contain a null for rID; which ...
0
votes
2answers
36 views

SQL: TSQL to Find invalid views

we have a Tuesday/Thursday Maint window for one application we support. On Tuesdays we modify one facility and thursday if there are no errors we roll all the changes out to the other facilities. The ...
2
votes
1answer
70 views

Database Implementations of ORDER BY in a Subquery [on hold]

I am using an application (MapServer - http://mapserver.org/) that wraps SQL statements, so that the ORDER BY statement is in the inner query. E.g. SELECT * FROM ( SELECT ID, GEOM, Name ...
-3
votes
1answer
20 views

Which is best tool for database backup file encryption? [on hold]

Which is best tool for database backup file encryption other than TDE and inbuilt feature of SQL server 2014. I want to do as follows, Take a database backup in SQL Server Encrypt with third party ...
-1
votes
0answers
38 views

SQL Server is very slow [on hold]

In company with 30 clients(computers), after 3-4 hours working with financial software, SQL Server is very slow SQL Server can not free used memory and the query execution time is very slow but after ...
0
votes
0answers
27 views

Time based trigger for database update [on hold]

I have a database table in SQL Server as following ID | Name | ExpireTime | CountLeft 1 test 11/11/2014 2:30 5 I want to update countLeft = 0 when ExpireTime = currenttime ...
0
votes
1answer
24 views

Get Current Row and Next Row [on hold]

I want to design a query which gets the row of where clause and the next row in the table of the where clause. I am looking for something like select column a, next row in table from table where ...
-4
votes
0answers
16 views

SQL Procedure of signing up [on hold]

If the database needs to store an e-mail and password of each user using a procedure for signing up, how can the procedure be written?
1
vote
1answer
41 views

Join select queries on an id in SQL Server

I have three tables that SELECT from and I'd need to join the results. It feels like this should be a rather easy task but I struggle with the syntax. Working on Microsoft SQL Server Enterprise ...
0
votes
1answer
39 views

Insert values in table from front-end CategoryId

I want to add a value from front end into a table. I want to do it in asp.net. I have a table which is as below:- CategoryId int CategoryName nvarchar(50) not null ParentId ...
0
votes
0answers
20 views

Left Outer Joins in Access

I'm working on an existing Access database trying to implement some changes which will allow the estimation of cutting times for my employer (We're an industrial company who fabricate Flight Cases). ...
0
votes
1answer
23 views

Multiple left join hangs server

i've got problem with left join query. It connect's 3 tables and calculate sales value for categories. Query: SELECT categories.name, categories.id, ...
0
votes
0answers
17 views

INSERT missing FK rows at the same time

I found on this site the following SQL-Query to perform an insert (see this post): WITH sel AS ( SELECT val.description, val.type, f.id AS foo_id FROM ( VALUES ('testing', ...
0
votes
0answers
17 views

change display of rows into column using PIVOT in sql server [migrated]

This is my query: select d.disposition, count(a.serialnumber) AS SUBTOTAL FROM FADB a, FARepair b, Disposition d WHERE a.ID = b.ID AND b.DispositionID = d.DispositionID GROUP BY d.Disposition and ...
0
votes
0answers
11 views

Installing printer_php.dll onto an azure website

Has anyone been able to get this extension running on a php based azure website? The extension just basically allows you to print stuff with your printer. I've configured my php.ini to find the ...
0
votes
2answers
32 views

SQL Performance: COUNT or extra attribute?

If I want to count the number of a multivalued attribute, which way is faster: a) using COUNT(attribute) on a whole table or b) adding an extra attribute which counts these stored values (to be ...
0
votes
1answer
29 views

How to design a query that gives count of different parameters based on different condition from a single table

I have a table books containing columns as bookid, issue_date,return_date. Once a book is issued from library an issue_date corresponding to it is made into the table while return_date can have valid ...
0
votes
1answer
22 views

SQL: return values as column table

I am running this query to get all returns for a list of tickers: select return1 from STOCK_DATA where TDATE between 20130101 and 20131231 and TICKER in (SELECT DISTINCT TICKER FROM STOCK_DATA) ...
0
votes
0answers
38 views

Table design for optimum performance

For example let's say I have to create a table called Employee with columns EmployeeID, Name, DOB, Address, DepartmentID[FK]. So I create the table as follows with a primary key and a nonclustered ...
0
votes
1answer
16 views

Mysql pagination without offset

Let's assume I have got a table with these data: I want to order it by createdAt column DESC, and id column DESC select id, createdAt from post order by createdAt desc, id desc Now it looks like ...
0
votes
1answer
32 views

where in (sub query) vs join

just want to ask about how to optimize my query. because i feel efficiency using join instead of "where in" sub query can someone enplane the deference SELECT C.Customer_id, C.tran_id, ...
0
votes
0answers
28 views

MySQL: How to get all values in “TICKER” column`? [migrated]

I never used SQL before, I want to get all values in "TICKER" from this database: The first statement select TDATE, price, return1 from STOCK_DATA where TDATE < 20131231 and TDATE > ...
-1
votes
0answers
12 views

Template for MySQL database upgrade script

What is the equivalent of this Microsoft SQL Server upgrade script template for MySQL? I want to upgrade my database version in repeatable transactions in sequential scripts as I develop an ...