If you decide to go with a table - then using a 3 character mnemonic as the key value would be my approach. That way, you have the mnemonic...

According to this document http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx - I don't see where you cannot do any of the things you are trying to do.

I have used all of those items in the...

Is it possible that the reports are exceeding the limitations of Excel? How many rows are being returned for these salesmen?

Can you explain what you mean by 'database refresh'? I have no idea what that means.

BTW - why did you post this same message in two separate forums?

Jack Corbett (4/23/2009)

---

Oh man, I was hoping for some kind of, this book was great I highly recommend it answer. Although I'm with Brent Ozar on this one. ...

Resources to learn powershell - well, let's see...there's that thing called google...that thing called my time...and I just sort of put them together.

Yep, nothing but my time (well, actually the...

Instead of doing this through a SQL query run through SSMS - I would use a combination of powershell and sqlcmd.

Example:

PS> $servers = get-content c:\temp\servers.txt

PS> $servers | % {sqlcmd -S...

Try disabling anonymous logins in IIS for those sites and enabling windows integrated authentication.

Did you try Gail's suggestion to see what is actually in each column?

Actually, Bob's process will not work with a temp table because a temp table created in a procedure would no longer exist when the procedure terminates. You would have...

Your problem here is going to be the dynamic columns. If the columns were fixed, then you could use the following:

CREATE TABLE #temp2 (define all the columns here);

INSERT INTO...

Again, you should know about the OUTPUT feature of the INSERT and UPDATE statements. Using this will allow you to create a procedure that could update multiple records in...

In SQL Server the datetime datatype (that is what you are using, right?) is stored as a double. This number is the number of days since 1900-01-01 where this...

I am curious - what features in SSIS Enterprise do you see as vital to your systems and processes? I am running several processes using Standard Edition with no...

Okay, there are a couple of things you should know. First, when checking dates and date ranges we need to strip the time portion from the input parameters to...