Programming SQL
in [Microsoft SQL Server]
|
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
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 |