Lab Sql

I am having some serious problems wrapping my head around how to build a proper query for my situat… Read more SQL Query - Table Joining Problems

I have created a CommandButton within Excel and started coding VBA. The idea is to pass parameters … Read more VB - Run-time Error '1004' - Application-defined Or Object-defined Error

Is there a way to use the instruction: MERGE INTO MySchema.MyTable AS Target USING (VALUES ........… Read more Merge Into With No Rows

I need to select pairs of rows from a table that meet certain criteria. Here's an SQL fiddle th… Read more Optimize MySQL Self Join Query

Following are some entries from a table: id r_id a_id p_id 1 9 … Read more SQL Query: Fetch Ordered Rows From A Table - II

I am developing a Windows Mobile 6.5 application with C# using Visual Studio 2008, it's connect… Read more Insert, Update, Delete Are Not Applied On SQL Server CE Database File For Windows Mobile

I've seen solutions for problems similar to mine, but none quite work for me. Also I'm conf… Read more HIVE - Compute Statistics Over Partitions With Window Based On Date

so i having this kind of query where i do grouping with max date/period like this $table_data = App… Read more Laravel Join With Only Limiting 2 Row

I am looking for something to extract all the SQL queries present in my SSIS/DTSX package. But noth… Read more Extracting SQL Statements From A SSIS/DTSX Package

I wanted to use a case statement (not recognised by MS Access) but this is what I have instead: Sum… Read more Summing Only If A Certain Customer In MS Access 2003

salesman ======== uId salesGroupLinked ================ uId groupId //add performacesScore field h… Read more Many To Many Relationship Bridge Table Dilemma

Searched and searched and gave up. All I want is more info on a MySQL table or better yet, a list o… Read more How To Display All The Tables With More Information (create Date, Size,...) In A MySQL Database?

I am using jtds driver to connect to SQLServer from a UnixBox using windows authentication from a S… Read more Exception While Using Jtds For SqlServer Connectivity

This code works fine when you remove the wrapper, from the XML and the nodes, but when you add it,… Read more Cannot Read Contents When XML Has 2 Wrappers

I currently have a DataGridView bound to an sqlite database in 'c:\temp'. I bind it using t… Read more C#: Bind DataGridView To A Database File In The Application Directory

Consider the following database table: ID ticker description 1 GDBR30 30YR 2 GDBR10 1… Read more Maintain Order When Using Sqlalchemy WHERE-clause And IN Operator

can anybody help me by providing a link on how to convert a user instance database to normal sql se… Read more How To Convert User Instance Database To Normal Sql Server Database

I have a table of questions: title Each question has answers, in another table: text, question_id … Read more Order Table By Grouping Values In Another Table

I've inherited a database of user profile information which has a column for personal interests… Read more Parsing A SQL Field In A Query

I want to execute this statement CREATE TABLE Tab2 AS SELECT 1, 'abc', 123456789.12 UNION S… Read more CREATE TABLE ... AS SELECT With Discrete Values With Explicit Column Names