So the clustered index is a composit index? What other columns are in it?

It would help if you could post the table DDL (full DDL w/ index defs too),...

For starters, I'd consider indexing the Status columns. Also, remove the Distinct and add a GROUP BY A.Status clause.

Donut Holes.

Ah, that may be where the disconnect is here. You posted your thread in the 2005 forum. There is a seperate forum for 2008 questions.

With that...

nikshepmehra (12/7/2010)

---

Thanks I tired it with the type keyword and tried to cast the string as xml type

But the query gave an error as

"The xml data type cannot be...

In addition to what Craig has posted, I don't even think Service Broker is availalbe in express.

rocky_498, what other columns are in your tables? Post your table DDL, PK definitions, indexes, and sample data. See the article in my signature line for help with...

If Bhuvnesh's solution does not work, please provide us a better example of what you are trying to do. Include sample data and table structure. See the article...

It looks like this one has been sitting all day. Working with a quadradic formula is way outside of my experience, but you may consider looking into SSAS as...

Daniel Bowlin (12/8/2010)

---

You should have them try alternating the squares with chocolate chips and little bits...

Steve Jones - SSC Editor (12/8/2010)

---

Chef.

so far today I've cooked:

- hash browns

- scrambled eggs

- bacon (twice)

- chocolate chip waffles

- popcorn

- iced tea

- coffee

- bunches of hay (not really cooked, but...

Thank you for the detailed layout of your package. First off, it looks like you are using a data flow task along with the RecordSet destination in order to...

It looks like it is running your drive space check against server 1 for each iteration of the loop. Can you explain more as to what type of task...

Happy Birthday Gail! I hope you have a great day.

Awesome! Contrats to you and your wife....