Viewing 15 posts - 4,201 through 4,215 (of 14,953 total)
Here's an initial take on it. It doesn't quite make sense, because the sub-queries don't seem to tie directly to the outer queries.
This version is only one step better...
- 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
May 31, 2011 at 11:17 am
Sorry, "partition", with reference to a running total or other aggregate, simply means to break the data down into subsets. If, for example, you had multiple orders on a...
- 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
May 31, 2011 at 10:59 am
Microsoft says you really can't shrink tempdb online. You either need to restart, or put the server in single-user mode at the least.
You've probably already seen this, but here's...
- 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
May 31, 2011 at 10:54 am
Maintenance plans do have a problem with that. That's one of the important reasons to move away from them as much as you can, and use more intelligent scripts...
- 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
May 31, 2011 at 10:49 am
It looks to me, from what I can see in the code, that the primary issue you are running into is a running total calculation that has to be performed...
- 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
May 31, 2011 at 10:46 am
You're welcome.
Are you absolutely possitive that under no circumstances will an update ever be done one more than one row, that you will need to send this e-mail on?
- 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
May 31, 2011 at 6:37 am
Jake Shelton (5/29/2011)
GSquared (5/27/2011)
Jake Shelton (5/26/2011)
- 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
May 31, 2011 at 6:35 am
jarid.lawson (5/27/2011)
Declare @TableName Varchar(128),
@FieldName...
- 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
May 31, 2011 at 6:17 am
Active/Passive, all you can legally do is use the passive as a failover if the active goes down (intentionally or by failing). That's why you don't have to pay...
- 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
May 27, 2011 at 9:42 am
A friend of mine says that what a friend of his does is buy old clunker cars, usually for around $2,000 or so. Then the only maintenance he does...
- 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
May 27, 2011 at 9:36 am
It depends on what you want to do.
If, for example, you want to perform a set of update/delete/insert actions based on iterative needs, then a Tally/Numbers table can do it...
- 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
May 27, 2011 at 9:32 am
This bit will throw an error if there's more than one row:
(SELECT end_date FROM DELETED) IS NULL
AND (SELECT [status] FROM INSERTED) = 'S'
Here's a test I ran:
CREATE TABLE dbo.TestR...
- 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
May 27, 2011 at 9:20 am
I'd recommend using an ANSI/ISO standard date format for it, so the files sort naturally. So it would be 20110527, not 27052011.
You can do that like this:
declare @String varchar(50);
set...
- 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
May 27, 2011 at 8:56 am
Not on the default schema, maybe? Or accidentally in the wrong database on one or the other connection?
As an aside, the way the trigger is written will throw an...
- 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
May 27, 2011 at 8:49 am
Stefan Krzywicki (5/27/2011)
GSquared (5/27/2011)
ALZDBA (5/27/2011)
GilaMonster (5/27/2011)
Elliott Whitlow (5/26/2011)
Jan Van der Eecken (5/26/2011)
GilaMonster (5/26/2011)
From the posts the person has made, they are totally out of their depth....
- 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
May 27, 2011 at 8:44 am
Viewing 15 posts - 4,201 through 4,215 (of 14,953 total)