My Filter
   28 tags on

My Filter

  • All Sites
  • Arqade

1 answer

MySQL query for ranking by column

I am running a query in php which gives me a table in this format: +--------------------------------------------------------------------------+ | Name cc Platform ...

1 answers | 49 secs ago by user3766332 on Stack Overflow
4 answers

Large table with historical data allocates too much of SQL Server 2008 Std. memory - performance loss for other databases

Based on this question and the answers given: SQL 2008 Server - performance loss possibly connected with a very large table I have discovered memory allocation problem with SQL Server 2008. ...

1 answer

SQL statement DateTime format

I am looking for some help in regards to the format that I want my data outputted. Below is a snippet of the code I am using. It is currently converting the value from the database in seconds and ...

1 answers | 3 mins ago by James on Stack Overflow
0 answers

generate frequency distribution from database

In a MySQL database there's a table with a single numeric value column. I want to plot the distribution of these values as a bar chart/histogram with the following requirements: there should be a …

1 answer

Trigger problems in mysql

i have a table named reservation which consists of column reservationStatus and place and another table spot which consists of spot_id and spot_status. i have created a trigger in reservation table …

1 answers | 4 mins ago by dark knight on Stack Overflow
1 answer

Selecting specific value from column resulted from sql query

I have written a query which returns the result in single column and the result is like below. Attribute Names MERGE({116288}, {116226}, {116292}, {116249}, {116253}) MERGE({116287}, {116225}, ...

1 answers | 4 mins ago by sumit on Stack Overflow
1 answer

Where to save .sql files?

I am creating a .sql file with the following statements that I want to call upon in the mac terminal to create them. DROP TABLE IF EXISTS rw_promo_code; DROP TABLE IF EXISTS rw_app; DROP TABLE IF …

1 answers | 4 mins ago by godman on Stack Overflow
0 answers

generate histogram from database

In a MySQL database there's a table with a single numeric value column. I want to plot the distribution of these values as a bar chart/histogram with the following requirements: there should be a …

1 answer

using row_number to return specific rows of query

I am using SQL Server 2012 & MATLAB. I have a table of 5 columns (1 char, 1 datetime and 3 floats). I have a simple query shown below that returns the data from this table which contains over a …

1 answers | 5 mins ago by mHelpMe on Stack Overflow
0 answers

Generic Stored Procedure in Oracle mssql to oracle

CREATE PROCEDURE GetAllUsers AS SELECT * FROM RegisteredUsers; --Data Table 1; SELECT * FROM TemporaryUsers; --Data Table 2; GO CREATE PROCEDURE ExecuteProcs --Generic Stored Procedure To Call ...

1 answer

Query with multiple where statements doesn't work

I am trying to pull in information from a database into my program. I have the following database query which goes through and doesn't give me any errors but it doesn't bring in the correct ...

1 answers | 7 mins ago by user3457511 on Stack Overflow
0 answers

Export SQL results as a KML file using JSP

What I am trying to do is save the results of an SQL query directly to a KML file so that I can use it to plot markers on Google Maps. I can save it to a CSV file no problem but then I need to convert …

0 answers

mysql: query don't return null

my query looks like this: SELECT `Part`.`id` , `Machine`.`name` , `Machine`.`model` , `Part`.`name` , `Repair_Part`.`created` , `Service_Part`.`created` FROM `remontowka`.`parts` AS `Part` …

1 answer

How to specify schema in F# SQL query

I'm slowly learning F# and the first task I want to do is query a database, aggregate some data, and store it back in the database. I have a multi-tenant database so I would like to do this for each …

1 answers | 11 mins ago by Sparafusile on Stack Overflow
1 answer

cannot transfer value from a variable to another variable

I have a problem when I would like to transfer the value of a variable to another variable. declare @column varchar(255); set @column = 'cheesecake'; declare @tmp varchar(255); set @tmp = (select …

1 answers | 12 mins ago by Gergő Barta on Stack Overflow
0 answers

Merge two colums, multiple rows ignoring duplicates - MySQL

This is, maybe, a stupid question. Not for me: honestly, I'm not so skilled with MySql queries so I'm looking for a little help. I have a table: id | type_a | type_b | …

1 answer

SQL Group By Date But Maintain Records

I assume the php/cakephp/sql parliance. I have a History table which contains the column created of type DATETIME. I would show all the records of the History but arranged by day. ...

1 answers | 12 mins ago by giuseppe on Stack Overflow
2 answers

How to get an array of objects of a little more complex SQL with Zend2 and Doctrine2?

I am trying to map a working result from Zend2 / Doctrine2 to loop through the results in my index.phtml. My query looks like: SELECT,, m.track_id,, ...

1 answer

Custom Column header in MDX

I am trying to fill MDX query result to a datatable. Query is generating dynamically. When i fill datatable column header like [Dim Date].[Day].[Day]. I need it Log Date. Is there any way to change …

1 answers | 20 mins ago by Musthaan on Stack Overflow
1 answer

SSAS - MDX - Read multiple attributes from a dimension

For example, taking into account the Adventure Works database, I would like to display on rows the hierarchy of accounts and on columns i would like to show "Account Type" property. This MDX shows an …

1 answer

How to Update mysql timestamp column using java prepare statement?

I have created table as below: create table sample(id int not null,created_at timestamp,updated_at timestamp,name varchar(100),primary key(id)); have tried to update the column in different ways as …

1 answer

Executing SSIS packages from the SSIS catalog on SQL Server 2012

With the new SSIS catalog of SQL Server 2012, the previous way of executing SSIS packages from an SQL Server via C# locally (it basically downloads the package and executes it on the callers machine) …

1 answers | 27 mins ago by soren.qvist on Stack Overflow
0 answers

Creating User Defined Function in Spark-SQL

I am new to spark and spark sql and i was trying to query some data using spark SQL. I need to fetch the month from a date which is given as a string. I think it is not possible to query month ...

2 answers

SQL command in C# doesn't work

I am trying to add new data to the DB table called Users. public string SendUserData(string Name, string Password, string Email) { SqlCeConnection conn = new SqlCeConnection("Data Source …

2 answers | 28 mins ago by vlamaster on Stack Overflow
2 answers

Access Query or VBA - Split data into line level

How do I get the following Project | Code 1 | Code 2 | Code 3 1 | a | b | c 2 | a | d translate into getting code on line level by project? Project | Code 1 | a 1 | b 1 | c 2 | a 2 | d …

1 answer

SQL SERVER select statement doesn't seem to be able to select more than one column

I am currently using SQL server 2008. I am getting very frustrated because my select statement does not seem to be able to select more than one column. Each time I select from my database table, it …

1 answers | 29 mins ago by Jolene on Stack Overflow
0 answers

generate ssrs report on demand & send in email

Hi I am using SSRS for reporting. In application on the web page providing user to select parameters like for which region & for how many client they want report. Now as we are having ...

1 answer

SQL: Selecting data from table that doesn't exists in a different table

In one table I have the following data: As result of the query I want to have all the contracts (CONH%) that doesn't have a Support Contract. In this case it should return 'CONHMIG0002'. I tried …

1 answers | 35 mins ago by Peter O on Stack Overflow
0 answers

Database design suggestions for a data scraping/warehouse application?

Im looking into the database design for a data ware house kind of project which involves large number of inserts daily.The data archives will be further used to generate reports.I will have a list of …

1 answer

Import Excel data to sql database using

string filepath = FileUpload1.PostedFile.FileName; string filename = Path.GetFileName(filepath); string ext = Path.GetExtension(filename); String strConnection = "Data Source=;Initial ...

1 answers | 37 mins ago by santhosha on Stack Overflow
15 30 50 per page
1 2 3