how about something like this:

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

ALTER PROC [dbo].[bsp_intranet_product_search]

@ProductIdNVARCHAR(100),

@ProductDescription NVARCHAR(300)

AS

SELECT DISTINCT TOP 100 ProductId, ProductDescription, CrossReference,

ISNULL(CONVERT(VARCHAR,SUM(QuantityOutstanding)),'0')...

I believe the main thing it comes down to is economic feasibility. If "alternative" fuels and methods of electricity generation were reliable and profitable, you'd see them driving the...

It would also help to know what indexes are on the table being queried.

Can the letter be in any position of the string or will it always be the first? If it can be in any position you won't want to use...

The LT files are a "lite" version of the AdventureWorks databases, with a simpler schema and design.

John,

sorry for the confusion. If you're using...

SQL Server 2005 keeps some informative statistics about query execution plans in the dynamic management views. These queries can help you easily identify long running and I/O intensive queries:

--...

Another thing to be concerned about, did the 3rd party tool recommend any index changes? Index changes to clustered or non-clustered indexes should be considered across the entire application...

yes, ROW_NUMBER is a very useful and versatile tool that can be used in a number of circumstances.

FYI, the problem in your original query seems to be this line:

WHERE productid...

How many tables are you looking to copy and how frequently will you copy them?

A solution I've used at some places I've worked at where the table layouts are the...

another option may be to use OPENROWSET instead, with the Access driver. It's a bit more forgiving when dealing with quoted CSV files:

INSERT INTO CSVTest

SELECT * FROM OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Text;Database=C:\;','SELECT *...

sam (10/22/2008)

---

My question is, is it better to manage all client information in a central client database as we are, and push client information to individual application databases? Or...

Another thing to check is what else is running on the server at the same time as the mantenance plan. I've seen a situation before where a system backup...

This is simply an OUTER JOIN:

SELECT i.Name, c.Amount

FROM Ingredients i

LEFT OUTER JOIN Calories c...

Could it have something to do with the way you've disconnected the effective dates to their associated expiration dates? I'm not sure how your subqueries are fitting the data...