I still think the 'Third Party Software' forum is not a good idea.

Brian

If you want to warn people about the licensing, you can just put the title 'licensing' and put the link in the post.  The title was a bit 'hostile'.

You don't...

You are absolutely right that there are not enough people or DBA to understand data warehouse.

However, do you think there are enough people to fully understand SQL, T-SQL, DTS and...

Just curious !!!!!

Instead of COUNT, you should use SUM in the CASE statement

select PinPackages.PackageName,

SUM(CASE WHEN datepart(hh,TransactionDate) = 0 THEN 1 END) AS [0AM],

SUM(CASE WHEN datepart(hh,TransactionDate) = 1 THEN 1 END)...

I used to work for a software development company.  When the company released the product due date and you were trying to meet the date, some of the testing would...

Steve

Since I am a data warehouse developer , why do you think BI and  OLAP would never catch on.  I had my first data warehouse project in 1993.  BI has its...

Then my query

SELECT RIGHT(('00000' + CAST(Field AS VARCHAR(5))), 5) will give you waht you want, just try it.

Let me know.

Can you give me an example?

You mean the value in the table can be 1, 23 or 456, but the fixed length of the CSV field is 5 ??

In my...

The problem was they did not test their system thoroughly.  What a lousy implementation!!!

Whose fault is it ?  The management did not plan it right, or the developers did a very lousy...

It was Amazon's mistake and they had to pay for their mistake.  It is not right to charge customer's credit card without authorization.  The customer could tell the credit card...

I just did one that required leading zeros on one of the numeric fields.

If the length of the CSV field is 15.

In the select statement

SELECT RIGHT(('000000000000000' + CAST(Field AS VARCHAR(15))),...

I think the most part of the decline is due simply to the effects of the Tech Bust. We all know there were tons of people in IT that...

You are lucky that your company let you work flexible hours.

When my son was young, my manager denied my promotion because he said I took too much time off because...

If my daughter wants to major in IT, I would not discourage her.  If she has not decided what to major in college, I would not encourage her to major...