My thoughts:

I picked up SQL Server a point release after the author (6.1 v 6.0)  While I had databases in school, I did not really know SQL.  I had used...

My thoughts:

I picked up SQL Server a point release after the author (6.1 v 6.0)  While I had databases in school, I did not really know SQL.  I had used...

I just had a similar need - thanks - I got the arguments to charindex reversed. 🙂

For posterity:

ALTER FUNCTION [dbo].[HCA_FindLastWord](@InString nvarChar(Max)) RETURNS nvarchar(max)

AS

BEGIN ...

It is funny - I got out of school 15 yrs ago trained in C/C++ and I have only written 2 programs using those languages. Businesses like the RAD...

The other issue with this question is that the category is incorrect. No where in the statement does it indicate that it is a primary key. it is...

It depends on the definition of "other job."

I work primarily as a DotNet developer with heavy emphasis on SQL but I do not let that stop me from doing other...

Been there - done that - bought the tee-shirt...

You need to set limits and have outlets or else things will spiral out of control.

I will not go into the details...

I enjoy the work I do. After a career of 14 years in development, 11 of that consulting, I again accepted a permanent gig. The job is not...

I have been thinking about this topic in the back of my brain since I read the post this morning.

The initial attempt was good for a first attempt but the...

Ron Kunce (3/27/2009)

---

At work, its the kunky old ink jet printer in the next cube that's print head crashes from end to end so hard and loud that it actually...

Working in a multilingual environment with everyone speaking their native tongue. In our office we have Americans, German, Latinos and a smattering of Indians.

I know that they are not talking...

Let's have fun and try to improve it.

Count me in.

I would have to vote against making the salaries public.

Even with the negotiations for starting salaries, there might be disparities in raises during the review cycle

I saw that...

After working as a consultant for many years, I learned to dress for my audience. When working with the development teams, I would dress as they did, to gain...

You want to run the sp_configure stored proc.

Check the books online for more help.

From my cursory perusal of the BOL, you want to do something like:

-- ========== Sample SCRIPT ===============

USE...