I will not question you like Andy. But one thing I believe is luck. I have respect for knowledge and Experience but Luck factor sometimes works. To achieve something (job)...

Simon_Lo (4/29/2008)

---

when google used a black verison for the one day it did state that it actually made no difference to energy consumption and was to more highlight people awareness...

You can do it in lot of ways. Please tell us in what context you want to fetch data.

🙂

Hi Sreeju

I may be wrong. May typed wrongly. I will check it again. Thnks for the info ......

Rajan provided good links.

Study this also:

http://www.informit.com/articles/article.aspx?p=415181

Hi Jeff

Your code was no 1 that's why the person gave you 1. Why are asking for explanation? :hehe:

Joke apart the article was fine. 🙂

I agree with Steve totally. There can be questions with multiple correct answers. Even Microsoft gives that type of question.

But I do not want questions with wrong answers. ...

The article was nice. I hopoe the code is right. But when I tried to run the code I am getting error in the Insert statement.

BEGIN

...

You cannot use a fieldname with a aggregate function in select statement without mentioning it in the group by clause. As pointed out by chirag you cannot use an image...

These types of problems should be taken care. Otherwise it becomes very confusing. In another forum we already discussed about these problems.

🙂

The output you wanted is very cumbersome. Think of a matrix type output or Pivot table like output. 🙂

Useful one. Good for the new bies in SSIS. Also the links provided at the end are useful. 🙂

Nice one. 🙂

A very good topic steve. We may found new source of energy day to day but how many of us are thinking of saving energy. We keep our monitor on...

Good and very helpful list...

Thnks Steve 🙂