My Filter
   28 tags on

My Filter

  • All Sites
  • Arqade

3 answers

How to do sum of the two different time

i have the following code : SELECT distinct userinfo.userid,,timeframe,deptname from EarlyOut INNER JOIN userinfo ON USERINFO.USERID = earlyout.USERID INNDER JOIN DEPARTMENTS ON ...

1 answer

SQL Query Conversation

I have an SQL query like this: SELECT M.ID, M.A, M2.B, M3.C FROM MYTABLE M LEFT JOIN MYSECONDTABLE M2 INNER JOIN MYTHIRDTABLE M3 WHERE M.ID=5 OR M.ID=10 I would like to number ...

1 answers | 2 mins ago by IsThatSo on Stack Overflow
0 answers

MSSQL Query exceeding allowed memory in php

I have a query that uses stuff() when using it in PHP it fails due to it running out of memory. the error occurs on this line; $data = odbc_exec($conn, $query); at this point php doesn't actually ...

1 answer

SQL Reporting Use stored proc or query/view

I'm a software developer not a TSQL or DBA expert, just background. One of my applications uses allot of SQL views for reporting purposes, at this stage (might change) the windows application execute ...

1 answer

SQL-server database recovery complete?

I'm having trouble working out when a database is 'ready' after an unscheduled SQL Server restart. If there was a large transaction running when the server was restarted the database will go into ...

1 answers | 4 mins ago by Tristan on Database Administrators
1 answer

Is it better to perform many small queries on a database, or one big one?

So I'm involved in a group project for some uni work, and we're making a javascript application that's basically going to display some information from a database. I'll leave out the specifics for now ...

1 answer

How to convert string into number in netezza

i have table_1 include some field, one field name is THROUGHPUT in char datatype(the value is number) i want to use function avg() to get average value from all THROUGHPUT value in netezza, i have ...

1 answers | 8 mins ago by ihsansat on Stack Overflow
3 answers

How to insert data into tables that have foreign keys

SQL> desc invoices Name Null? Type ----------------------------------------- -------- ---------------------------- INVOICE_ID ...

0 answers

Return multiple rows from a recursive stored procedure

I would like to return multiple rows as a result from a stored procedure. I am calling this stored procedure recursively, to read all nested values. This is my current procedure: CREATE OR REPLACE ...

0 answers

implementing postgresql trigger for enrollment limit

I'm trying to create a trigger in the enrollment form so that if the section id is inserted past the limit then it will raise exception. The section table contains the limit for the section id in the ...

0 answers


I want to add data from multiple checkbox to multiple table data. My project is Student Attendance. im using multiple checkbox to tick absent and present. Example : from att.php <?php ...

2 answers

In SQL how to select tuples whose “character varying(5)” column values are fixed size?

For example I have this table with a zipcode column(zipcode character varying(5)) but some of "bad" rows have invalid zipcode like "9000" or "2". and I want all the tuples whose zipcode values have ...

2 answers | 17 mins ago by user3692521 on Stack Overflow
2 answers

Making Large IndexedDB Persistent in Browser

I am looking at making a LOB html5 web application. The main part we are trying to accomplish is to make the application offline capable. This will mean taking a large chunk of SQL data from the ...

2 answers

Get ranges of an ordered set of rows in oracle

I have this table. Seq key 1 A 2 A 3 A 4 A 5 B 6 C 7 C 8 C 9 C 10 A 11 A I want to query this and return a range of the key in order. key strt end A ...

2 answers | 18 mins ago by DRTauli on Stack Overflow
4 answers

Sonar remarks make SQL unreadable?

I ran the following code through Sonar, a static analysis tool. Original file: public interface LegRepository extends CustomRepository<Leg, Long> { final String ...

1 answer

Return NULL value when MySQL returned an empty result st

I have a query as shown below. select a.ab as new from tab a inner join tab b on a.ab=b.ab When i try to run its showing. MySQL returned an empty result set (i.e. zero rows). because there ...

1 answers | 22 mins ago by Shreyas Tg on Stack Overflow
2 answers

postgresql update newest rows

I have some problems with update query. My task is to change status in news rows of my data example: id product_id import_id modified_at status 30470 30470 5 ...

2 answers | 22 mins ago by Nigh4mare on Stack Overflow
2 answers

SQL query create stored procedure error 'Incorrect syntax'

I use sql to create the stored procedures , but I get an error " Incorrect syntax near ' = ' " And here is my code CREATE PROC [dbo].[sp_T_CATEGORY_GetByTop] @top nvarchar(10), @where nvarchar(200), ...

0 answers

TSQL to prepare 15 Min Chunk Data

I am having a warehouse Fact Table containing raw data (Even Duplicate Data) received from vendor through a data feed. I need to prepare the chunk of 15 Min Interval data. How can I best SQL Server ...

2 answers

How to Query and Arrange Two Similar Tables

I have one student table links to two scores tables which are exactly the same structures. The only different is that one table will stores high scores, the other table stores low scores. Now I need ...

2 answers | 25 mins ago by user1314404 on Stack Overflow
2 answers

How to Update Week Number in SQL?

I have a following which are displayed order by date. I want to group each weekseries as below. Select tq.ID, CONVERT(VARCHAR(10),tq.DateCreated,101)WeekDate, ...

5 answers

Conversion failed when converting the varchar value

When I try to run this, it gives me the following error message: Conversion failed when converting the varchar value 'category_id' to data type int. Here's my SQL and parameter code, I supposed ...

2 answers

Check if date falls between previous row start date and end date

I have the following sample data: id Ref User Task Refernce Start End rn 1 12222 Joe Bloggs Task 1 Ref001 24/02/2014 20/07/2014 1 2 12568 Joe Bloggs Task 1 ...

1 answer

Execute sql stored procedure with array input from kettle table input step

I am having a sql stored procedure that takes 2 inputs and returns a resultset based on the given input. I am using the input1 in sql IN clause like, WHERE myCol IN(@input1) when executing the ...

3 answers

When to use Null vs. N/A in columns?

Suppose you have 2 columns in a table: FixedSalary and HourlyRate. The value for one of these columns is always going to be missing because an employee cannot be paid both a fixed salary and an hourly ...

0 answers

how to get data from postgresql to jqxgrid through npgsql provider

I am using postgreSql db version-9.4, I need to tranfer data from postgreSql database into jqxgrid through npgsql provider please someone help me out on this

3 answers

Database structure design for different categories

I have two tables in my database...1st table named as categories contains all the parent categories and sub shown in the figure below... Categories_id name ...

1 answer

Removing CONSTRAINT in SQL takes too long

I'm running the query below on SQL Server 2008 R2 to disable a constraint to be able to do some modifications ALTER TABLE mytable NOCHECK CONSTRAINT UCxxxx and it's been 50 minutes and still ...

3 answers

i get exception thrown when i try running this code.. (import to sql database)

An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll Additional information: External table is not in the expected format. if ...

3 answers | 55 mins ago by Umar E. Shaibu on Stack Overflow
2 answers

How Can I merge two DateTime parts (Hour, Minute, Second) in SQL?

I have two datetime field in my Table like these: Transaction_RequestDateTime Transaction_ResponseDateTime I assigned value to this field in this way : (in C# win form program) ...

2 answers | 57 mins ago by Elahe on Stack Overflow
15 30 50 per page
1 2 3