You could also hunt this site for scripts that people have posted that essentially duplicate the VB Split function and return a one-column-wide table of each word in the string.  Then...

I have done something similar, only using a format file and lastrow:

BULK INSERT FROM 'FileIn'

WITH (FORMATFILE = 'FormatFile', LASTROW = '99')

Format files don't know about first or last rows, so...

When you show her the monitor, also show her the link to the news story on that same page, "Health Scientist Says Laziness Lengthen Life"

http://weblog.physorg.com/news1280.html

Should be a...

Really?  It looks to me like your LEFT JOIN query uses a derived table and your other query uses a subquery.  I can't really tell what you are trying to accomplish...

I know what you mean, guys.  I love SQL Server like my dog loves me.  Even though I am sometimes late with his supper, and I don't walk him enough,...

"Next on Jerry Springer:  Developers who love SQL Server too much..."

You're right.  In the comments for my example I note that I am only using a temp table for purposes of this example.

Why not create a reference table of dates and use that to join against your event table?

 -- @DateRef is a table variable only for this example;

 -- declare @DateRef as...

Kenneth:  It does indeed depend.

How big is the file?  How often is the bcp run?  A few hundred rows at a time, once a day, bringing in the entire row...

It is much more efficient to use a format file and bulk insert your data into individual columns as opposed to bulk inserting into a single column that is the...

noel:  Congratulations, I hope you and sp_help_job are very happy together.  For some reason, it just didn't click with us.  It's probably my fault, I tend to expect a lot...

Darryl:  I went with the script I wrote because I wasn't getting useful results from sp_help_job.  So calling it from openrowset still won't give me joy.

Noel:  It just plain didn't work for me, for reason or reasons unknown.  current_execution_status always returned zero, no matter what I did.  grrrr. 

So I...

Steve:  That's a good point.  Now that you mention it, I recall considering that at the time, and fiddled around for quite awhile trying to get the same result out of...

Sue:  Obvious question, but how are you calling it?  EXEC @Ret = dbo.usp_IsSQLAgentJobRunning 'myjobname'?  Then @Ret will have either a 0 or a -1.  Also, you need EXECUTE permission on...