Viewing 15 posts - 10,306 through 10,320 (of 14,953 total)
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 24, 2009 at 9:19 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 24, 2009 at 9:12 am
mark.hammond (3/24/2009)
I don't believe this is the first layoff at Microsoft. A friend was laid off from their graphics department in the 1990's.
It's their first mass layoff, per what...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 24, 2009 at 7:34 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 24, 2009 at 7:27 am
Barkingdog (3/23/2009)
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 24, 2009 at 7:25 am
To steal from Ron White: I'm anywhere from 5'10" to 6'2", depending on which convenience store I'm leaving. 🙂
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 24, 2009 at 7:15 am
Glad I could help.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 24, 2009 at 7:10 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 23, 2009 at 12:59 pm
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 23, 2009 at 12:54 pm
Is this what you're looking for?
update Table2
set columnA = column1
from Table1
where key1 = key2;
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 23, 2009 at 12:51 pm
What are your functions returning?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 23, 2009 at 12:05 pm
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;
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 23, 2009 at 11:57 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 23, 2009 at 11:55 am
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.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 23, 2009 at 11:50 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 23, 2009 at 11:41 am
Viewing 15 posts - 10,306 through 10,320 (of 14,953 total)