abhisheksrivastava85 (5/17/2011)

---

There is one more issue comes into picture when we use isnull and replacing null with 0 and not null with 1 in denominator. If suppose we have nulls...

opc.three (5/16/2011)

---

Hey MM, based on your commentary on this post and others I am confident that you are an experienced SQL...

Edit: duplicate post - site returned an error when I posted the first time, so I tried again!

I finally had time to work on this....and then once I finished I find Michael had posted a more complete solution...aaaggh!

Never mind, I will post mine because I have done...

I actually use SQL Agent jobs dynamically as a method of executing background tasks from a web application - where the user...

abhisheksrivastava85 (5/16/2011)

---

Dear All,

My query is related to handling null values in calculating the average...

Thanks for the kind comment CC - I am hoping it is...

ron5 (5/15/2011)

---

i'm wondering if anyone knows of a simple trick in achieving a 'staggered' sort.

i requre the values to be returned in order of first the highest Value, then...

As said before, it DEPENDS...

I would try playing him a bit.

Him: Magoo!

Me: What (spoken curtly)...(pause for effect)... can I do for you today?

Repeat that often enough and he will learn...

Welsh Corgi (5/12/2011)

---

Perhaps I'm not using the correct terminology or stating my question correctly.

But whatever you had to do to perform the following in this environment is what I'm asking.

Thank...

Welsh Corgi (5/12/2011)

---

Thank you for your response.

I needed to know how to do the the attachment but I was trying to determine how to do a screen shot a previous...

You are too kind :blush:

1. Start a reply

2. Scroll down and click "Edit Attachments"

3. Click on "Choose File"

4. Pick the file to upload, then click on "Upload Attachments"

5. Once you...

Can you post the table and index definitions?

You might also be interested in this other method:

declare @myXml xml

set @myXml = '

<MyXmlData xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="MyXml.xsd" RequestId="D9E4EBA6-5E29-4206-929C-33594AA7F713" PrintDestination="CH3001" PrintPriority="5">

<SalesChannel>A03</SalesChannel>

</MyXmlData>'

select @myXml.value('MyXmlData[1]/@PrintDestination','varchar(20)')