Brandie Tarvin (4/7/2011)

---

Wow. I wonder if they had permissions to reprint that article. I found it yesterday at Simple Talk.

Or maybe it was the guy at Simple Talk who...

Great, I am happy you found a solution. Would you mind posting what you did so others who find this post from a search engine can benefit as well?

Nope...I think you;re good...misunderstood what you were doing. You can open the package you saved out of the I/E Wizard in Visual Studio and continue to build it out using...

JimS-Indy (4/6/2011)

---

@ninja -- I'm an old guy. Be nice to me.

My issue is with scope. I lose the SS variables when the query is executed. What's the strategy for...

MySQL has the group_concat function which is one of the only places I have seen it outshine SQL Server, and I use the word outshine lightly. The lack of a...

Steve Jones - SSC Editor (4/6/2011)

---

The Transcender practice exams I have seen in the past used to contain the actual questions on the MS exams. There was a time when...

It's Mr 🙂 And my name is opc.three ... Mr or Mrs 500 is just my rating at the moment based on the number of points I have on the...

Steve Jones - SSC Editor (4/1/2011)

---

I will say that my take on the exams is that they don't prove a lot, and if you use Transcender exams or other quiz...

Too bad this in not being done on Denali (or is it? :-D) where we have the OFFSET/FETCH expression.

Here is a video that may help you understand the basic use...

Looks like an SSC article waiting to happen...

You can get IP address from a DNS lookup on the server name...if you need the whole set of IPs bound to all network adapters on the server then you'll...

I trust you're just looking for opinions and not some concrete answer...I can imagine a couple scenarios where it might be useful:

1. I could see using the approach from the...

RamSteve, please post the code you have so far so we can better assist.

Lowell offers a good tip but one I would reserve for one-off troubleshooting. If you're using connection pooling (which you should be) you may want to consider how a change...

Just to clarify, a csv file is not the same as Excel file as noted by the xls and xlsx extensions. CSV stands for Comma-Separated Value and is nothing more...