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...

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.

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...

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

Neither are most doctors. The vast majority of medical work is...

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...

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...

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?

John Samples (6/3/2008)

---

Thanks to all for the excellent input. In my case security is not a factor; the application will run internally on the corporate LAN/WAN. The segreation...

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...

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...

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....

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

Steve Jones - Editor (6/3/2008)

---

Project Management is a big part of it, but it's also how we want to be perceived by other groups and people in general. I think...

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...