summer2012training

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

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

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

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

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?

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

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

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

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

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

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

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#

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

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

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

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?

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

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

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

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

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 have a table like this (Actually it contains more 6000 records) IdIndustry | IndustryCode | … Read more I Want Generate Xml File In A Hierarchical Form

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

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

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

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

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

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

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

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

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

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

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

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

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?

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?

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

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)

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

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

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

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

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

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

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

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

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

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

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

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

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

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