@all

Did you notice that "someone" added some new level names?

I noticed SSCoach (Gail, >15K points) and SSC-Insane (Jeff & Steve, >20K points).

@steve-2

Did I miss the announcement? Are there other new...

Hi,

anybody of you folks influenced by the volcano eruption on Iceland?

We're getting low on components supplied by a U.S. company because there are no flights to Europe since last...

The easiest way would be to to xp_cmdshell for it:

exec xp_cmdshell 'copy c:\temp\test1.txt + c:\temp\test2.txt c:\temp\test3.txt /y'

But, like with some other solutions which look simple at a first glance there...

To expand Waynes suggestion:

Instead of changing "\ n" into commas you could add another column to your spreadsheet with incrementing values and add another column with a formula that creates...

You might want to search BOL for "Database Mail [SQL Server], configuration scripts".

There are links to sample procs you could use/modify.

Step one would be to find the relevant rows in @t1. Those would be the latest selldte per TID. To find those, you can use a CTE (see BOL for...

Is Google down?

Here is a list of related web-sites that should get you started.

Please have a look at the CrossTab and DynamicCrossTab articles referenced in my signature.

I think those articles will answer any questions you have regarding this pivoting issue...

sagheeremail (4/17/2010)

---

I have similar situation but it doesn't take 24 hours for my ETL process of converting 3+ M records to finish. It takes my ETL pross less than 2...

Your requirement is not clear. The way you describe it, it should already be covered with the quirky update. If not, please be a little more descriptive.

Btw: it's 2:30am over...

Seems like the requirement calls for the quirky update (see Jeffs great article [/url] for details.

Side note: I decided to use a temp table to show the concept. As...

What exactly is your question related to SQL Server?

gregory.anderson (4/17/2010)

---

Hey guys, thanks again for everything. Just to let you know, I haven't read through Lutz's cte version of that last update yet, just read the first part of...

WayneS (4/17/2010)

---

That's what I'm talking about!

So, what the goal? 0:30?...