First  |  Prev |  Next  |  Last
Pages: 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
eliminating duplicates
I need to elimnate duplicates the following script. I believe what is creating the duplicates is the provcont table, there are different provcont ids for each record. Thanks in advance. SELECT PROVCONT.C_FAX, PROVIDER.NAME, PROVIDER.PROV_PATH, PROVIDER.PROV_ID, PROVSTAT.STATUS, PSTATUS.DESCRIPT, ... 26 Jun 2010 15:14
Stored Proc Question: Use ad hoc Where Clause
Ive got a question on how to implement the following: I Have an sp_ that accepts two parameters. Here's essentially what the sp looks like: /****************************************************************************************************** Create Procedure sp_SearchResults @Status_ID Int, ... 26 Jun 2010 15:14
Help with upgrade from SQL 2000 sp3 to 2005
Do I just run setup.exe? ... 25 Jun 2010 18:41
sharing DBs between 2 instances on same box without linked servers
All, I have two databases A and B on one pyhsical box called 'P'. I need to put another instance of database A on same box. i can not have same database name twice on same physical box twice so my solution was to create another instance of sql server on same box and create database A on it. so now it looks lik... 25 Jun 2010 18:41
Search and Replace within string
Table: CostCenter Column: CostCenterName I want to remove all ':' from CostCenterName (update data in table). How do I do this in T-SQL ? Thanks, Greg ... 25 Jun 2010 16:30
Replacing multiple statements with a single MERGE
Here is a problem that has me stuck. This is a skeleton of an auction. We start with a simple table of bids for the items. The key is the item's identifier and sequential bid number within each time. To give the table a key when an item is put on auction, we put in a dummy bid and amount. CREATE TABLE Auctions ... 28 Jun 2010 12:51
Insert a one returned value from a MAX function in SSRS in Footer
I wish to put a one value returned from a MAX function in a SSRS Footer or SSRS Header. Thoughts? ... 27 Jun 2010 16:07
Find distinct records of the last order from a customer
Hi I am trying to find a list of customers that have not bought anything for the last xx months. I have a salesorder table which holds an orderdate and customer account code, other customer details are held in the customers table. i have a table called soitemsdespatch thats holds the parts that have been sold... 25 Jun 2010 11:00
Find distinct records of the last order from a customer
Hi I am trying to find a list of customers that have not bought anything for the last xx months. I have a salesorder table which holds an orderdate and customer account code, other customer details are held in the customers table. i have a table called soitemsdespatch thats holds the parts that have been sold... 25 Jun 2010 11:00
Find distinct records of the last order from a customer
Hi I am trying to find a list of customers that have not bought anything for the last xx months. I have a salesorder table which holds an orderdate and customer account code, other customer details are held in the customers table. i have a table called soitemsdespatch thats holds the parts that have been sold... 28 Jun 2010 05:11
First  |  Prev |  Next  |  Last
Pages: 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32