You'll find everything you need right here: adventureworks database

That's why I did ask for anything even though I don't have the...

Hard to really provide and answer with so little information. Perhaps a query selecting COUPON 1 combined with an exists subquery checking for the existence of the same order(s)...

When you say failover log shipping from A to B, what exactly do you mean?

Hard to answer your question with so little detail.

MaggieW (9/5/2014)

---

Dear all:

I have a temp table that hosts data from a MDX query, I want to select a column from that table by passing in a parameter and then...

The two solutions have very different execution plans but over the small sample dataset execution wise they are identical.

Actually, with a slight change to the code capturing stats, it actually...

Silver Spoon, Silver Spoon, when are you going to grow a .................

With this, we are supposed to pull an answer out of our arses:

I just was handed off another Server.

The...

First, for my code sample, you will need the following function. Please read the comments in the code. There is also a reference in the comments to an...

Grant Fritchey (9/5/2014)

---

TomThomson (9/5/2014)

---

cphite (9/5/2014)

---

jcrawf02 (9/4/2014)

---

Ed Wagner (9/4/2014)

---

Koen Verbeeck (9/4/2014)

---

andrew gothard (9/4/2014)

---

Gazareth (9/3/2014)

---

I've just been told: "We don't recommend running SQL commands against the database"

Right. May as well go home...

Ville-Pekka Vahteala is quite correct. Your query is returning a count of the number of records.

Okay, I had to play with this for a bit. Try this out in an empty sandbox database, but before you do you may need to create the DelimitedSplit8K...

Help me, help me, I can't trouble shoot errors. Oh, here is the code I am running.

Okay, looks like the code we were helping you with earlier. What...

Love questions where you are asked if the query that was written against the AdventureWorks database will return what is wanted instead of just running it to see if it...

t.mounika01 (9/5/2014)

---

In adventureworks database,If I need to find out the product that has highest sales for each month in year 2001..

I have written the query like this:

With CTE as

(

Select ProductID,

...

Minor change based on Jeff's comment and taking a closer look at the query I agree:

select

gla.id as GLAcct,

gla.descr as GLDesc,

...

You are most likely correct. I missed that as I was reworking my...