Steve,

The vast majority of the SSC Community truly appreciate your efforts, including any occasional errors that might be made. I would think that a "newbie" would have better things...

While I don't believe that you need a degree to succeed, I do belive that it helps to open a lot of doors. I've got degrees in Business and...

I think that the standard rule of thumb one should use when seeking somone's assistance is that a "reasonable" attempt should be made to troubleshoot and resolve an issue before...

There is sooooooo much truth in this article.

In many ways being a DBA is much being a Custodian. As long as the facilites stay in working order, no one...

I regularly write SQL queries to check for certain conditions in my data. We've developed a system used to automate the calculation of Teacher Bonuses that are based on...

Maybe I'm missing something, but I would think that datename(m,join_date) like '%a%' would also pull data for the month of August effectively rulling it out as a possbile solution,...

I agree with Steve.  I've been in the industry for 14 years and rarely do I miss personal events in order to work.  In the few occasions that I've made...

Hi Steve,

Several years ago, I had the opportunity to work from home as a private consultant.  Although this scenario definitely presented a unique set of challenges/distractions, I found that by...

I look forward to the day that I can retire from the regular work week, but I doubt that I'll ever get completly away from database development and the desire...

I was having the same problem and it appears that I was able to resolve it by reimporting the package but setting the Package Protection Level to teh very...

I started a career as a developer in 1992.  My nearsighted vision gradually worsened until early 2001 when I had LASIC done.  Although I can't can't say for certain that...

Try this:

--NOTE: Change TableName and ColumnName to respective values.

IF NOT (SELECT object_id('dbo.TableName') as idnum)IS NULL

BEGIN

IF NOT exists(SELECTt o.* from dbo.sysobjects o JOIN syscolumns c ON c.Id = o.Id WHERE...