rjv_rnjn (3/29/2012)

---

I am working on a SQL query that takes a variable to base the join on. The same variable is used for ORDER BY clause. They had ensured earlier...

You have to provide more than just the linkserver.

linkserver.database.schema.table

does that help?

+1

Lynn Pettis (3/29/2012)

---

Sean Lange (3/29/2012)

---

sqlvogel (3/29/2012)

---

Sean Lange (3/29/2012)

---

Well in truth if you include the customer's current data at the time of the order in the order table you can't possibly...

JamesMorrison (3/29/2012)

---

Sean Lange (3/29/2012)

---

That was a company trying to relocate a DBA to Kansas, so I figured they needed to offer larger amounts to get someone to move, so I...

sqlvogel (3/29/2012)

---

Sean Lange (3/29/2012)

---

Well in truth if you include the customer's current data at the time of the order in the order table you can't possibly be in 3NF because...

sqlvogel (3/29/2012)

---

Lynn Pettis (3/28/2012)

---

In true third normal form, for instance, a Sales Order would not have any customer information in the order header record except the Customer Number (the link...

ColdCoffee (3/29/2012)

---

Interestingly, this yields 0 for a table that contains no null values and also uses COUNT(*) as the StreamAggregate operator. (It is also once noted by Paul White, but...

That was a company trying to relocate a DBA to Kansas, so I figured they needed to offer larger amounts to get someone to move, so I wrote that off...

OK so now what is you want to retrieve from this?

This exact issue is the topic of today's spackle article by Jeff Moden. http://www.sqlservercentral.com/articles/T-SQL/88244/%5B/url%5D

The version that Maddy posted looks like a better solution. I apologize Maddy I did not see your response when I posted my first one.

The trigger does not look right to me at all. It does not support multiple row inserts. Even though the hard coded value of 1 seems a bit odd you...

You have me a bit confused by this. Count(*) and Count(1) will always...

Your question is very unclear. Can you try to explain it more clearly?