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

Multiple Requests To Php Blocked By First Connection

OK this will probably be a lot of explanation for a small question, so here goes. I have a quiz sys… Read more Multiple Requests To Php Blocked By First Connection

Extended Events Blocked Process Report Missing From Sys.dm_xe_objects

Trying to create SERVER EVENT SESSION to capture blocked_process_report & xml_deadlock_report e… Read more Extended Events Blocked Process Report Missing From Sys.dm_xe_objects

Loop Through All Tables And Delete Records

I'm new to MsSql and I'm not sure if this can be done but I figured I'd ask before I wa… Read more Loop Through All Tables And Delete Records

No Functions, No Split_string. Use Xml To Split String Into Different Fields By Delimiter

I have a string like this that doesn't have a consistent format and needs to be broken into fie… Read more No Functions, No Split_string. Use Xml To Split String Into Different Fields By Delimiter

Sql Server Stored Procedure Case Sensitive?

I have a case sensitive SERVER (SQL_Latin1_General_CP1_CS_AS) but the Database is Case insensitive … Read more Sql Server Stored Procedure Case Sensitive?

Sql Query Error

What is wrong with this Query? INSERT INTO Registration (`Status`, `String`) VALUES ('Co… Read more Sql Query Error

Not Distinct Query In Mysql

I have been asked to create a query for this on a simple employee database columns include: ninumbe… Read more Not Distinct Query In Mysql

Multi Column Pivot Sql Server

I have a problem that has deals with multi column pivoting in SQL Server 2008. I would like to expl… Read more Multi Column Pivot Sql Server

Oracle Show All Employees With Greater Than Average Salary Of Their Department

I am writing a query to find employees who earn greater than the average salary within their depart… Read more Oracle Show All Employees With Greater Than Average Salary Of Their Department

Sqlite Trigger Causes "no Such Column" Exception

I'm a newbie with sql triggers and am getting an ESQLiteException on what seems like a simple e… Read more Sqlite Trigger Causes "no Such Column" Exception

Assigning Value From Single Row Result Set In Ssis Giving Error In Ssis 2012

I am trying to get CSV IDs from a table from sql server and assign the result to a variable. below … Read more Assigning Value From Single Row Result Set In Ssis Giving Error In Ssis 2012

Return Value From Stored Procedure To C#

I got same problem in one more stored procedure. I want to add leave request to a SQL Server 2008 … Read more Return Value From Stored Procedure To C#

Sql Field As Sum Of Other Fields

This is not query related, what I would like to know is if it's possible to have a field in a c… Read more Sql Field As Sum Of Other Fields

Return Data From Subselect Used In Insert In A Common Table Expression

I am trying to move bytea data from one table to another, updating references in one query. Therefo… Read more Return Data From Subselect Used In Insert In A Common Table Expression

To Understand A Sentence About The Case In Sql/ddl -queries

This question is based on this answer. What does the following sentence mean? Finally, don't u… Read more To Understand A Sentence About The Case In Sql/ddl -queries

How Do You Send In Multiple Commands To Sql Powershell From The Windows Command Line?

Not sure if this belongs on serverfault or not... I am following the instructions on this site for … Read more How Do You Send In Multiple Commands To Sql Powershell From The Windows Command Line?

Sql Server- Pivot Table To One Column Per Date

I'm currently moving an MS Access db to SQL Server. I have a cross-tab query I'm needing to… Read more Sql Server- Pivot Table To One Column Per Date

Select Records From Vertical Row And Transform Horizontal Row

I am working on a SQL Server query to fetch the last Badge_In_Out_Time of the list of users who wil… Read more Select Records From Vertical Row And Transform Horizontal Row

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

Read Utf8(xml) Data From Sql Server 2005 The Most Efficient Way

I want to read lots of data(single column nvarchar(max)) from SQL Server 2005 and deserialize it to… Read more Read Utf8(xml) Data From Sql Server 2005 The Most Efficient Way

Retrieve Number Of Columns In Sql Table - C#

I'm very new to C#. I'm trying to retrieve the number of columns using: SELECT count(*) FRO… Read more Retrieve Number Of Columns In Sql Table - C#

I Want Generate Xml File In A Hierarchical Form

I have a table like this (Actually it contains more 6000 records) IdIndustry | IndustryCode | … Read more I Want Generate Xml File In A Hierarchical Form

Ssrs Report Query Not Working, But Does When Hardcoded Parameters

I have an SSRS report that has 3 parameters: @start (datetime) @end (datetime) @plantid (string fro… Read more Ssrs Report Query Not Working, But Does When Hardcoded Parameters

Design Users Table For Single Sign In To Use Across Sub Domains

We have a site which has sub domains like: example.com - Main Site food.example.com fashion.exa… Read more Design Users Table For Single Sign In To Use Across Sub Domains

Desktop Application And Db Connection

Lets say I have desktop application with simple login - here, in this part i have to create Connect… Read more Desktop Application And Db Connection

Adb Shell "bus Error" While Running Sqlite3 File.db

I am unable to use 'sqlite3' in my Asus Zenfone 5. Its rooted device and has sqlite3 in /sy… Read more Adb Shell "bus Error" While Running Sqlite3 File.db

Ssis Problems With Mysql Connector/odbc 5.3.8

I am having a problem with a SSIS project that downloads data from a MySQL database and insert it i… Read more Ssis Problems With Mysql Connector/odbc 5.3.8

Sql 2012 - Pivot And Unpivot

I have summarised data in a table which is similar to this: Customer Year Month No_trans spend poi… Read more Sql 2012 - Pivot And Unpivot

Ssis Package Hangs While Running

As the title might suggest, i am having problems with a SSIS package during data import. I will try… Read more Ssis Package Hangs While Running

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

Sql - Replace Repeated Rows With Null Values While Preserving Number Of Rows

I am trying to get only one instance of a year instead of 12 because I am using this column in a lo… Read more Sql - Replace Repeated Rows With Null Values While Preserving Number Of Rows

C# Task Run Only If Time Is Right - At A Certain Time

Okay, so i need to build a c# task that will only run at a certian time, the time will come from a … Read more C# Task Run Only If Time Is Right - At A Certain Time

Linq To Sql / Filter Duplicates

i have a view in my sql server 2012 with a couple of duplicates and i want to sort them by the newe… Read more Linq To Sql / Filter Duplicates

Mssql Query No Longer Works With Windows 10 Client: The Conversion Of A Varchar Data Type To A Datetime Data Type Resulted In An Out-of-range Value

We have been using the following SQL query for a long time in a WinForms program with no problems, … Read more Mssql Query No Longer Works With Windows 10 Client: The Conversion Of A Varchar Data Type To A Datetime Data Type Resulted In An Out-of-range Value

When Utilizing A Microservices Architecture, Will The Underlying Read/write Database Become A Bottleneck?

As I described in the question, if I were to implement a microservices architecture, would the cent… Read more When Utilizing A Microservices Architecture, Will The Underlying Read/write Database Become A Bottleneck?

Can Sql/access Display Foreign Key Rows As Columns?

I have an MS Access table that has a many-to-one key to another one, and I would like a query to di… Read more Can Sql/access Display Foreign Key Rows As Columns?

Change Empty String To Null When Column Has Date Constraint

This might be impossible but I was wondering if someone more experienced knew if this is possible t… Read more Change Empty String To Null When Column Has Date Constraint

Recuperating Roles Of Users From Database (foreign Key)

Can anyone tell me how i can recuperate roles of users from my database? Knowing i have 3 tables (U… Read more Recuperating Roles Of Users From Database (foreign Key)

Querying Data Using Entity Framework From Dynamically Created Table

TLDR; How do I read data from a table using Entity Framework, when the table name isn't known a… Read more Querying Data Using Entity Framework From Dynamically Created Table

Prorate A Monthly Charge To Daily For A Partial Month

I'm using SQL Server and SSRS. I have a table with a monthly charge for a service. I need to be… Read more Prorate A Monthly Charge To Daily For A Partial Month

How To Add Next And Subtract Preceding Row In Sql Server Based On Condition

I am trying to calculate the cumulative sum based on TranslationType column in SQL Server. Sample d… Read more How To Add Next And Subtract Preceding Row In Sql Server Based On Condition

Get Total Count Of Rows In Oracle And Then Get Only 4 Results

I am building a search engine, therefore, as in google, I am displaying only 4 results but I also n… Read more Get Total Count Of Rows In Oracle And Then Get Only 4 Results

Different Ways To Generate The Latest Int Type Primary Foreign Key In Code

I am new to sql. I have added 2 new tables in database. The primary key of first is a foreign key i… Read more Different Ways To Generate The Latest Int Type Primary Foreign Key In Code

Sql: Set Existing Column As Primary Key In Mysql

I have a database with 3 columns: id, name, somethingelse This table has no index set and i am … Read more Sql: Set Existing Column As Primary Key In Mysql

Sql Injection Prevention With Microsoft Access And Vb.net

I'm a beginner in ASP.NET so I have some questions about how to prevent SQL injection in ASP.NE… Read more Sql Injection Prevention With Microsoft Access And Vb.net

Sql Ordering By Rating/votes

I have the following SQL statement; SELECT * FROM items WHERE votes > 4 ORDER BY (rating/votes) … Read more Sql Ordering By Rating/votes

Varchar Values To Date Format

In SQL Server 2014, I have a varchar column with multiple date formats: shipdate ----------- 12/29/… Read more Varchar Values To Date Format

Sql Server How To Decollapse Data

I want to decollapse data with in same group. let me explain by example. Demo data: +-------------… Read more Sql Server How To Decollapse Data

Select Records From A Table, Which Don't Exist In Another Table

I have 2 tables TABLE1 and TABLE2 in sqlite DB. TABLE 2 has some of the records of the TABLE1. What… Read more Select Records From A Table, Which Don't Exist In Another Table

Sqlite Full-text Search Unicode In Android

I am creating a table in SQLite using fts(3 or 4) CREATE VIRTUAL TABLE Demo1 USING fts3(content TEX… Read more Sqlite Full-text Search Unicode In Android

Emulating Multiple Requests To Sqlite Database As Goroutine Causes Random Panic

I am trying to emulate multiple requests from http.HandleFunc to function which makes changes to sq… Read more Emulating Multiple Requests To Sqlite Database As Goroutine Causes Random Panic

Stored Procedure Passing Date Parameter Getting Error

alter procedure [dbo].[ParkingDeatailsReport] @locid INTEGER, @startdate nvarchar(100),@enddate … Read more Stored Procedure Passing Date Parameter Getting Error