sql

Optimise ignoring of undefined variables when building find conditions in Rails

Hello, I have a an method that retrieves Groups that are present in certain areas. Groups are given a country_id, region_id and city_id The UI gives three select boxes to choose a country, a region from that country and then a city from that region. To find all groups in a particular city, I have this code: @groups = Group.find(:all, ...

Displaying a single rank in MySQL table

I have a table called 'highscores' that looks like this. id udid name score 1 1111 Mike 200 2 3333 Joe 300 3 4444 Billy 50 4 0000 Loser 10 5 DDDD Face 400 Given a specific udid, I want to return the rank of that row by their score...

Replace relational DB (SQL Server) with rules-based/declarative implementation?

I have started working on a project in the financial services industry that is based (mainly) on SQL Server (2000), ColdFusion (8), and some Access/.NET applications. This project started as some simple Access forms/VBA and was slowly converted to web interfaces. I could say that the database design and application coding was done by pe...

Notification for finishing SQL Server query

Is there any plugin or tool give notification when a SQL Server query finishes? Maybe through email/ popup window. Thanks! ...

The faster of two SQL queries, sort and select top 1, or select MAX

Of the following two queries, which is faster? 1 SELECT TOP 1 order_date FROM orders WITH (NOLOCK) WHERE customer_id = 9999999 ORDER BY order_date DESC 2 SELECT MAX(order_date) FROM orders WITH (NOLOCK) WHERE customer_id = 9999999 ...

I'm using SQL UDF's to encapsulate simple reporting/business logic. Should I avoid this?

I'm building up a new database in SQL Server 2008 for some reporting, and there are many common business rules pertaining to this data that go into different types of reports. Currently these rules are mostly combined in larger procedural programs, in a legacy language, which I'm trying to move over to SQL. I'm shooting for flexibility...

Need MySQL Queries to delete WordPress Posts and Post Meta more than X Days Old

I run a blog where the community can post time-sensitive community links (sports scores and such). After a certain time, those posts are no longer useful, so I want to delete them in batch via a MySQL query, but I don't know how. I imagine that getting rid of those posts entirely is more than just deleting from the wp_posts table, right?...

Running SQL query from Module with a function call from my Form

I have a form set up where I want to run the function PopulateGrid on it's Form_Load event. I have initialized the DB connection as follows: Private Sub Main_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load LoadConfigFile() cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Sourc...

Update table a from table b where (conditions)

Evening all, Actually, it's night. About 11pm. My brain is shutting down and I need a bit of help so I can finish and go home :) I have two tables - table a and table b. I need to update a field in table a with the value from a field in table b when two other fields match. The tables don't have a unique id for each record :( Basica...

SQL Server Filestream - Delete "speed"

Hello, I'm working with the filestream datatype for the first time (SQL Server 2008) and I'm running into issues when I am doing some fast insert/deletes. Basically the speed at which the files are actually removed from the FileSystem is way slower then the insert/delete speed even if I invoke the garbage collector manually (As far as I ...

Check if a given DB object used in Oracle?

Hi does any one know how to check if a given DB object (Table/View/SP/Function) is used inside Oracle. For example to check if the table "A" is used in any SP/Function or View definitions. I am trying to cleanup unused objects in the database. I tried the query select * from all_source WHERE TEXT like '%A%' (A is the table name). Do y...

Notify a C++ application when a change in a SQL Server table is made

I've posted this before but haven't obtained a suitable answer that fits my requirements. I'm looking for a technology to notify a C++ application when a change to a SQL Server table is made. Our middle-tier is C++ and we're not looking to move onto .NET infrastructure which means we can't use SQLDependency, or SQL Notification Servers. ...

SQL Server Recursion Question

I need to create links between pairs of items and rows of item pairs: ItemA ItemB ---------------- 1 2 1 3 4 5 4 6 6 2 7 8 9 2 9 10 11 12 11 13 14 15 Matching on either side of a pair constitutes a link: Link A B --------------- 1 1 2 1 1 3 1 4 5 ...

Cannot connect to SQL Server Database

I cannot connect to SQL Server Database. I am trying to setup Membership with roles on my website using the MSDN Tutorial. It used to work only locally on my machine, however after following advice given on different forums, and on stackoverflow, the situation worsened, and now I can't even connect to the SQL Server Database. When I ru...

SQL Compact - Error executing multiple insert statements.

I'm using management studio to connect to my sql mobile/compact database. I'm trying to insert some dummy data into some tables, for example: INSERT INTO FlooringTypes (FlooringType) VALUES ('Carpet') INSERT INTO FlooringTypes (FlooringType) VALUES ('Smooth') However it returns the error: Major Error 0x80040E14, Minor Error 255...

SELECT to pick users who both viewed a page

I have a table that logs page views of each user: +--------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+---------+----------------+ | view_id | int(11) | NO | PRI | NULL | auto_increment | ...

Login failed for user using SQL authentication

I have a connection made with a user name say ABC. In a method I create a new instance of sqlconnection named connection1 using the same connectionstring as that of the previous connection. When connection1.open() is issued it gives an exception stating that Login has failed for the user ABC. When SQL is able to connect to the user ABC f...

Rename data, then delete duplicates

I've got a large dataset, some of which is is duplicate records, which are identifiable by dupes in two fields. To find these records, the following query works: SELECT * FROM supplierstuffs GROUP BY "Supplier Code", "Cost ex Tax" HAVING count("Description") > 1 Basically what I want to do is cat together all the values of "Descripti...

long running queries: observing partial results?

As part of a data analysis project, I will be issuing some long running queries on a mysql database. My future course of action is contingent on the results I obtain along the way. It would be useful for me to be able to view partial results generated by a SELECT statement that is still running. Is there a way to do this? Or am I stuck ...

How can I get a table of dates from the first day of the month, two months ago, to yesterday?

I have a situation that I would normally solve by creating a feeder table (for example, every date between five years ago and a hundred years into the future) for querying but, unfortunately, this particular job disallows creation of such a table. So I'm opening this up to the SO community. Today is Jan 29, 2010. What query could I run ...