Viewing 15 posts - 13,516 through 13,530 (of 14,953 total)
Right-click the Jobs tab, select Create New Job. Add the proc as a step in the job, add the schedule you want. If you're comfortable with the usual...
- 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
June 4, 2008 at 9:21 am
Using persisted views could, theoretically, get you most of what you need. But it won't get you all of the features of full-text indexing, at least not easily.
- 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
June 4, 2008 at 9:17 am
From what I can tell, those two collations are just different versions of the same thing (same collation, different name because of different versions of the server software). 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
June 4, 2008 at 9:15 am
No danger of that. Not any time soon, anyway.
This page has a list of what will be removed in future editions:
http://technet.microsoft.com/en-us/library/ms143729(SQL.100).aspx
- 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
June 4, 2008 at 9:08 am
Rick Magnuson (6/4/2008)
As a whole, most DBA's aren't working on mission critical applications that could potentially jeopardize one's life.
Neither are most doctors. The vast majority of medical work is...
- 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
June 4, 2008 at 8:11 am
On the subject of being asked to fix stuff by friends/random people at parties and such, I've had both. I used to be an EMT, and have just enough...
- 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
June 4, 2008 at 8:04 am
Any chance of you posting the code in the forum, instead of in a zip file? I'm sure you'll understand that I'm a little wary of opening a zip...
- 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
June 3, 2008 at 2:45 pm
Marios, shouldn't your first test have created a unique clustered index, not just a clustered index, for purposes of this test? Or did I miss something?
- 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
June 3, 2008 at 2:42 pm
John Samples (6/3/2008)
- 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
June 3, 2008 at 2:38 pm
I may be misunderstanding something here, but SQL Agent runs steps sequentially. It finishes each one, tests for success or failure, then does whatever has been set as the...
- 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
June 3, 2008 at 2:34 pm
Try this:
;with
T1 (Date, C1V) as
(select date, sum(value)
from table_1
group by date),
T2 (Date, C2V) as
(select date, sum(value)
from table_2
group by date)
select isnull(t1.date, t2.date) as Date,
isnull(c1v, 0) as C1V,
isnull(c2v, 0) as C2V
from...
- 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
June 3, 2008 at 2:26 pm
Why not add a column for this to your Calendar table?
If you want to find the number of weeks from some base date (1 Jan 1900, for example), use datediff(day)/7....
- 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
June 3, 2008 at 2:21 pm
A CLR Regex will be the fastest way to do this.
Check out this thread on the subject:
http://www.sqlservercentral.com/Forums/Topic470379-338-1.aspx
- 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
June 3, 2008 at 1:24 pm
Steve Jones - Editor (6/3/2008)
- 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
June 3, 2008 at 1:08 pm
Try Jason's, and also try this:
SELECT DISTINCT -- Greater Than
C.TEST_DESC AS LAB_TEST_DESC,
E.RESULT_DESC
FROM ... -- Your table here
WHERE
(C.TEST_DESC = @test-2 OR @test-2 = 'ALL') AND
CONVERT(MONEY, E.OBSERV_VALUE)>@VALUE
AND
@OPERAND = '>'
UNION ALL
SELECT DISTINCT...
- 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
June 3, 2008 at 12:46 pm
Viewing 15 posts - 13,516 through 13,530 (of 14,953 total)