My Filter
   28 tags on

My Filter

  • All Sites
  • Arqade

0 answers

Use 1 junction table with 3 foreign keys Or 2 junction tables with shared sequencing?

I have 3 tables that I am trying to properly create relationships between: game phase game event (a step in a 'game phase') action window (a radically different kind of step in a 'game phase') A ...

3 answers

How to SELECT INTO newTable FROM subquery?

There are two tables with hundreds of columns, a and b. I am trying to outter join them as a new third table, c. SELECT * FROM a FULL JOIN b ON Since there are too many columns, it is ...

3 answers | 1 min ago by Chubaka on Stack Overflow
2 answers

Duplicate row with Primary Key in PostgreSQL

Assume I have a table as follows named people, where id is a Primary Key: +-----------+---------+---------+ | id | fname | lname | | (integer) | (text) | (text) | ...

1 answer

Create temporary table inside a procedure [mySQL 5]

Here is the error I get when I try to run the code below. I spent a day on mySQL tutorials + forums without any success. DROP PROCEDURE IF EXISTS update_end_date_dwh_dimension_product; delimiter ...

2 answers

need to combine 3 sql-statement into 1

I have 3 SQL-Statements that I would like to combine into just one so I dont have to make multiple requests to my database from my programm (java). My DB is PostgreSQL 9.4 First one creates a new ...

2 answers | 8 mins ago by Alkahna on Stack Overflow
0 answers

SQL Server database not restoring

I want to restore a database backup of SQL Server 2005 to SQL Server 2012 but the database is not restoring. Then I run a query to check database : DBCC CHECKDB(demo) WITH PHYSICAL_ONLY after that ...

1 answer

How do I optimize my trigger using math?

I have a problem with my trigger, it looks like this: CREATE TRIGGER [Balance_monthly] ON [dbo].[Balance] FOR INSERT, UPDATE AS BEGIN SET NOCOUNT ON UPDATE Months SET ...

0 answers

Executing the store procedure in MySQL Query Browser But not execute show exception like You have an error in your SQL syntax

Exception copied from MYSQL Query Browser You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 10 ...

0 answers

Zero_or_One vs One_or_only_One entity relation just for initially allowable Null field

I have confusion about Zero_or_One vs One_and_only_One entity relation in step 4 of the following scenario. The scenario is: There are two entities: School and Teacher. Without cardinality defined, ...

0 answers

Cross database migration from SQL Server 2012 to PostgreSQL on Linux server

I want to do real time replication from SQL Server 2012 to PostgreSQL and PostgreLSQL is hosted on a Linux machine. One time migration has already been done. As a temporary solution, through Bash ...

1 answer

IF condition in connect command in SQL*Plus

I want to fire SQL queries only when the user is connected to SQL*Plus. In my case even if the connection is not there, the rest of the commands are running in my SQL script. if "connect ...

1 answers | 11 mins ago by Riya on Database Administrators
5 answers

Solve the query using join?

I have a table session1 and need to find only new entries who logged in with specific id. create table session1(name varchar(16),id integer); insert into session1 values('anshu',20); insert into ...

5 answers | 12 mins ago by pankaj on Stack Overflow
2 answers

Insert all data of a datagridview to database

Dim Con As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Music_Sales_Database.mdb;") Dim Com As OleDbCommand Dim SaleCode As Integer Dim MusicID ...

1 answer

How to produce 1 row output on join case SQL Server

I have two tables in an SQL Server database. EMP table... ID NAME A -- ---- - 01 Tony Y 02 Fred N and a group membership table (GRP)... ID GRP START FINISH KEYSK -- ------ -------- ...

1 answers | 16 mins ago by AjN3806 on Stack Overflow
1 answer

How to filter stored procedures as READ and WRITE in SQL Server

Is there any query to get all the write procedures from SQL Server?

1 answer

delete WSFC 2012 cluster role/group fails

PS C:\Windows\system32> get-cluster Name ---- sql2012poc_cl1 PS C:\Windows\system32> get-clustergroup Name OwnerNode State ...

13 answers

Get list of all tables in Oracle?

How do I query an Oracle database to display the names of all tables in it?

13 answers | 20 mins ago by vitule on Stack Overflow
2 answers

Optimize nested for loop query

I have two tables Emp & Emp_Details Emp -> EmpId, EmpName Emp_Details -> EmpDetailId, Domain, Year, Date_of_record Each employee has many domains, where their perfomance is measured, and ...

2 answers | 23 mins ago by reiley on Stack Overflow
4 answers

SSRS - Expression to create string for reporting heading

I have a report which has 6 parameters within it. What I would like to do is make these parameters part of my report heading. My parameters are as follows: @BMDataType1 Text @BMDataComp1 Float ...

4 answers

Convert a row data to columns in sql server

I have a scenario in which I have three columns with multiple rows, I need to select them in single row. Below I am attaching temporary table scenario. CREATE TABLE #Temp ( PersonID INT , ...

1 answer

Exporting foreign key from many to many relationship to another table sql

I've a table CREATE TABLE [dbo].[CoursesOfferedToBatches] ( [CourseId] VARCHAR (50) NOT NULL, [Batch] INT NOT NULL, PRIMARY KEY CLUSTERED ([Batch] ASC, [CourseId] ASC), ...

1 answers | 27 mins ago by Muhammad Rehan Qadri on Stack Overflow
1 answer

Working on a project without a connection string

I am trying to publish my website on the intranet server. From websites and suggestion I understood that i had to change the connection string to point to the database in the intranet server. While ...

1 answer

How to update XML node occurring multiple times in XML of DB2 table structure?

We are facing an issue with DB2 SQL. We are trying to check if we can get a solution to this. Problem Statement: 1. Writing a SQL to update an XML node which occurs multiple times in nested form ...

1 answers | 31 mins ago by Sam on Stack Overflow
1 answer

Modify collation on NHibernate queries

I have a large ASP.NET application that uses NHibernate (v3.2.0.4000) to access SQL Server 2005 as the back-end data-store. We have multiple customers, with each customer having their own database, ...

1 answers | 32 mins ago by CraigTP on Stack Overflow
1 answer

Android SQLlite Sort with simple query

Maybe someone can help me before i lose my mind. I want to sort a SQL database. SQLiteDatabase db = getWritableDatabase(); db.query(TABLE_NAME, new String[]{COLUM_MAME_1, COLUM_MAME_2, ...

3 answers

SQL select data from multiple tables with subqueries (including data from inner join) Error: 1242

I'm trying to set up a DB for a friend. I want to display the ID from Table1 (TID) and the results of an inner join. The following statement is not working. Situation: Two Tables: Table 1 PK:TID, ...

0 answers

Webservice having trouble pass back to client

I having trouble passing back the result which is multiple row getting from MS-SQL2012 to client. I have tried to google up but still not find the solution. Since I'm new in .NET and this is my first ...

0 answers

Enterprise architect - stored procedure result set

EA doesn't recognize procedure input parameters (after SQL Server reverse engineering a database). Example: create PROCEDURE [dbo].[ SD_IPPG_PK] ( @IPSPK___ int = 0 -- this! ) and ...

0 answers

Can not update SQL database in WCF service using Entity Framework

I am passing Data Class value to entity update method using WCF rest service.But database is not updating value which is pass through WCF rest service. Below is my code please review it and if any ...

0 answers

Need to help scd type1 implemenation in SQL Server 2008

I have a question about SQL Server. Table: Dimemp empkey | empid | name |loc 1 | 100 | abc |Hyd 2 | 102 | def |chen ...

15 30 50 per page
1 2 3