stiellledm310

I need to extract SQL files from multiple tables of a PostgreSQL database. This is what I've co… Read more Postgresql - Dump Each Table Into A Different File

So i want to calculate the total sale amount, excluding tax, for my website. However, i have a enor… Read more How To Get Woocommerce Orders Total Sales Without Taxes?

I am creating a web chat application using ASP.NET. I have got the chat system to work as messages … Read more How Do I Handle The Timezones For Every Chat Message

I've created an INSTEAD OF INSERT trigger on a child table that will automatically create a rec… Read more Future-proofing An Instead Of Insert Trigger

Imagine you got an entity in the Google App Engine datastore, storing links for anonymous users. Y… Read more Python: Distinct On Gquery Result Set (gql, Gae)

I got error 'Column not found' any time i run the following code even though the column exi… Read more Jdbc Selecting The Max Value From An Access Table

I'm pretty new to SQL and would like some help with the following question: What query would I … Read more Simple Sql Server Query Clarification On Finding A Record Using Two Conditions

I have searched desperately for the answer to a seemingly easy query to pull off- but no luck in fi… Read more Find Largest Value Among Repeated Entries In An Sql Table

I'm working on a query that would show data added in last week (always beginning with Monday), … Read more Oracle Sql Query - Get Data From Last Week (monday-saturday)

I have a table 'tbTest' like this: id | q1 | q2 | q3 | type ---+----+----+----+--------- 1… Read more Find Out Average By Group Wise And After That Convert Column To Row

I have a SQL TABLE like CREATE TABLE Test ( ContentArray INTEGER ARRAY )`. I can insert an column … Read more Sql Test If Array Contains Integer

I have two tables, and want to extract certain columns from the first, based on 'child' dat… Read more Sql Subselect Filtering Based On Multiple Sub-rows

I have a database with a user table that has the fields: id name email password status My user… Read more Integrating Wordpress Authentication With An Existing User Database

I have edited my question and replace the previous explanation with new one. I think I could't … Read more Can We Get Value Of Above Cell Of Same Column Of Table In Ssrs Report Builder? How?

I am looking to run a query in t-SQL (MS SQL SMS) that will stop after X number of seconds. Say 30 … Read more T-sql: Stop Query After Certain Time

I have these three statements: select count (distinct vid) as SUM_OF_SEC from pdalis where pid in(5… Read more How Do I Combine Multiple Select Statements In Separate Columns?

We have some to critical jobs in our production system. We receiving email about of job status succ… Read more Text Message Via Sql Server

This is a continuation of this question. As my flask app should not write anything in my database,… Read more Import Reflected Flask-sqlalchemy Module Before Creating The App

I have a small stored procedure below. I am taking the table name as an input parameter to the sto… Read more How To Take Table Name As An Input Parameter To The Stored Procedure?

I have two tables in my database Table A with columns user_id, free_data, used_data Table B with c… Read more Tree Like Data Collation In Sql (mysql)

My front end application has a textarea where the user can enter the stored procedure. I want to va… Read more Sql Stored Procedure Validation In .net Front End (similar To Parse Option In Ssms)

My question is about using fulltext.As I know like queries which begin with % never use index : SEL… Read more Full Text Search Vs Like

I receive an SQLite exception when creating a connection. This worked before I installed VS2015 RTM… Read more Sqlite Exception When Creating A Connection

Is there a way to use the SQL ORDER BY function and then find where a user is on the sorted list as… Read more Find A Users Position On A Ordered Sql Table

I am trying to deploy my app to Heroku, but it keeps getting rejected with the following output. wa… Read more Heroku Installing Sqlite3 Even Though It Is Not A Dependecy

I am trying to write to a database from c#: using (SqlConnection connection = new SqlConnection()) … Read more Writing To Sql Server From C#, No Errors Returned

I have an asp.net program, that adds tasks to my staging table and executes a stored procedure that… Read more Delete Records From Staging Table After They Have Been Added To The Real Table

I can't get my Asp.Net application to work on a server I'm deploying to. The server is runn… Read more Sql Server Asp.net - "login Failed"

I'm making an application (web based) using flex and i have a requirment to access the SQLite d… Read more Can A Flex Web App Access A Sqlite Database?

I don't see what is wrong with my ArrayList that i get this error: Error:(133, 17) error: inco… Read more Incompatible Types: Arraylist Cannot Be Converted To String

when I want to see one table with its records in oracle, the table is disorganized,I mean is not li… Read more Format Query Results In Sql*plus

Suppose I have three tables in PostgreSQL: table1 - id1, a_id, updated_by_id table2 - id2, a_id, up… Read more Count Rows After Joining Three Tables In Postgresql

I have problem: I have 1 sql server already setup SQL Server 2014 Express in Windows and 1 Oracle D… Read more Unable To Enlist In The Transaction

I am getting the following error message... 'The SQL statement could not be executed because it… Read more Ambiguous Outer Joins?

My site was developed using Drupal 6 running on a Postgresql 8.3 server on Ubuntu 11.10. Also webmi… Read more Cannot Update View In Postgresql?

I have the ff table: --------------------------- ID | ChapterNo | HitCount | --------------------… Read more Complex Sort And Grouping With Mysql

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

If I have a table, let's say Customers and I want to receive from the user a number (Form) and … Read more How Can I Add "x" Rows To A Table In Sql?

I will simplify my problem to make the core issue clear: I have a query that does TableA INNER JOIN… Read more Optimal Way To Fill In Missing Values After A Left Join?

UPDATE(simplified problem, removed C# from the issue) How can I write an UPSERT that can recognize… Read more Sql/c# - Primary Key Error On Upsert

I'm using jOOQ v2.6 as I'm using SQL Server 2008 R2 and there is a bug in jOOQ v3.1 which c… Read more Overriding Jooq's Exception Handling For Updatablerecords

I'm trying to create the search form with keyword highlighting, but obviously I won't be ab… Read more Mysql Select Content Around Keyword

I'm trying to restore a db from Microsoft (AdventureWorks2012). However, when I try to restore … Read more Sql Server Management Studio Can't Recognize .bak File

I have a large set of tweets on bigquery and now want to filter those that contain at least one of … Read more Select Rows Where Array Contains One Of Several Values In Bigquery (ideally With Dbplyr)

I am working on a project to allow searching on Hadoop. How it works is the query is first passed t… Read more How To Pass Elasticsearch Query To Hadoop

I know this is a replica of some question asked already, but i need some suggestion. I know basics … Read more How To Hide An Alias Column In Mysql Edited