Oh, and forgot to mention....  I found both your articles clear and on-point.  I dislike NULLs for the grief they cause, but they turn up even in the best neighbourhoods,...

Wow.  Serves me right for sleeping at night. 

Mike, it can be done.  Not pretty, but possible:

select t.employee_ID, employee_name, hire_date, convert(varchar(20),terminated_Date)

from

(

select employee_ID, count(*) as timesAppears

from

(select Employee_ID from active_personnel

UNION ALL

select...

Glad to see.  I'm about to start trying these services myself, so thanks for posting your findings.

And yes, I AM a stupid-head.  the 401 is an HTTP error not specifically...

It would be interesting what your IIS log said about this attempt to connect.  The 401 is (as you probably already know) an IIS error not directly to do with...

No particular order

Blood on the Tracks                -  Bob Dylan

The Future                            -  Leonard Cohen

Rum, Sodomy and the Lash      -  The Pogues

The Boatman's Call                 -  Nick Cave and the Bad Seeds

Closing Time                          - ...

You say the data is "..populated by an application.." so it probably has nothing to do with clock settings or account / locale issues at the SQL server.

It would seem it's...

Be careful about simple recovery mode unless you can be positive no other activity could be occurring, or if you're also going to establish a new (full or differential) backup immediately...

OK, my take on it is this:

The non-clustered index has to point to something, right?  It needs to either point directly to the file/page/row where the data lives - i.e. the...

How about

substring(Incident_Details.Description, 20, len(Incident_Details.Description) -19)

That should work, but beware of columns with length < 20

Stephen

Kathi,

Thanks for the article, and looking forward to the 2005 version.  We've just started investigating the implications of the user / schema separation, and oooohhh..  there seem to be a...

Uhh..  and I was assuming that (a)  the 'Web' part was a typo and that it was supposed to be 'Wed' and (b) that the output was intended to stay...

Memo to self.  Read original posts carefully. 

OK, so the conversion should be

select convert(datetime,substring(columnname, 5, 7) + substring(columnname,32,4) + substring(columnname,11,9))

from mytable

Rule of thumb:

Never EVER use floating point data types to store data where two or more values are supposed to add to equal some other value.   Sometimes they will, more often they...

I think you're going to struggle, however cleverly you parse the input.  The input string is missing a year.  If you know for certain that all data is from a particular...

The pity is, of course, that PATINDEX only takes 2 arguments (so no "starting from" displacement) so that to get both @pos1 and @pos2 you have to do something ugly...