My Filter
   28 tags on

My Filter

  • All Sites
  • Arqade

2 answers

How to get next date in repeated ID sequences in sql 2008

I have a table that has multiple occurrences of its id and the date. For example: id # date 1 abc 2014-Apr-05 2 def 2015-Mar-07 3 def 2014-Feb-02 4 abc ...

2 answers | 4 mins ago by Julzncatz on Stack Overflow stackoverflow.com
0 answers

ssrs conditional join query for subreport

Query -> =Join(IIF(Fields!reftype.Value = "CP",Fields!refno.Value," "),",") input for that query from SP -> reftype | refno : CP | CP1200051 IN | INV120004 IN | IN7436754 CP | ...

0 answers

Store Procedure not return value in MVC5

I am working in MVC5 with Entity Framework through db approach. I use Mysql as database. I create a procedure and when Call Procedure in Mysql it work as my expectation. But when i use procedure in ...

0 answers

Oracle Join across tables to count 'outstanding invoices'

I'm trying to find "the number of outstanding invoices for a given contract rate". SQL Fiddle here You'll notice I have 350 outstanding invoices which is a lot more than the 14 I expected so I guess ...

1 answer

ADO.NET DateTime sql parameter lose accuracy

I am trying to delete records with ADO.NET for SQL Server, of which there is a sql command with the DateTime type parameter. using (var sqlConnection = new SqlConnection(...)) { var command = ...

0 answers

Is it possible to install SQL Server 2008 R2 on Windows Server 2012 R2?

Is it possible to install SQL Server 2008 R2 on Windows Server 2012 R2? I have the developer edition installation files.

2 answers

AWS RDS MSSQL Extremely Slow compared to EC2 with MSSQL

Background - I built a tool which grabs a lot of data from multiple third party APIs and stores it in a MSSQL DB. Then, I built a visualization to display this data in tabular and chart format. ...

0 answers

SSRS-finding uptime between date parameters

I have to find total uptime for a system or service and need to know to get the start date and end date to give me time in minutes in order to say get the percentage of time down versus the time with ...

0 answers

how to fetch data from multiple table with same schema but different schema name

I'm working on a saas app in php/mysql, i have create db according to below fig. Now with this structure i need a report with IGA and MDS customers in a particular date between. Here comes the ...

3 answers

SQL CLR Stored Procedure and Web Service

I am current working on a task in which I am needing to call a method in a web service from a CLR stored procedure. A bit of background: Basically, I have a task that requires ALOT of crunching. If ...

3 answers

Get the latest entry for a given day in Oracle

I want to select data12 [last entry for 12-21-2014], data11 [last entry for 12-20-2014], data8 [last entry for 12-19-2014] from the below table. snapshot_datestamp data ...

0 answers

T-SQL brain teaser: find non-overlapping sets

I would like to ask for help coming up with a query, which can identify groups on non-overlapping records. Here is a sample scenario (admittedly contrived). Let's say I have employees who are ...

3 answers

Are large companies successfully using SQL Server GeoSpatial functionality?

I am working on a project where I have to allow users to find things that are near by. In the past I have just manually stored lat/longs and done my own calculations but I'm curious if it's worth ...

3 answers | 43 mins ago by Abe Miessler on Geographic Information Systems gis.stackexchange.com
1 answer

How to store MS Sql Server uniqueidentifier in MySql table

I have migrated MS Sql Server database to MySql (using MySql Workbench tool) and having some hard time to figure out how to store uniqueidentifier in the table. The tool automatically converts the ...

0 answers

Insert picture into varbinary(max) in MSSQL with XAMPP version 5.5.19

I have PHP code like : $image_data = file_get_contents(PUBLIC_PATH . '/tmp/logo.png'); $encoded_image = base64_encode($image_data); $data['logo'] = "cast('" . $encoded_image . "' as varbinary(max))"; ...

2 answers

NEW LINE IN SQL 2008 R2

I want to use new line in my select query fro example: SELECT FULLNAME+ ADDRESS AS X1 FROM TBL_USERS AND RESULT SAME THIS: ABBAS KOLAHDOOZAN ISFAHAN,BOZORGMEHR ST AS A COLUMN I USE CHAR(10) , ...

2 answers

Queries against INFORMATION_SCHEMA time out

I am using SQL Server 2008 Management Studio to connect to SQL Server 2000. use [MyPrettyDb] select top 19 * from information_schema.tables It works nice and sweet and quick. But this: select top ...

1 answer

SUM quary's result which contain UNION ALL and CTE

Even though I found something similar to what I was needed, I wasn't able to work it out. So, I'll ask using my example. (It is in continuation to my prev question: select if there are more than n ...

1 answers | 1 hour ago by Yael on Stack Overflow stackoverflow.com
0 answers

optimizing a select query of 1.5 million entry

I have the following query: SELECT s0_.id, s0_.lowresimageurl FROM app_instagram_shop_picture s0_ FORCE INDEX ( idx_deleted_shopId ) LEFT JOIN app_instagram_shop s1_ ON s0_.shop_id = s1_.id AND ( ...

1 answer

submitting the attendance radio buttons to the database

am making this system and am stuck in a problm need help my database has table attandence where fields are att_id s_no std_reg_no std_name semester_id total_classes present absent i ...

1 answers | 1 hour ago by motan on Stack Overflow stackoverflow.com
1 answer

Restore from .bak only imports system tables

I was given a .bak from a MS SQL database and am needing to import the database onto a different workstation. I created a blank database in SQL Management Studio and attempted to restore from the ...

4 answers

How can I transform some KML data to Sql Server 2008 using FME?

I've just downloaded FME 14 day trial. I'm trying to see how easy/hard it is to transform some KML data (a simple neighbourhood shape) into my Sql Server 2008 database using FME. I sorta don't even ...

0 answers

SSRS Report Unable to get withing scope of the values in RowGroup. Only got values using Previous and current scope value

I already calculated a row(Add Total row) like Gross profit within Group1(a,b,c,d,e) using Previous and current scope column group values. ex: Gross Profit = a - b. Gross Profit = ...

1 answer

MySQL calculating age based on birthDate

I am trying to calculate the age based on the birthDate in MySQL using SQL statement. My birthDate was varchar() and in this format: 29/11/1994 (DD/MM/YYYY). My SQL statement: SELECT DATEDIFF(YY, ...

1 answers | 1 hour ago by Denise on Stack Overflow stackoverflow.com
0 answers

Conditional Color formatting in SSAS Cube

I have a star schema with a fact table containing the following: ID BIGINT IDENTITY, FK_Dimension1 BIGINT, FK_Dimension2 BIGINT, dataValue NUMERIC(20, 8), classification NVARCHAR(20) The ...

0 answers

There are currently no logon servers available to service the logon request

I'm trying to process dimension from Visual Studio Data Tools 2013. However, I get these errors: Internal error: The operation terminated unsuccessfully. Server: The current operation was cancelled ...

2 answers

Why can I not connect to SQL Server using server name, but works with IP Address?

So, I have two PC (PC-A and PC-B) that I've set up with Windows 7 and SQL Server 2012. I setup a port forwarding for PC-A so I can access it remotely. I can connect to SQL Server on PC-A from PC-B ...

2 answers | 2 hours ago by alfian nur on Stack Overflow stackoverflow.com
1 answer

SQL Server secure JDBC connection without reconfiguring SQL Server for secure connections

How to connect SQL Server database instance via JDBC securely without altering the configuration of SQL Server where other connections access the server insecurely and it is not possible to change the ...

1 answers | 2 hours ago by Chaddy on Stack Overflow stackoverflow.com
4 answers

MySQL query for at least once in x days

My table is like this: Name: User Transaction Data Date format DD/MM/YYYY Data of only 4 months (Sept,Oct,Nov,Dec) Id User Date 25 127 23/10/2014 26 128 25/11/2014 25 127 ...

4 answers | 2 hours ago by Mahesh Sobale on Stack Overflow stackoverflow.com
1 answer

INSERT with subquery can't bind reference to target table

I'm trying to consolidate two columns in a table into a foreign key reference to another table that contains those same two columns. I first want to do something like: INSERT INTO dbo.Securities ...

15 30 50 per page
1 2 3