Use this:

declare @ID int;

--

select @ID = productcontrolid

from productcontrol

where productcontrolid in

(select top 25 productcontrolid

from productcontrol

order by productcontrolid desc);

That'll get you an ID you can use for your update.

Then just write whatever...

This should get you what you want.

;WITH

CTE1 as

(SELECT

M.MemberId

,M.MemberForename + ' ' + M.MemberFamilyName AS MemberName

,FP.ProjectName

,FC.CampaignName

,FD.DonationPromisedAmount

,FD.DonationReceivedNet

,CASE

WHEN...

It's their first mass layoff, per what...

That's an Oracle error message, unless I'm much mistaken.

I'm pretty sure Oracle doesn't support Update From.

Are you using Oracle? If so, why post the question in an SQL Server...

Barkingdog (3/23/2009)

---

Greg,

You wrote

>>> 2. I see no reason for a developer to ever be dbo of a production database. As GSquared said, they should do their troubleshooting in dev or...

To steal from Ron White: I'm anywhere from 5'10" to 6'2", depending on which convenience store I'm leaving. 🙂

Glad I could help.

The way I'm reading the LOB data is that you can alter a non-clustered index on a heap, and if it contains LOB data in the include colums, you'll get...

Really, you can't just follow the recommendations that the server gives you. You have to understand how indexes work, and then test the recommendations in a test environment.

If you...

Is this what you're looking for?

update Table2

set columnA = column1

from Table1

where key1 = key2;

What are your functions returning?

Look up Count in Books Online, and Group By.

Basically, it's going to look like:

select EmployeeID, count(*)

from dbo.MyTable

group by EmployeeID;

1.Devs as dbo for the dev database should be fine. Should have a test server/database where they are not dbo, and where they use the "regular" login, in order...

Needs to be:

WHERE CHECKSUM(a.empid,a.empname,a.empph) != CHECKSUM(staging.empid,staging.empname,staging.empph);

Try that, see if it gets what you need.

There are ways to simulate cross apply. You have to build a query that does what the function does, but which doesn't have input parameters. Then you include...