The only solution is the same one for any lost password: Get it reset to something you know, and then copy that into the create script.

paul.barbin (1/16/2013)

---

Curious to hear from others on whether they use the MERGE command in production and what it's performance is like.

We began using it in our unit test scripts to...

I used to work for a financial services company that used SQL Server. Lots of high-volume data, etc., no problems with the databases/servers. But you don't want to...

PiMané (1/16/2013)

---

GSquared (1/16/2013)

---

From what I recal, it is expensive that way. Can cause SQL Server to page-out RAM to disk. It's been years since I used it, so...

Why multiple tables? Wouldn't it simplify things tremendously if you just partitioned the table itself?

But, really, that kind of formatting should be done in the presentation layer, not in a query. Should be formatted by the report/web page/application.

Maybe this?

DECLARE @amt VARCHAR(10) = '-5000';

SELECT CASE WHEN LEFT(@amt, 1) = '-' THEN '-'

ELSE ''

...

hakim.ali (1/16/2013)

---

On the topic of cramming for interviews, I have an experience I'd like to share. At my office, we do semi-technical phone screens before we bring the person in...

Does this do what you basically need?

IF OBJECT_ID(N'tempdb..#picu') IS NOT NULL

DROP TABLE #picu;

CREATE TABLE #picu

(EpisodeId INT,

CriticalCareLocalIdentifier...

Patric, normally I'd treat private as private. You're the only person I've ever moved it public for. And it's only because I find your particular behavior so reprehensible...

From what I recal, it is expensive that way. Can cause SQL Server to page-out RAM to disk. It's been years since I used it, so I could...

You should be able to save yourself a significant amount of work by using the Import Wizard. Right-click the database in the object explorer in SSMS, pick Tasks ->...

I'm not entirely clear on the relationships between the two tables, but I can see that what you need to do is pivot the data before you convert it to...

When you say you're copy-pasting from CSV, do you mean you're opening a CSV file in Excel, copying the contents, then pasting directly into a table via "Edit top 200...

PiMané (1/16/2013)

---

I use it also but in this example...