Here is a select statement that will show how to get the information you are looking for. All you need to do is convert this into an UPDATE statement:

...

A single procedure will only use multiple processors when SQL Server believes a parallel plan will produce better results.

What did you set/change to tell SQL Server that multiple cores are...

I would recommend scheduling a time when you can grow your database files. You want to have at least 20% space available in the data file (not the combined...

Also make sure you are in fact running SQL Server Standard and not SQL Server Express (which would limit you to a single processor).

If your application uses a single connection...

Lookup Common Table Expressions in BOL. You probably will need to use a recursive CTE - but it should work.

Jeff

Then maybe something like:

SELECT *

FROM Customer c

INNER JOIN (SELECT DISTINCT cust_number

...

anjan.ashok (6/19/2008)

---

Hi this is my sp

CREATE PROCEDURE sp_replace_value (

@strcvalue varchar(100),

@strdesc nvarchar(100)

)

as

update testtbl set value=@strconfigvalue,desc=@strconfigdesc where value=@strconfigvalue

here assume we have value column data...

mrogers (6/19/2008)

---

Back in the day, when I had to join tables manually through code, I could handle single row joins. but in SQL I don't know how.

I want to...

hayess (6/19/2008)

---

I'm trying to filter my WHERE clause:

WHERE (c.CustomerID = '3942') AND (ol.DetailTableID '6/17/2008') AND (o.Opendate < '6/19/2008') AND (ol.PLU LIKE 'ONL-ANN%') OR...

Not automatically, but easy enough using SQL:

ALTER DATABASE db1 SET COMPATIBILITY_LEVEL = 90;

Yep - that would do it. Dang, didn't even see it myself - probably should put my glasses on :hehe:

You can use either of these techniques:

-- find all missing rows in table2

SELECT ...

FROM table1 t1

LEFT JOIN table2 t2 ON t2.pk = t1.pk

WHERE t2.pk...

I don't see anything obviously wrong with the syntax, but could this be caused by one (or more) of the sub-queries is returning a NULL?

Try wrapping each sub-query with COALESCE...

John Rowan (6/19/2008)

---

Jeff, Do you have documentation to support that SQL Server behaves that way? I've never heard this before. Are you saying that if you create a...

Have you ever run a full backup on that database? Was this database created on the DEV system or restored from live?

If this is a brand new database created...