Did you compare the two final execution plans as well? That's where the keys to the...

Congratz Gus. I think I'd go mad doing anything for 21 years, but I'm under the understanding that it's very pleasant with the right person. Go you! :w00t:

Who gives a flight? ...

#2 is my usual method, though I would have an alteration I'd recommend. With everything going to the same final destination include a 'union all' component and have it...

Jeff Moden (11/29/2011)

---

Evil Kraig F (11/29/2011)

---

You're correct, Jeff, I'm...

Welsh Corgi (11/29/2011)

---

:w00t::hehe::w00t:

tfifield (11/29/2011)

---

I find SELECT INTO as a very handy dandy tool to create a table quickly. If I'm a bit queasy about letting a big DELETE or...

Not exactly, and without more columns I'm slightly confused. This sounds like an update statement, something you try to avoid in SSIS. If you were adding or transforming...

Yes, with exceptions. Under standard circumstances (no TDE, san encryption, etc) then yes, a non-corrupt mdf can be completely restored elsewhere. You may get slight data loss or...

You're going to want to use the FOR XML method, just without a delimited separator.

Check out this article: http://www.sqlservercentral.com/articles/FOR+XML+PATH/70203/

Denise McMillan (11/29/2011)

---

I'm having trouble getting this query to work and will appreciate any ideas.

select number, avalue, (select x.nvalue from valuestbl as x where a.number = x.number and x.number like...

SQL Dude-467553 (11/29/2011)

---

I probably am.. But, it's good because I was trying to model this using natural keys. It's just not panning out to be easy to accomplish...

DavidL (11/29/2011)

---

I am as likely to solve a problem when away from work as when I am at work. As mentioned above, walking around seems to help --...

Tristan Chiappisi (11/29/2011)

---

Hello,

I'm looking for an answer that seems relatively simple; however, my brain is blocked. I'm looking to partition my table from 365 DayOfYear (DATEPART(DY,GETDATE())) to a 3 (1095)...

Go the other way. You need to think in days off the base year.

;WITH cte AS

(SELECT '20100105' AS dt UNION ALL

SELECT '20090603' UNION ALL

SELECT '20080321' UNION ALL

SELECT '20070910')

select

DATEDIFF( dd,...

cafescott (11/29/2011)

---

Out of curiousity, what are you going to do with hard tables in a SELECT INTO when it's ran concurrently? This technique is almost explicitly used for #tmp tables...