Please provide table def and sample data in a ready to use format as described in the first link in my signature. Furthermore, please include your expected result based on...

Did you try a google search? (e.g. "import accdb Data Base file in sqlserver")

I'm not sure if the all-in-one approach is the best solution here, especially when talking about 50 tables used in a UNION ALL statement...

I'd probably prefer storing the data from...

I copied the error message "Switch from current encoding to specified encoding not supported." into google.

The very first link returned: "You get this error if your XML file was saved...

dandenson (4/7/2011)

---

lutzm, Just throwing out anther thanks here, I now live and breath tally tables. I have been converting views that have always been slow to use the tally table...

... and what is your question?

Born or age? :-P:-D

One possible answer is rather simple: 24.

Since the OP wants to do a calculation, we need to extract the numbers. For each question we have 4 times the number one...

WayneS (4/1/2011)

---

I'd like to start a discussion for how ORM tools (Entity-Framework, nHibernate, etc.) should perform SQL actions.

I'm specifically interested in the use of stored procedures.

1. Should ORM tools...

Sorry for the late reply...

Regarding XQuery: You could have a look at Jacob Sebastians blog or post a sample of your XML code and your target table structure to get...

seconded.

CONGRATS, Paul!

Well deserved and long due!!

Stefan Krzywicki (4/1/2011)

---

Assuming the report isn't an April Fools joke, anyone get hit by the attack?

I'd bet that many learn no lesson at all about clensing data when using dynamic...

It depends.

What is the output if you run a SELECT YorXmlColumn FROM YourTable and...

AWESOME!

Especially the last few paragraphs and the related intro!

We're...