summer2012training

Using join of parent and child tables I am getting results like this select a.id, a.pname,… Read more How To Display Row Value As Column Value In Sql Server (only One Column Rows Value Should Be Displayed As Multiple Columns)

I am trying to identify a value that is nested in a string using Snowflakes regexp_substr() The val… Read more Snowflake Sql Regex ~ Extracting Multiple Vals

I'm fairly new to c# and just now started working with databases. I made a local database in my… Read more C# Database Connection String

When I run this CTE in SQL Server it says the syntax is incorrect by the declare statement. ;WITH c… Read more Understanding Cte Semicolon Placement

I am using code from sqlite database iOS app tutorial, but it is giving sql error when inserting a … Read more No Such Table .. Could Not Execute The Query... Xcode Sqlite

I modified the table from the development database and want to update the same table on production … Read more Sql Server 2008 : Update The Table With Primary Key

Building in the test for consecutive ids is proving difficult without breaking it down into parts o… Read more How To Tag A Group Of Repeating Items If The Ids Are Consecutive For N Rows?

I'm struggling with some the sql querys when calling from different tables. Im trying to get so… Read more Fetch Values From Different Tables With Same Id

How do I get the 'minutes' difference between 2 times in T SQL? I tried DATEDIFF, but it o… Read more How Do I Get The Minute Difference Between 2 Times In T Sql?

Suppose I have two tables: TABLE1: Has a list of IDs I need to process. TABLE2: Has key-value pair… Read more Why Subquery Inside Recursive String Concatenation Always Returns Null?

i want to change my datetime format on my MS SQL from the default format of 12-12-2000 13:01:01:011… Read more Sql Datetime Format Convert

I have full dump of sql file like dump_full.sql of size 1.3GB And it has some tables like dancing_c… Read more Restore Single Table Dump From A Sql File

Sorry for the long title :) I couldn't really find any answers this and this question has been … Read more Is Looping Through Iqueryable The Same As Looping Through A Datareader With Reader.read() In C#

I want to display in datagridview a specified column value. Example: from table user_account I want… Read more Sql Server: Datagridview Display Column Value From Table

I'm trying to make a connection to sql server database(hosted on localhost) but keep getting th… Read more Cannot Open Database "dbname" Requested By The Login. The Login Failed

I know we can generate row_number in select statement. But row_number starts from 1, I need to gene… Read more How To Generate Serial Numbers +add 1 In Select Statement

I would like to check if there is a preferred design pattern for implementing search functionality … Read more Implementing Search Functionality With Multiple Optional Parameters Against Database Table

I am creating external table using hr schema but i get errors 'ORA-29913: error in executing … Read more Ora-29913: Error In Executing Odciexttableopen Callout

Merge will always give you the number of records merged regardless of how my records inserted or up… Read more Plsql: Get Number Of Records Updated Vs Inserted When A Merge Statement Is Used

I want to combine/union two tables and have it create a field that identifies which table it came f… Read more I Want To Combine/union Two Tables And Have It Create A Field That Identifies Which Table It Came From

I received the following error when I tried to run a C# WinForms application on a Windows Server 20… Read more Hresult: 0x8004d00e Using Transactionscope - C#

I want to run a query to bring back that occurred on or after a date where the input date is a time… Read more How Do I Compare Two Timestamps As Dates In Sql Server

I'm trying to query a table in Microsoft Excel using VBA. I've written up some code to try … Read more Querying A Sql Server In Excel With A Parameterized Query Using Vba

(Not a question) I've experienced some crashes with sqlalchy_utils after updating from sqlalche… Read more Sqlalchemy Making Errors After Being Updated To 1.4.0

I can't see why the SELECT below finds 7065 records, but the update says it updates 13935 recor… Read more Postgres Sql Select And Update Behaving Differently

I want to add some calculation inside my case statement to dynamically create the contents of a new… Read more How To Do A Sum() Inside A Case Statement In Sql Server

I want to be able to run a query like: select A.* from A join B on match(A.geom,B.wkt) usin… Read more Is It Possible To Issue A Spatial Join With Shapes From Two Tables?

I have a PHP search script that queries a MySQL database and then parses the results through HTML t… Read more Highlighting Keywords In Php Search Script

I have developed a WPF app which is using .Net (Framework 4.5) and SQL server 2012. It works perfe… Read more Error While Setting Sql Express 2012 As Prerequisite

I'm working with a program where I have to check hundreds of variables to see if they are alrea… Read more More Time Consuming/cpu Extensive Insert Ignore Or Select Count(*)

This query is driving me insane and I honestly just don't know how to accomplish it. I need to … Read more Sql: Complicated Select Statement And Returned Radius

I've got a database of movies, and I'd like a list of years where I don't have a movie … Read more How Do I Get A List Of Numbers In Mysql?

I am getting this error when I try to register a user etc: Invalid object name 'dbo.AspNetUser… Read more Local Works. Azure Give Error: Invalid Object Name 'dbo.aspnetusers'. Why?

Consider the following question: We have 3 tables, 1. Theatre ( theatre_Id, thatre_name ) 2. Show… Read more How To Solve The Following Case?

I hope someone can help me out with this. I can't reproduce this error but am receiving a huge… Read more Unable To Close Due To Unfinalised Statements Android

So I'm not sure what it's called, but I need to figure out how best to do an update that ma… Read more Oracle Sql "deep Update"

I'm unable to get web2py to connect to mssql. (Failure to connect, tried 5 times: 'NoneTyp… Read more Web2py Won't Connect To Mssql

I'm going through W3school's SQL tutorial, and they have an example here with the ALL opera… Read more Why Doesn't My All Operator Work In This Sql Statement?

I have a SQL Server hosted on my local machine that I am trying to connect from my VM. The VM can a… Read more Unable To Connect To Sql Server From Virtualbox

So I have a table kind of like the one below. +----+----------+---------+ | ID | group_id | user_id… Read more Php Sql Select Where In Array Of Ids And Has Same Variable Column Value

I downloaded sqljdbc4.jar. I'm invoking sqoop like so from the folder (where the jar is stored… Read more Sqoop Sqlserver Failed To Load Driver " Appropriate Connection Manager Is Not Being Set"

Say I have a dataset in SSRS called DataSet1 that looks like this: CREATE TABLE #data (ID int, Val… Read more Ssrs Multiple Value Parameter Filter Based On Dataset

I was stuck with the following situation: My entities are related to each other, but in such a way … Read more Jpa Data Repositories With Sqlresultsetmapping And Native Queries

I have a localdb in a WPF application and a table for storing a student's credentials, I want t… Read more Linq To Sql Authenticate Login Credentials

I need help with the following query...Show the names of vendors who have sold us an item more than… Read more Sql Query For Vendors Who Have Sold Item More Than Once

I'm using Oracle 11g and have a complex join query. In this query I really wanted to apply OFFS… Read more Apply Offset And Limit In Oracle For Complex Join Queries?

CREATE TABLE Product ( 'Product_id' int, 'Stock_quantity' int, 'Pr… Read more Is It Possible To Reference A Foreign Key To Parent Table?

I am trying to query from a table in SQL server. I do not have the rights to update tables or creat… Read more Strip Leading Zero From Number Stored As Varchar

I am building an online booking system so that people can book doctor appointments online. I have r… Read more Mvc 4 Controler - Using Dynamic Staffid's & Businessid's Instead Of Hard Coded Ones

Maybe answer is very easy, but I can't find the right MySQL query which do what I want. I have … Read more Select Row Which Contains Exact Number In Column With Set Of Numbers Separated By Comma

I can code like this in Oracle to create tables dynamically using 'execute immediate 'sql q… Read more Does Bigquery Support "execute Immediate" Command To Run Dynamic Query?

I have three tables that i would like to join up together. Domain table -domainid - Primary key Do… Read more Join Three Tables With One Of Them Not Having A Primary Key

I need to create a query builder for SQL, where you can choose query constraints via HTML checkboxe… Read more How To Build An Sql Query From Html Checkboxes?

SET NOCOUNT ON stops the message that shows the count of the number of rows affected by a Transact-… Read more Set Nocount On And Reading Messages Using C# And Ado.net

I got the problem is when I run following command in Oracle, I encounter the error. Truncate table … Read more Truncate Table In Oracle Getting Errors

PREF_NAME, PREF_STATUS - text It gives me this error: 07-02 14:08:07.457: E/AndroidRuntime(17295): … Read more Raw Query With Multiple Parameters

I have a .Net system that I am writing which needs to be able to retrieve an oracle geometry field … Read more Oracle Sdo_geometry Tostring()?

If I need to query certain data from the database depending on some variables is there a better way… Read more Is There A Better Way Of Managing Variables In Query Than This?

I'm trying to quickly determine if two sets of schedules are identical and also generate a key … Read more Why Do These Datetime Values Return The Same Checksum & Checksum_agg? How Can I Make It More Unique?