Just ask for a new chair. I've spoken to several accounting higher ups about stuff like this and the overall attitude is that it's not a big deal. ...

Why do I need to remember all sorts of symbols for operators like &&, ||, != etc when I can use simple english to write code. I wonder who decided...

I haven't yet come across any rational as to why the == operator was chosen as the equality operator instead of overloading the = operator and relying on context...

I hate to break it to you, but T-SQL IS a scripting language. It's a language for...

Being just about 5ft tall, most driving seats do not move far enough forward to touch the pedals. It seems that most American cars are automatics and do not have...

When I looked at the Civic Hybrid in 2004 (I think, maybe 2005) I found that the passenger's seat...

Disclaimer: I worked at a Tier 1/Tier 2 supplier in the 1990's and a lot of my family worked and works for GM.

The biggest issue with the US Auto...

I am in favor of the middle road for this. The employee should be expected to work out their two weeks, but they should have their privileges revoked immediately....

I would like to mention to those who are recommending a local backup first that not everyone has enough drive space on the server to hold their complete database twice....

There are two service accounts associated with SQL Server. The SQL Server account and the SQL Server Agent Account. These may or may not be the same. ...

Using the Constraints of using the existing Holidays Table and not using a date table and no loops, I came up with the following function. I do use a...

To make this work in SQL 2000

Change the first Query to:

[Code]

-- Calculate prevalence of column name

SELECT COLUMN_NAME, CONVERT(DECIMAL(12,2), Count(*)* 100.0/t.total) as [%]

INTO #Prevalence

FROM INFORMATION_SCHEMA.COLUMNS

CROSS JOIN

(SELECT...

I think another aspect of this is that if my department comes in 10% under budget this year, we don't get rewarded for this, the manager, or more likely, the...

From a company perspective this just made it more difficult for the company as these individuals have software loaded on the machines made available to them by the company and...

Reply to :Why use the cross join?

Yes it could be done in a way you have shown but then the whole personid should be marked as improper if any DEDATE...