Thanks for your responses.

But my problem is not the getting data (output) efficiently, rather I want to know that when I was using DISTINCT clause along with COALESCE, I was...

Thanks for your responses.

But my problem is not the getting data (output) efficiently, rather I want to know that when I was using DISTINCT clause along with COALESCE, I was...

Yes...

Nice article.

I know that this is not a place to ask questions, but some how it is related to CTE execution. So..

I have a CTE, which contains around 4-5 tables...

Thanks a lot Steve.

Hi,

Thanks a lot,

CirquedeSQLeil (12/7/2009)

---

The wording in the explanation don't seem to match the documentation.

http://msdn.microsoft.com/en-us/library/ms191432(SQL.90).aspx

Explanation said that the view must not contain any deterministic functions. The referenced article states that...

dewit.john (10/15/2009)

---

I have tackled this problem before. I retrieve the XML data directly from the ECB site, within a web application written in C#. The XML data is given as...

Nice article. Keep it up.

iermis (10/12/2009)

---

As I am new to SQL i cannot understand why you are using the statement

SELECT * INTO #LockHelp FROM Rainfall_Events WITH (TABLOCKX) WHERE 1=2. This statement does not fetch...

DBA-640728 (10/8/2009)

---

which one would be better in performance to use this approach, use openxml or use the Bulk Load of xml? i have to do an insert/update of around 450,000...

David Walker-278941 (9/23/2009)

---

john.arnott (9/23/2009)

---

David Walker-278941 (9/23/2009)

---

Tao Klerks (9/23/2009)

---

David Walker-278941 (9/23/2009)

---

Yes, but I'm not forgiving of superfluous apostrophes in the word "its". The sentence gets a Fail. "It's" means...

David Walker-278941 (9/23/2009)

---

ssismaddy (9/23/2009)

---

It might be the silly question....but, why we are not able to display e ??

select 1.a -- gives the column name a and prints...

Thanks Lyn

Very helpful topic.

Abhijit,

Great Article.

Moreover, nicely explained and modified by Jeff.

Really appriciate.

🙂

Stephen,

Nice article.

This is another strong reason to say not to use SELECT *, instead use SELECT [column names].