Lab Sql

I'm trying the find a value at a certain date. My data looks like Date Value 2013-11-02 … Read more Sql Return A Value At A Specific Date In Time

re: SSIS Foreach Loop task with a Variable: I have this working for a List of primitive objects (e.… Read more Ssis Foreach With A List Of Simple Objects

I have a simple query that relies on two full-text indexed tables, but it runs extremely slow when … Read more How To Add More Or Searches With Contains Brings Query To Crawl?

can anyone tell me if it is possible to push data from a SqlServer trigger directly to ActiveMQ. I … Read more Can A Sqlserver Trigger Push To Activemq

I have the following query to obtain an average of a data of the 52 weeks of the year as follows: $… Read more Change Query Sql

Consider the following queries. select * from contact where firstname like '%some%' select… Read more Adding Inner Query Is Not Changing The Execution Plan

Is there a program that converts a SQL Server database diagram to er model, or create er model of a… Read more Sql Server To Er Model

So I developed a web application in ASP.NET and SQL Server 2008. Part of the SQL code I implemented… Read more How Do I Find A Asp.net Hosting Company That Supports Sql Server With Clr Enabled?

I'm able to query 'max degree of parallelism(maxdop)' value from sys.configurations but… Read more Modifying Max Degree Of Parallelism To 1 For Azure Sql Server

My Databases look like so: PEAK (NAME, ELEV, DIFF, MAP, REGION) CLIMBER (NAME, SEX) PARTICIPATED (… Read more Sql Query, Average Climbed And Pair That Has Climbed The Most Peaks

Is there an equivalent for Oracle's decode() in Access (or Jet, for that matter). The problem I… Read more Access/jet Equivalent Of Oracle's Decode

Firstly I have the following table: data dataset; input id $ value; datalines; A 1 … Read more Sas Proc Sql Inside %macro

This code uses pymysql, however when i try to insert the variable title into the sql query it comes… Read more How To Remove Extra Quotes In Pymysql

I have created the following query that will give me sales figures from all the stores in my databa… Read more Mysql - How To Filter And Show Max Value From A Group?

I am getting one error when I try to make my field IsPersisted=True This is the definition of my ta… Read more Computed Column 'month' In Table Cannot Be Persisted Because The Column Is Non-deterministic

I am developing a mobile application that use sqlite and transaction. Below code is that getting or… Read more Flutter Sqlite Transaction Usage Error Warning Database Has Been Locked For

Select count(Gender) as 'FOScout' from stormtroopers_officer join st_officer_assign on sto… Read more How To Include Multiple Select Statements In One Table

I have an annoying problem with SQL server 2016. It's not really bad, just annoying. So when I&… Read more Code Disappearing When Switching Query On Sql Server

I'm not a expert on SQL and I'm working on a huge SQL code and unfortunately it has a CURSO… Read more How To Convert Cursor Based Query In To Set Based

I am developing a procedure in pl/sql that get a data set from a cursor executed in a function. For… Read more How To Get Data From A Pl/sql Function If A Parameter Have More Than One Value In Function With Single Parameters

I have a select query in MySQL shown below: This query executes and produces results in the form of… Read more Use Select Or Pl Sql To Transpose

I´m using SQL Server 2008, how can I calculate the time between On and Off status? I have the follo… Read more Calculate Time Between On And Off Status Rows Sql Server

I´m creating an ETL on visual studio, but when I export my data to a table on Excel, the columns se… Read more Autofit Column Width Using Ssis Etl On Visual Studio

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 am getting JDBC error when I attempt a commit through hibernate to SQL Server Cannot insert expl… Read more Hiberate Problems, Jdbc Identity_insert Is Set To Off

I am working on an update for my new iphone app which will include the ability to back up & res… Read more Best Practices For Core Data Store (sqlite) Backup?

I'm looking to query an object's attribute dynamically. I will not know which attribute, or… Read more Sqlalchemy Dynamic Query Using Object Attribute

I am trying to solve this question which has to do with candidate keys in a relation. This is the q… Read more Finding Largest Number Of Candidate Keys That A Relation Has?

I have been researching and reading about SQL data types for a few days now (I know... I know, that… Read more Choosing Data Type For Mysql?

I want to setup table constraints for the following scenario and I’m not sure how to do it or if it… Read more Multiple Column Foreign Key Contraints

I have a multi-user application that keeps a centralized logfile for activity. Right now, that log… Read more Using A Sql Server For Application Logging. Pros/cons?

Say there are two tables: TABLE A messageID / Message / More.. 1 / This… Read more Sql: Get All Records From One Table And A Count Of Records From A Second Table?

I am looking for a query where $1100 gets distributed to each invoice below based on the item_order… Read more Payment Distrubution Oracle Sql Query

I'm trying to understand the table operator APPLY. Here is the example: CREATE TABLE #y ( Name … Read more When To Use The Table Operator Apply

I'm trying to create a new table from a subquery select but I get the following error: Incorre… Read more Create New Table With Subquery Select

For my Realty site I would also like to return the properties that fall within the user's reque… Read more Sql Query A Range Of Records That Fall Within A Min And Max Value

I want to store images of my employees with their profile details in SQL in a SQL Server database, … Read more Storing Images In Sql Server Using C#

I know it is not recommend to use Sqlite over a network drive, for two reasons: performance, and da… Read more How To Make Sqlite Robust Over A Windows Shared Drive

I have a query which goes like this. SELECT * FROM WHERE (Condition1) AND (Condition2 or Condition… Read more Ms Access Sql Not Working As Desired

I want to know how to get data from relationals tables. I want to get the images from the table nam… Read more How To Combine 2 Tables Using Entity Framework 6 And Linq In An Mvc Project?

I want to calculate Datetime at given timezone based on Datetime in UTC. I thought that I can do it… Read more Calculate Time At Specific Timezone, From Utc Time

We have a Single Statement FUNCTION in SQL Server 2005 which uses CONTAINSTABLE(). All works fine w… Read more Containstable And Contains, Which String To Pass To Match All Records?

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

Am having my table as below , by the usage of Sqlite : public class Medication { [PrimaryKey, A… Read more Select A Table Column From Ienumerable Using Linq

Basically I have a big list of addresses that can sometimes start with FLAT 'number', '… Read more How To Select The First Number In A String

I have a problem, my company has a customer satisfaction program which fetches a lot of data from d… Read more Duplication Employee In Table Due To Switch In Department

Is there any way to obtain an hexadecimal dump of a string in SQL Server? It'd be useful to tro… Read more Show Hexadecimal Dump Of String

I have the following code which takes a CSV and writes to a console: using (CsvReader csv = new Csv… Read more How To Take A Csv Field And Write To Columns In Sql

I have the following database table Here is my sample data I have for it. What I am trying to fig… Read more How To Group By In Sql By Largest Date (order By A Group By)

So my code seems to be running fine, no exceptions or errors being thrown, however when I check my … Read more Sql-server Query Not Executing Correctly In Umbraco C# Controller

What's the difference between: select t1.a1, t1.a2, t1.a3 from t1 cross join t2 where t1.a3 = t… Read more In Sql, What's The Difference Between Join And Cross Join?

I am working on a login/register app just for training as I am a beginner everything is working exc… Read more How To Find Out User Is Present In Sqlite Database Using Android?

Premise I recently ran into a bug in a select statement in my code. It was fairly trivial to fix a… Read more Sqlite Column Aliasing

I have data in the following format: Machine | week_end | widgets A | 05-26-2013 | 5 B … Read more Transpose Sql Result Set

I am confused about selecting two approaches. Scenario there are two tables Table 1 and Table 2 res… Read more Which Approach Is Better To Retrieve Data From A Database

I am having an arraylist of strings. I needt to store that arraylist in the 1 column of database. … Read more How To Store The Contents Of An Arraylist In One Column Of Table In Sqlite Database In Android?

I am trying to Django with MS SQL Server on CentOS 7 using Apache mod_wsgi. I'm able to run the… Read more Django Apache Mssql Connection Timeout