Viewing 15 posts - 2,656 through 2,670 (of 8,416 total)
dbowlin (9/16/2010)
How is the earthquake recovery just south(?) of you going?
Christchurch is on the South Island (map)
They've done an awesome job and a good deal of normality has returned, though...
September 16, 2010 at 8:10 am
Thanks, I look forward to it.
September 16, 2010 at 8:02 am
TheSQLGuru (9/16/2010)
From whence did you acquire this information Paul? Neat stuff!
Hey Kevin,
The four parts cover a lot of ground - did you have a particular piece of information in...
September 16, 2010 at 8:01 am
Brandie Tarvin (9/16/2010)
Especially since he made...
September 16, 2010 at 6:07 am
Jeff Moden (9/16/2010)
Paul certainly is psychic.
If anyone still doubts that fact:
September 16, 2010 at 5:44 am
Excellent question Hugo - though I too chose the wrong answer.
September 16, 2010 at 5:41 am
There is a "workaround":
SELECT DV.[Year],
SOH.SalesPersonID,
AverageOrderAmt = SUM(SOH.TotalDue)
FROM Sales.SalesOrderHeader SOH
CROSS
APPLY...
September 16, 2010 at 5:22 am
TravisDBA (9/9/2010)
da-zero (9/9/2010)
TravisDBA (9/9/2010)
free_mascot (9/9/2010)
Yes, me too worng....The correct answer is none. As though resource database is readonly we can move it along with master.
In SQL Server 2008, the Resource...
September 16, 2010 at 5:14 am
As others have said, the question would have been better if the step dropping the constraint had been omitted.
September 16, 2010 at 5:05 am
Jeff Moden (9/16/2010)
Heh... what did you expect? Some of us read both. 😉
Ah true 🙂
September 16, 2010 at 4:38 am
GilaMonster (9/16/2010)
The day can only improve.
Dunno about that.
Trust me - I'm psychic 😀
September 16, 2010 at 3:26 am
Mark Enloe (9/15/2010)
September 16, 2010 at 2:58 am
GilaMonster (9/16/2010)
WayneS (9/16/2010)
But Gail, you know that there are so many other people that truly appreciate you. Just ignore the ID 10 T's and help those that appreciate it.
(...) Sets...
September 16, 2010 at 2:52 am
Viewing 15 posts - 2,656 through 2,670 (of 8,416 total)