comprasconencanto1

I'm creating a set of SQL INSERT statements for a database that doesn't exist yet, and I&#… Read more Perl Dbi Without Accessing The Database

I have data like below with a start and end date. The record could start and finish on the same day… Read more Split/extrapolate Single Records By Date Range Into Multiple Records

Goal I am attempting to migrate data from a multi-layered XML file with nested elements to a single… Read more Data Migration From Multilevel Xml To Single Table With Ssis

I'm wondering if there is a tool to generate the UPDATE statement based on data already inserte… Read more Generate Update Statement In Sql Server For Specific Table

I have searched others' code and tried to customize in my case, but it seemed when the question… Read more Use Top Or Rank When Finding The First Few Or The Most Observations

I am writing a stored procedure. I have a problem on EP.Clerepartition column. I want to select thi… Read more Select With Case

I have a table including: ID Name Period0Id Period1Id Period2Id What I would like to receive data … Read more How To Write An Attribute Name To The Select Query Dynamically

I know there have been a lot of questions about Entity Framework doing cross database queries on th… Read more Can Code-first Entity Framework Do Cross Database Queries With Sql Server Dbs On The Same Box?

I am trying to use the Ruby Sequel gem for DB operations. I am stuck for incrementing and decrement… Read more Sequel Gem Increment

At work we have two servers, one is running an application a lot of people use which has an SQL Ser… Read more Linked Server Performance And Options

Not ASC or DESC.... Order by custom... I have tried using case but not successfully SELECT * FROM C… Read more Custom Order By In Sql Server Like P, A, L, H

I have a the following table ItemStatus ---------- id item_id status I want to select all item_ids… Read more Select Records From A Table Where All Other Records With Same Foreign Key Have A Certain Value

For my project, I implemented linked list with rdbms. The linked list uses rowid column as a pointe… Read more Retrieving Entries Of Linked List In Relational Database

I'm looking at a way to integrate Alembic with SQLAlchemy. What I need is a way so that Alembic… Read more Integrating Alembic With Sqlalchemy

I am querying database to populate listview inside build method but future builder is returning nul… Read more Flutter Futurebuilder Snapshot Is Null After Database Query Until Hot Reload

In Azure, how can you configure an alert or notification when a SQL Server failover happened if you… Read more In Azure, How Can You Configure An Alert Or Notification When A Sql Server Failover Happened?

I am having problem in using mysql like keyword in certain condition. My requirement goes like this… Read more Include Space In Mysql Like Search

I am a beginner of SQL, having this table instructor: ID name dept_name salary 001 A … Read more Sql: How To Find Maximum Value Items According A Attribute

We are using SQLite (Xerial JDBC driver) on a windows desktop based Java application. Now we are mo… Read more Use Of Sqlite On Network Share

I create a class for working with SQLAlchemy : class DbAbsLayer(object): def __init__(self): … Read more Sqlalchemy.exc.unboundexecutionerror: Could Not Locate A Bind Configured On Mapper Mapper|sellstable|sellers Or This Session

I tried to read about not a group by expression errors from some other posts, but all of them menti… Read more Really Simple Sql Not A Group By Expression - Oracle

Please excuse the noob question as I am new to integrating data with my applications. I've trie… Read more Dataset Or Entity Data Model

Good Evening everyone, Today I would like to ask a question relating to derived fields (also known … Read more A Derived Field In An Sqlite3 Database

I'm looking to run a batch file on windows xp professional which creates a system odbc data sou… Read more Command Line To Create Data Source With Sql Authentication?

I have a table that looks like this: RecNo | TaskDesc | SeqNumber 1 | test | 1 2 | tes… Read more How To Reorder A Sql Table

I want to use the following SQL statement in a small C# application. The SQL statement runs perfec… Read more C# Parameterized Query With Domain Aggregate Functions (dmin)

I have a script that runs Invoke-SQLCmd against a SQLServer called Server1. Data that is collected … Read more Running Powershell Scripts Through Sql

Hi I am trying to simply get the count of data in source table. CREATE OR REPLACE PROCEDURE MOVE_C… Read more Unable To Run Dynamic Query In Stored Procedure While Selecting Count Of Records

I am trying to get the total amount of registered users per day. At the moment I am using this: $sq… Read more Mysql Date_sub(now(), Interval 1 Day) 24 Hours Or Weekday?

I have a master table 'Repairs' and a detail table 'RepairDetails' I am trying to … Read more Don't Understand Sql Procedure Error

I've been staring at this for a while now. Maybe some fresh eyes will be able to point out what… Read more Mysql If Exists

Hi I have sql table I want to calculate all the fields to total sum field. Solution 1: You can do … Read more How Can I Calculate Sql Tables In Delphi ?

In the latest two weeks, without releasing an update to my app, I have started getting a bunch of r… Read more Android Database Corrupt, But Can Open In Sqlite Manager. Recoverable?

I am looking for a 'better' way to perform a query in which I want to show a single player … Read more Add Up Conditional Counts On Multiple Columns Of The Same Table

I'm facing a problem when I try to insert a column in the database using Kotlin in Android. Thi… Read more Error In My First Table In Kotlin

I'm trying to create a view on H2SQL, but i cannot find the correct syntax. I'm using: CREA… Read more Create View On H2 Database

I'm trying to add a constraint to a table so that it displays one of the columns as the current… Read more Need To Add Constraint: Date Plus 10 Days

I need help in optimize a PostgreSQL query which uses the BETWEEN clause with a timestamp field. I … Read more Optimize Between Date Statement

I have a select, and I need to limit data only for two last days. So today is 24th Aug 2016 so I ne… Read more Sql Server: Getting "before Two Days" Date

When performing UPDATE and INSERT queries using Zend_Db, I frequently need to set values equal to N… Read more How To Set A Value To Null When Using Zend_db

I have a SQL Server installed on my PC (a terminal). I want to create a new database which its file… Read more Sql Server: Database On Network Share

I am trying to use use a temp table with SQLAlchemy and join it against an existing table. This is … Read more Use Temp Table With Sqlalchemy

Looking at the diagram for our ClientId hierarchy I see a pattern that is repeated in most hierarch… Read more Is [all] A Level Aswell As A Member

I'm about to use a database on Android for the first time, but there is a thing I'm not sur… Read more Sqlite And Database Initialization

I just created a new web application that accepts some form based input from the user and inserts i… Read more Sql Server 2008 - Removing Schema Ownership

I have a table in database with numbers of tenants, each tenant lists a record of their sales per d… Read more Fill Missing Dates In A Date-sequenced In Sql Using Tally Table

I am faced with the following situation: I created a trigger which reacts on insert to the third t… Read more Add Data To Trigger From The Last Insert

When using the 'Script Index as CREATE To' to duplicate an index from one table to another … Read more Microsoft Sql Service Management Studio 2005 'script Xxx As Create To' Problem

I'm having an issue updating a 'bit' column in a SQL database, using C# and Entity Fram… Read more Updating Sql Bit Column From Entity Framework

There are two tables, T1 includes start date column and T2 includes end date column. Both the colum… Read more How To Calculate No. Of Days Between Two Datetime Column In Sql Server

Forgive my example if it does not make sense. I'm going to try with a simplified one to encour… Read more Postgresql: How To Return Rows With Respect To A Found Row (relative Results)?

Possible Duplicate: I can’t get my JTable to show anything I can show my Table but I can't ge… Read more I Get The Jtable But No Data

Am trying to Fetch Only one record from the Sybase Table without using the RowCount Function, even … Read more Select Top 1 * From Table Fails In Sybase Procedure

I am trying to do a running total for some data, and have seen the easy way to do it. However, I ha… Read more Sql - Running Total When Data Already Grouped

I am using SQL Server 2008. I have two table Shift and Break with following data: The shifts will b… Read more Calculate Work Time From Shift And Break Table

I recently encountered a problem caused by a typo in the database creation script, whereby a column… Read more What's The Purpose Of Varchar(0)

Mediawiki has a table in the database 'text' which contains the page content. It is saved a… Read more How To Run A Query To Find A String In Blob Files?

My problem is as follows: When i create POST request in 'Postman' app. This is what i try t… Read more Message -"could Not Read A Hi Value - You Need To Populate The Table: Hibernate_sequence"