Glad we could help 😀

But you did the most important part by providing ready to use sample data, by showing what you've tried so far and clearly explain what your...

Lynn Pettis (6/28/2010)

---

Here is why he couldn't change his call after seeing it in instant replay, he is bound by the same Laws of the Game as the players and...

That's something I cannot confirm...

Lynn Pettis (6/27/2010)

---

I will agree that there have been some bad calls, some made and some that should have. Over all, however, I think the officiating has been good....

Hmmm, I'm curious what the OP think about the responses...

Matt Miller (#4) (6/27/2010)

---

...

It's hard to even support that claim (the "dodgy decision" one). I can't believe FIFA actually tolerates the shoddy refereeing that's being shown. It seems like...

Here's how I'd do it:

Step 1: UNPIVOT the data to get a more normalized data structure.

Step 2: Apply the string split function (side note: you might want to either search...

irmorteza2000 (6/27/2010)

---

Hi

Suppose we have a website with 1,000 viewers each second. And we want to insert the viewer’s information(for example) to the SQL database. So we must insert 1,000 records...

To all UK soccer fans:

I'm truly sorry for having such a blind (assistant) referee! The "Wembley-like" English goal was clearly in... At least this time (I'm not talking about '66...

kpsr_kpsr 63487 (6/25/2010)

---

Hey did u get the solutions for that man?, if u not plz ping me, then i will give idea,whether it works or not, I tried same scenario...

You could use CTE's

Something like

;

WITH cte1 as

(

select zone, count([incident id]) as cnt1

from incident_detail

group by zone

), cte2 as

(

select zone, count([incident id]) as cnt2

from incident_detail

...

duplicate post.

Please reply here.

Here's my approach:

;WITH cte AS

(

SELECT

relationid,

ROW_NUMBER() OVER(PARTITION BY ProductId

ORDER BY CASE WHEN XAML IS NULL THEN 2 ELSE 1 END, DateRelated DESC) AS ROW

FROM ...

Jinx-640161 (6/25/2010)

---

...

Does this make sense?

I did suggest a change to the way the apps generate the inserts (by as you suggested removing the '-'), but they just stared at me...

Ray's approach won't give you the requested result since it will always return all rows. Just test it with rows holding an XML string without the Location element or with...