Skip to content Skip to sidebar Skip to footer
Showing posts from October, 2024

Perl Dbi Without Accessing The Database

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

Split/extrapolate Single Records By Date Range Into Multiple Records

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

Data Migration From Multilevel Xml To Single Table With Ssis

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

Generate Update Statement In Sql Server For Specific Table

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

Use Top Or Rank When Finding The First Few Or The Most Observations

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

Select With Case

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

How To Write An Attribute Name To The Select Query Dynamically

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

Can Code-first Entity Framework Do Cross Database Queries With Sql Server Dbs On The Same Box?

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?

Sequel Gem Increment

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

Linked Server Performance And Options

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

Custom Order By In Sql Server Like P, A, L, H

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

Select Records From A Table Where All Other Records With Same Foreign Key Have A Certain Value

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

Retrieving Entries Of Linked List In Relational Database

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

Integrating Alembic With Sqlalchemy

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

Flutter Futurebuilder Snapshot Is Null After Database Query Until Hot Reload

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?

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?

Include Space In Mysql Like Search

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

Sql: How To Find Maximum Value Items According A Attribute

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

Use Of Sqlite On Network Share

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

Sqlalchemy.exc.unboundexecutionerror: Could Not Locate A Bind Configured On Mapper Mapper|sellstable|sellers Or This Session

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

Really Simple Sql Not A Group By Expression - Oracle

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

Dataset Or Entity Data Model

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

A Derived Field In An Sqlite3 Database

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

Command Line To Create Data Source With Sql Authentication?

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?

How To Reorder A Sql Table

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

C# Parameterized Query With Domain Aggregate Functions (dmin)

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)

Running Powershell Scripts Through Sql

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

Unable To Run Dynamic Query In Stored Procedure While Selecting Count Of Records

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

Mysql Date_sub(now(), Interval 1 Day) 24 Hours Or Weekday?

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?

Don't Understand Sql Procedure Error

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

Mysql If Exists

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

How Can I Calculate Sql Tables In Delphi ?

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 ?

Android Database Corrupt, But Can Open In Sqlite Manager. Recoverable?

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?

Add Up Conditional Counts On Multiple Columns Of The Same Table

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

Error In My First Table In Kotlin

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

Create View On H2 Database

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

Need To Add Constraint: Date Plus 10 Days

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

Optimize Between Date Statement

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

Sql Server: Getting "before Two Days" Date

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

How To Set A Value To Null When Using Zend_db

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

Sql Server: Database On Network Share

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

Use Temp Table With Sqlalchemy

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

Is [all] A Level Aswell As A Member

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

Sqlite And Database Initialization

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

Sql Server 2008 - Removing Schema Ownership

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

Fill Missing Dates In A Date-sequenced In Sql Using Tally Table

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

Add Data To Trigger From The Last Insert

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

Microsoft Sql Service Management Studio 2005 'script Xxx As Create To' Problem

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

Updating Sql Bit Column From Entity Framework

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

How To Calculate No. Of Days Between Two Datetime Column In Sql Server

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

Postgresql: How To Return Rows With Respect To A Found Row (relative Results)?

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)?

I Get The Jtable But No Data

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

Select Top 1 * From Table Fails In Sybase Procedure

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

Sql - Running Total When Data Already Grouped

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

Calculate Work Time From Shift And Break Table

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

What's The Purpose Of Varchar(0)

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)

How To Run A Query To Find A String In Blob Files?

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?

Message -"could Not Read A Hi Value - You Need To Populate The Table: Hibernate_sequence"

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"