Viewing 15 posts - 1,246 through 1,260 (of 1,493 total)
michaeleaton 36224 (9/22/2014)
I have the following query:
;WITH CTE_LastOrder (CustomerID, LastOrderDate) As
(
SELECT CustomerID, MAX(PaymentDate) LastOrderDate
FROM [Order]
GROUP By CustomerId
)
SELECT * from dbo.Customer C
JOIN CTE_LastOrder LO ON C.CustomerId = LO.CustomerId
WHERE LO.LastOrderDate...
September 22, 2014 at 1:31 pm
crookj (9/22/2014)
SQLRNNR (9/22/2014)
crookj (9/22/2014)
Ed Wagner (9/22/2014)
TomThomson (9/22/2014)
wotd: Threadless (see [http://www.sqlservercentral.com/Forums/Topic1618108-61-1.aspx])Memorial
Service
Broker
Richer
Poorer
September 22, 2014 at 10:43 am
TomThomson (9/19/2014)
Ed Wagner (9/19/2014)
djj (9/19/2014)
PirateShip
Trawler
Net
September 19, 2014 at 12:58 pm
atultiwari.eng06 (9/17/2014)
ID Resource
119319004 ...
September 17, 2014 at 7:25 am
BWFC (9/16/2014)
TomThomson (9/15/2014)
eccentricDBA (9/15/2014)
whereisSQL? (9/15/2014)
djj (9/15/2014)
SQLRNNR (9/15/2014)
capacityMaximum
Overflow
buffer
cushion
Pillow
Sleep
September 16, 2014 at 5:25 am
SQLRNNR (9/15/2014)
djj (9/15/2014)
I am a little slow today. How do you get from Renunciation to NESTED?
Look at the number of layers of quotes. Shouldn't we renounce such a...
September 15, 2014 at 11:49 am
Thank you. I was afraid of that. I must have goofed during the restore and have my user as the owner not the admin created for the purpose.
However,...
September 15, 2014 at 10:03 am
I am a little slow today. How do you get from Renunciation to NESTED?
September 15, 2014 at 6:19 am
eccentricDBA (9/12/2014)
sing4you (9/12/2014)
crookj (9/12/2014)
whereisSQL? (9/12/2014)
Ed Wagner (9/12/2014)
djj (9/12/2014)
Ed Wagner (9/11/2014)
whereisSQL? (9/11/2014)
Ed Wagner (9/11/2014)
SQLRNNR (9/11/2014)
MaterTow
Breakdown
Communication
IP
Address
Spoof
Burlesque
Theater
District
Attorney
September 12, 2014 at 1:25 pm
Ed Wagner (9/11/2014)
whereisSQL? (9/11/2014)
Ed Wagner (9/11/2014)
SQLRNNR (9/11/2014)
MaterTow
Breakdown
Communication
IP
September 12, 2014 at 11:18 am
Sean Lange (9/11/2014)
crookj (9/11/2014)
Ed Wagner (9/11/2014)
TomThomson (9/11/2014)
djj (9/11/2014)
BWFC (9/11/2014)
SQLRNNR (9/10/2014)
Sean Lange (9/10/2014)
SQLRNNR (9/10/2014)
Sean Lange (9/10/2014)
Ed Wagner (9/10/2014)
whereisSQL? (9/10/2014)
Sean Lange (9/10/2014)
Ed Wagner (9/10/2014)
djj (9/10/2014)
TelephoneTelegraph
Pony Express
History
Lessons Learned
and promptly forgotten so we can...
September 11, 2014 at 7:59 am
BWFC (9/11/2014)
SQLRNNR (9/10/2014)
Sean Lange (9/10/2014)
SQLRNNR (9/10/2014)
Sean Lange (9/10/2014)
Ed Wagner (9/10/2014)
whereisSQL? (9/10/2014)
Sean Lange (9/10/2014)
Ed Wagner (9/10/2014)
djj (9/10/2014)
TelephoneTelegraph
Pony Express
History
Lessons Learned
and promptly forgotten so we can repeat ourselves.
Is that old age or selective...
September 11, 2014 at 5:06 am
Viewing 15 posts - 1,246 through 1,260 (of 1,493 total)