Skip to content Skip to sidebar Skip to footer
Showing posts from July, 2023

Replacing Alphabets To Zero In Any Given String In Sql

I'm trying to replace some input strings in a formula to zero value. I was able to do it for ce… Read more Replacing Alphabets To Zero In Any Given String In Sql

Update Problems With Creating Simple Php,mysql Voting System

ok so what i have done is made a script to show database and i inclided a voting system that SHOULD… Read more Update Problems With Creating Simple Php,mysql Voting System

Another Pivot With Dynamic Fields

I have a view defined as follows: Select IdSezioneDonatore, NumeroDonatore, Anno, DonaAnno From dbo… Read more Another Pivot With Dynamic Fields

Oracle Truncating Column

I have the following query. insert into ORDER_INFO(ORDINF_PK,ORDINF_LGNDET_PK_FK,MEDIA_TYPE,ORDINF_… Read more Oracle Truncating Column

Oracle - Modify An Existing Table To Auto-increment A Column

I have a table with the following column: NOTEID NUMBER NOT NULL, For all intents and purpose… Read more Oracle - Modify An Existing Table To Auto-increment A Column

Trying To Download Json From Mysql

hey there guys and girls, iv been trying to fix this problem for weeks now and carnt seem to get an… Read more Trying To Download Json From Mysql

Abstract Database Access

Let's say I have 2 models in my application and I want a table for each of them but my CRUD ope… Read more Abstract Database Access

Access And/or Exclusions

I have some sample data like: |H.RISK|NOTE|NORMAL| The | are actually in the data, it's a Stri… Read more Access And/or Exclusions

How To Use Explain Plan To Optimize Queries?

I have been tasked to optimize some sql queries at work. Everything I have found points to using Ex… Read more How To Use Explain Plan To Optimize Queries?

Mysql Select Yesterday's Date

If I have a date like this: '2013-03-25' And I want to write a MySQL query with WHERE is &… Read more Mysql Select Yesterday's Date

How To Query Sum Previous Row Of The Same Column With With Pgsql

I need to put in column RESULT the sum of same row's column SOMETHING and previous row column S… Read more How To Query Sum Previous Row Of The Same Column With With Pgsql

How To Merge Rows Of Sql Data On Column-based Logic?

I'm writing a margin report on our General Ledger and I've got the basics working, but I ne… Read more How To Merge Rows Of Sql Data On Column-based Logic?

How To Automate The Execution Of A Stored Procedure With An Ssis Package?

I have a stored procedure that gets executed through SQL SSIS using a Execute SQL Task. The task ha… Read more How To Automate The Execution Of A Stored Procedure With An Ssis Package?

How Can I See Which Sqlite3 Binary Does The Sqlite3 Python Module Use On Ubuntu 16.04?

How can I see which sqlite3 binary (containing the SQLite relational database management system) do… Read more How Can I See Which Sqlite3 Binary Does The Sqlite3 Python Module Use On Ubuntu 16.04?

Sql Server Datetime To Bigint (epoch) Overflow

I have a 'datetime' column with value 2013-03-22 15:19:02.000 I need to convert this value… Read more Sql Server Datetime To Bigint (epoch) Overflow

Creating A Calculated Column Based On The Flag - Tsql

I want to calculate the sum of the orders based on the flag. Sample table: +--------------+--------… Read more Creating A Calculated Column Based On The Flag - Tsql

Detecting If Sql Server Is Running

I'm looking for a way to poll different servers and check that SQL server is up and running. I&… Read more Detecting If Sql Server Is Running

Encrypting Data In Sql Server Azure Database With Separate Key For Each User's Data

I'm trying to create a service based on an Azure SQL Database backend. The service will be mult… Read more Encrypting Data In Sql Server Azure Database With Separate Key For Each User's Data

Append Fmdb Sqlite Results To Swift Array

I'm trying to append results from a FMDB SQLite query to a Swift array. The error I'm gett… Read more Append Fmdb Sqlite Results To Swift Array

"system.argumentexception: 'no Mapping Exists From Object Type Newtonsoft.json.linq.jvalue To A Known Managed Provider Native Type.'

I'm trying to insert data from a JSON Array response that I've gotten as a response. Howeve… Read more "system.argumentexception: 'no Mapping Exists From Object Type Newtonsoft.json.linq.jvalue To A Known Managed Provider Native Type.'

Insert Control Characters In Nvarchar Or Varchar From Sql Script?

Given SQL Server 2012, how can I insert control characters (the ones coded under ASCII 32, like TAB… Read more Insert Control Characters In Nvarchar Or Varchar From Sql Script?

Sql Server Sysadmin User Server Role

Is it possible to read/write into a SQL Server 2005 database, from a VB.NET application, using a us… Read more Sql Server Sysadmin User Server Role

Convert 24 Hour Time To 12 Hour Plus Am/pm Indication Oracle Sql

I am required to do the following as an exercise, and I am struggling to find a solution: Write a S… Read more Convert 24 Hour Time To 12 Hour Plus Am/pm Indication Oracle Sql

Block Select Until Results Available

I'm trying to write a PHP script for 'long-polling', returning data when new rows are a… Read more Block Select Until Results Available

Run Stored Procedure From Access Vba

I keep getting an error of Conversion failed when converting date and/or time from character stri… Read more Run Stored Procedure From Access Vba

How To Change Date Format Of Datetime Data Type In Sql?

My date format of '03-01-2017 10:24:48' is getting stored in SQL as '2017-03-01 10:24:4… Read more How To Change Date Format Of Datetime Data Type In Sql?

How Can I Get The Null Valued Records From A Table?

In my table 1,00,000 records are there, where 1000 rows and 100 columns are there, some of the reco… Read more How Can I Get The Null Valued Records From A Table?

Limit Same Data Entries

Im new to sql and i have two tables, one for fridges and one for food. Only 5 items of food can be … Read more Limit Same Data Entries

Where If Condition Is Not Met Get All Values Including Null

Either get only those userIDs with the specified @Lastname or if @LastName = 'All' then get… Read more Where If Condition Is Not Met Get All Values Including Null

Creating An Sql Table With Email Address As Title

I'm struggling to create SQL tables using email addresses as the table name. The code I am usin… Read more Creating An Sql Table With Email Address As Title

Expensive Query Takes Down Database Server -- Looking For Ways To Mitigate

I have a very expensive query that creates a temporary table for reporting purposes. I am having a … Read more Expensive Query Takes Down Database Server -- Looking For Ways To Mitigate

Performance In Sql Mobile With One Big Column That's Not Being Selected

I have a SQL Mobile database with one table. It has several columns with useful, often queried data… Read more Performance In Sql Mobile With One Big Column That's Not Being Selected

Using Cursor In Oltp Databases (sql Server)

Is it safe to use cursors in stored procs that are called from a website? There is the obvious perf… Read more Using Cursor In Oltp Databases (sql Server)

How To Write An Sql Statement Output To A Csv File?

We have a script task that processes a flatflat, inserts data into the database, then records any d… Read more How To Write An Sql Statement Output To A Csv File?

Combine 2 Select Left Join Queries, Union/declaring As Not Working

I have this select statement, it runs a single column with heading 'product_id' and a value… Read more Combine 2 Select Left Join Queries, Union/declaring As Not Working

Calculate Group Result And Merge It With Details

Please consider this result (Report): State Value1 Value2 Value3 ---------------… Read more Calculate Group Result And Merge It With Details

Your Query Does Not Include The Expression 'open Amount' As Part Of An Aggerate Function - Ms Access

SELECT [doc type], [Open Amount] , [customer number] , COUNT([customer number]) As CountC… Read more Your Query Does Not Include The Expression 'open Amount' As Part Of An Aggerate Function - Ms Access

Modify Xml Node Value- Updatexml Equivalent For Oracle 12c

I have some sample code as follows: WITH xtbl AS (SELECT 1 AS xtbl_id, xm… Read more Modify Xml Node Value- Updatexml Equivalent For Oracle 12c

Date Calculation With Parameter In Ssis Is Not Giving The Correct Result

I want to load data from the last n days from a data source. To do this, I have a project parameter… Read more Date Calculation With Parameter In Ssis Is Not Giving The Correct Result

Read Xml File In Sql Server

I am trying to read data from XML and display the results in tabular for in SQL Server. The XML dat… Read more Read Xml File In Sql Server

How To Insert Data Into A Sqlite Database In Iphone

I am new to iPhone development. I want to insert certain data into my database and retrieve it and … Read more How To Insert Data Into A Sqlite Database In Iphone

How Can My Application Benefit From Temporary Tables?

I've been reading a little about temporary tables in MySQL but I'm an admitted newbie when … Read more How Can My Application Benefit From Temporary Tables?

Sql-statement With Dynamic Table-names Or Redesign?

I have a MS SQL 2008 database which stores data for creating a weighted, undirected graph. The data… Read more Sql-statement With Dynamic Table-names Or Redesign?