GilaMonster (10/28/2010)

---

I...

Hey, Jeff. If you can fit it in your suitcase, it's portable. May not work in a new system, but it's portable. @=)

FYI: Aside from Demo-titis, Grant had a pretty good presentation. Wish I could go to PASS and see the full 90 minute one.

Now I'm obsessing about my latest project, trying...

AWESOME! Time to start watching some shows! @=)

Waving to Grant across the interwebs while listening to him present on execution plans!

CirquedeSQLeil (10/28/2010)

---

I'll see you that problem and raise you a "ran out of time to...

Sean,

Thanks for pointing out that he's talking about syntax, but when I go back to read his post, he's saying ANSI is more readable than T-SQL.

I don't know why I...

Are you using PIVOT or COALESCE in your code to generate the column names?

I ask because the closest thing I've got to what you're doing sets a variable using COALESCE...

<snicker> Today's Sandra and Woo[/url] offers a reversal of the Dilbert paradigm.

Last post until I get more info from you on how you're dynamically generating your column names (code sample?) from the database.

Looks like there was an article on SSC for...

WayneS (10/27/2010)

---

3. Execute SQL task (connected to a SQL Server) runs a query with dynamic column names (based on the year being executed for). The results are stored in a...

Jez,

So you'd be doing this manually instead of scheduled as an automatic job?

Have you tried the Import / Export Wizard? It can import flat files.

Ivan, that's okay. Just please don't use text-speak like "u" and "r" in these forums....

Nope. That's a different, separate thing. You can dynamically create the file, and all its...

Odd. When I do a "SELECT current_timestamp, GetDate()", I get the exact same values. So I'm not getting the point about readability.