My Filter
   28 tags on

My Filter

  • All Sites
  • Arqade

1 answer

Does sql server backup process use buffer cache?

When full database backup command is executed: Does the backup process USE only the memory that Has been assigned to the SQL server (instance)? Does the backup process "flush out" page from the ...

1 answer

SQL Server: Recursive Query

I've been struggling trying to write the logic to show a relationship between interrelated records. Here is some sample data to show what I'm trying to accomplish: CREATE TABLE #temp_data ( ...

2 answers

What's the best way to search a column that has multiple values separated by commas

I have a column called Genre with values like Action, Crime, Mystery, Comedy I need to search the column for Crime, Mystery for example How can I do that efficiently eg sudo code select * from ...

2 answers | 47 secs ago by code578841441 on Stack Overflow
0 answers

How to get actual exception in nested SQL transaction using try/catch block

How can I preserve the error state or return the actual error during a nested transaction? Note: Nested transactions are a business requirement and can not be removed. Currently, when I excecute ...

0 answers

SSIS FTP Task Download From Variable Folder

sometimes SSIS night job is unable to download from an FTP site because two remote folders are variable. I am able to download most of the time when folders with date and time (name YYYYMMDDHH1) but ...

0 answers

addition of date in sql function

I have a query in sql which i wrote in C#.what the query do is, calculating something like if i have an input of two columns date and no. of bats as Date No. of balls 21/11/2013 2 22/11/2013 ...

1 answer

How to stop and start or restart background processes while restarting laptop

I am facing an issue on my laptop which is installed with windows 8.1 When ever i turn ON my Windows 8.1 laptop, I can instantly login with my password, as I would expect. However, if I use my PIN ...

0 answers

Entity Framework still showing phased out columns and relationships

I must be going out of my mind. I have a column and a relationships deleted in the DB. I do "Update Model From Database" but the property and navigation properties associated with the no longer ...

0 answers

Get values from last result set of executed stored procedure

I have a stored procedure that I cannot change, and it return multiple result sets. Something like this: sp_1 BEGIN INSERT INTO ... SELECT @res1 = @@IDENTITY INSERT INTO ... SELECT ...

2 answers

Update command with parameters is not updating data table

The whole night I've tried many ways BUT sql Update command with parameters is not updating data table. I am totally fade up. The execution is successful and returns 1 row affected BUT old data is not ...

1 answer

sql select only specific fields and insert them in another table + static values

I would like to insert data from specific fields from one table in another table + some static values. Roughly I would like to do this: INSERT INTO TableA(Field1, Field2, Field3) SELECT Field1, ...

1 answer

Stored proc to find missing data for range of dates

I need to write a stored proc which would fetch out missing data for the period Following is the input to Storedprocedure @yearDisplayStart @quarterDisplayStart @monthDisplayStart @weekDisplayStart ...

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


Here is the thing: I have three tables: Table1: COL1 COL2 TABLE2: COL2 COL3 TABLE 3: COL3 COL4 AND I WANT TO SELECT THE COL4 FROM TABLE3 WHEN TABLE3.COL3= TABLE2.COL3, WHICH THE ...

2 answers | 13 mins ago by Ma Max on Stack Overflow
2 answers

Oracle How to select a set of latest entries

I have an Oracle table that looks like below: URL SIZE MODDATE MODTIME AAA 100 24-OCT-14 10:00:00 AAA 100 24-OCT-14 09:00:00 AAA 100 23-OCT-14 08:00:00 BBB 100 ...

3 answers

How to pull the whole row which has the latest date in SQL?

I’m trying to select the pair of product – distribution center attached with the most recent order (based on order date). For one order I can have multiple products, but the whole order will be ...

3 answers | 13 mins ago by RoseChris on Stack Overflow
3 answers

Ctrl R not working in SQL Server 2012

In SQL Server 2012, Ctrl+R not working. Any other shortcuts for that. Any setting changes available or is there any alternative?

3 answers | 14 mins ago by Yajuven Vant on Stack Overflow
0 answers

Need help to debug procedure in Mysql- phpMyAdmin

I have tried to create a simple procedure in Mysql in phpMyAdmin. But I'm getting an error, i don't know what is wrong. Any one please help me to resolve this. procedure: drop procedure if exists ...

0 answers

Populate data into a dropdown from a stored procedure using coffeescript/javscript

Am new to CoffeeScript. Am building an application that uses coffeescript to build and render html pages. Am using visual studio for building the application. I have created a database and some stored ...

1 answer

Splitting a table of integers in Postgresql

Postgresql newbie here. I have a table of integers that look like the following: 1950018111211111111111111 1940490521222211111111111 What i am trying to do is to left the above such that the ...

1 answers | 21 mins ago by crozzfire on Stack Overflow
0 answers

An SqlParameter with ParameterName 'ETABLE_NUMBER1' is not contained by this SqlParameterCollection

I have an application that reads data from a file and then inserts it into a sql table. I'm getting the following error "An SqlParameter with ParameterName 'ETABLE_NUMBER1' is not contained by this ...

2 answers

SQL 2008 fulltext index population delay

My manager is saying that there may be some time before a full text search index is updated after the underlying table data has changed. For example, if I have a table Products with a column ...

0 answers

ssas, assigning tabular database connection id to a variable to build dynamic query

Scripting out the partitioning of tabular cubes. I need to assign the current connection ID to a variable-which can be found by navigating to the connection properties of that tabular database ...

1 answer

ABS doesn't work in sqlite

I have a database which contains some dates alarms: id timealarm status 1 2014-10-23 13:30:00 +0000 1 2 2014-10-23 13:29:00 +0000 ...

1 answers | 27 mins ago by Belzum Nulls on Stack Overflow
1 answer

What's the difference between PRINT and PRINT() in SQL?

At first I thought brackets in SQL do not matter, until today I learned EXEC and EXEC() are totally different things: one calls a stored procedure, the other executes a string as a command. What's ...

1 answers | 28 mins ago by user1032613 on Stack Overflow
1 answer

Is there a way to transform this keylookup in an index scan?

I'm not an SQL expert (I try to get jobs done - the faster the better, obviously), I don't know if the information I'm giving you is enough to solve the problem. I'm using SQL Server, SQL Management ...

2 answers

Unable to connect to the database engine using SQL Server management studio

I installed SQLManagementStudio_x64_ENU from microsoft site on my Windows 7 Home Premium. It gave me compatibility warnings but I still installed because microsoft site specified that I will receive ...

2 answers | 29 mins ago by Shilpa on Stack Overflow
1 answer

Getting ranges that are not in database

I want to get all times that an event is not taking place for each room. The start of the day is 9:00:00 and end is 22:00:00. What my database looks like is this: Event EventStart EventEnd ...

1 answers | 29 mins ago by User765876 on Stack Overflow
1 answer

when MS DTC is not used in a message queue transaction

I'm creating a design to process a large number of jobs using MSMQ to scale out. Each job is processed and the database is updated for that job Id saying it is complete. If error, it should go back to ...

1 answers | 31 mins ago by Alex J on Stack Overflow
0 answers

DBMS Scheduler Jobs

I need to run a SQL and then save the results(or export) as a excel file. Is there a way to do this automatically at schedule time? In the Job Details there is this > Type of Job > PL/SQL Block In ...

31 mins ago by sNewbie on Stack Overflow
1 answer

SQL to add an additional column that counts duplicate values for a particular column

I'm seem to be having an off day and can't seem to get this query working. Initially my query without the use of DISTINCT included the repetition of 2 rows: STAT SHNO UPDD UPDT ...

15 30 50 per page
1 2 3