Hi everybody, how can I omit duplication from the rows(results)? Thanks, Nassa ...more >>

I'm using SQL Server 2000 in a Windows 2000 Server Box There is a table with a datetime type column, named date, for logging propose I want to delete all records what are older then 90 days So I do "Delete from Table where datediff(dd,[date],getdate()) > 90" It's so slow, it cost me about...more >>

Hi, I want to retrieve all the customers who din't place the order for past 90 days. example customer c_num c_name 1 sdfsdf 2 sdfsdf 3 2342 orders o_num c_num 1 ...more >>

I got this query from Vadivel. It works in SQL Server 2000 as well as in 2005. I would like to know the equivalent of this in 2005 alone (may be we need to make use of some catalog views here) Select [name] as "Orphan Tables" from SysObjects where xtype='U' and id not in ( Select fkeyID ...more >>

Could anyone tell me how to eliminate the duplicate options that I have on the SQL 2005 toolbar? Screen Shot of what I see: http://i123.photobucket.com/albums/o283/gscott523/Untitled-1.jpg ...more >>

Hi, I run on SQL Server 2000. Every month the reporting database is updated from the Production database whereby tables in the reporting database are dropped and built again. There are 2 views too which get built too using a trigger. So the views refer to the right tables after being re-bui...more >>

Hi, I have a stored procedure whose only purpose is to output the output of another stored procedure. I use a temporary table to store the dataset returned from another stored procedure, as follows: ------------------------------------------------------------------------------------------...more >>

Hello there I need to place on temporary table some data which isn't unique If i'm using select into statement it works the fastest way. If i only create table by Create table statement without declaring and primary key it works little slower but ok. And when i add uniqe identifier: I...more >>

Dear all: I have a problem about ASP link with 2 different SQL Server. (2 SQL server installed in 2 different PCs) I have few tables stored in Server A. (The source) and for some reason I create few tables in Server B. I am tring to use ASP to select the records in Server A and copy it to ...more >>

Hello there I have 3 tables: Customers, Bills, Debits. Customers table holds all the data of each customer. On any time the customer get debit it it written on dabit table. and for time to time the users sets bill to the customer. In the bill is written summerize of all debits who h...more >>

hi, I tried to create an aliase on the server. I went to Configuration Manager on the server and right click on aliase to create new aliase. Then I connected to the server with the aliase name from my machine. It falied all the time no matter I used TCPIC with Port # 1433 or Named PipesD...more >>

I have a table of documents, say dbo.docs acct, docid, etc. 1, 0001, etc. 2, 0002, etc. 3, 0006, etc. 4, 0008, etc. And a name table, say dbo.name acct, name 1, Joe 2, Jerry 4, Jack I want to run a query that finds records in dbo.docs that do not have an associated record in the...more >>

I have an application that supports the notion of task assignment where a task can be assigned to a user or a group, but not both. My first inclination is to simply have a Tasks table with foreign key relationships to a Users and Groups table, but I want the schema to represent the fact that a...more >>

Hello, I have a big problem with a backup on sql 2005. I had SQL 2005 express studi and I bought SQL 2005 Workgroup Edition. I made a backup of my database with sql express and try to restore it with workgroup edition. But I can't. I have this message too many backup devices specified...more >>

I've been reading about TableAdapters (the name doesn't resonate with me and I cannot remember seeing a definition). In many generations of data processing, I cannot remember once where every table had to have every field read/written/updated. Generally there are two types of data. The major tab...more >>

All-- I am trying to create a partioning function in sql 2005 for a table that I want to partition on the datetime field for each month's worth of data and keep getting a syntax error. Is there something I need to enable on sql 2005 in order to make this work or do I have a syntax error? He...more >>

For some reason, my mind can not wrap around the concept of a primary and foreign key. Now, I have to build a test database in SQL 2005, and these keys are the only concepts that I still do not understand. I used to think that a primary key was a field that other tables share in common, but i...more >>

I issue a query to select all records except those where an INTEGER field has a certain value. When I only had two values to exclude I used a query of this general form: SELECT MAX(detailid) FROM calldetails WHERE (Extension is null OR Extension = 500) Now I have to exclude 16 values. Is...more >>

I tried to post this about an hour ago, so if it shows up twice, sorry about that. I have a table of values 1000 145000 2000 120000 5096 10024 2350 149641 For instance if I choose the value 2000, I would like to return the next greatest value. So I would like to have 2350 re...more >>

Hi I was wondering if it is possible to kill all processed based upon a parameter, such a user or application or database? Kind regards Ricky ...more >>

I tried to post this about an hour ago, so if it shows up twice, sorry about that. I have a table of values 1000 145000 2000 120000 5096 10024 2350 149641 For instance if I choose the value 2000, I would like to return the next greatest value. So I would like to have 2350 r...more >>

Does anyone know, how to solve "timeout period elapsed prior to the completion of the operation" problem which occured when I tried to update a column value using MS SQL Server 2005 Management Studio (SMS). Our server setup is: 2 identical MS SQL 2005 installed in Windows 2003 OS and the f...more >>

I have a table of values 1000 145000 2000 120000 5096 10024 2350 149641 For instance if I choose the value 2000, I would like to return the next greatest value. So I would like to have 2350 returned. How can I do this? Thanks Henry ...more >>

Hi! I'm working with SQL Server 2005 and want to make some curve fittling a la linear regression, but with more complex function: Y= ax*x + b*x + c y = exp(x) y = ln(x) etc... Because I plan to use Reporting and Analysis Services also, it would be fine if I could use Reporting Services or...more >>

Hi group, i'm having a problem with custom ordering in a SP. My code is the following: CREATE PROCEDURE [dbo].[PersonasSelectAll_P] @fromRow int, @toRow int, @expresionOrdenamiento int = null AS SET NOCOUNT ON DECLARE @TotalFilas int ...more >>