changesky (8/3/2011)

---

Thank you Lutz for providing a good solutioin with cte,unpivot and sunquey to build two nodes. According to your code, I finished the SP to generate to the whole...

duplicate post. no replies please.

Original post: http://www.sqlservercentral.com/Forums/FindPost1154024.aspx

kramaswamy (8/3/2011)

---

Well, as sorta a general rule-of-thumb to apply to most of your tables, I'd say you could start by dropping any index on the RID column, and replacing it...

Another question would be: why are there only left outer joins?

There's not a single inner join (as far as I see).

I'm with Jeff here: it seems like this is...

please provide some sample data including the expected result.

Will those columns be static or is a dynamic solution required? If so, please describe the dynamic scenario.

duplicazr post. no replies please.

Original post: http://www.sqlservercentral.com/Forums/FindPost1153892.aspx

Have a look at redgate's "SQL Virtual Restore". Seems to be exactly what you're looking for.

Tom.Thomson (8/3/2011)

---

...

Actually, if there were a world competition for the worst beers, no European country would come top - the worst European beers are comfortably outclassed for awfulness by many...

Applied from the outside or the inside?

Imaginary type or the liquid form?

Koen Verbeeck (8/3/2011)

---

...

Not only excellent chocolate, also excellent beers 😉

And I do need the diapers, just not for myself 🙂

(I just found out I can order diapers from the German...

The table holding the column CustomText01 needs to be on the left side of a LEFT OUTER JOIN and the join predicates might need to include an OR IS NULL...

Changing subject:

@Wayne:

Did you notice you have a sibling? (at least in terms of your avatar...) 😀

For a moment I was confused (more than usual)

Here are some alternatives:

If it's...

Why don't...

E McNeill (8/2/2011)

---

I have a client who currently uses MS Access 2007. His employees us a MS Access application on PDA’s to collect data and then once...