mw112009 (2/12/2016)

---

Wait, if you do not know how to do this, and you do not want to try to follow suggestions of others on how to do this, how can...

It's them. They asked the same question (or extremely close to it) four years ago.

I have similar code I have written myself for use at work. What I wrote was meant to convert VARCHAR columns to NVARCHAR and move the data from old...

Grumpy DBA (2/12/2016)

---

"Give a man a fish and he eats for a day. Teach a man how to fish and he eats for a lifetime."

I believe Brandie was trying...

Easy Peasy. Thanks.

Jacob Wilkins (2/10/2016)

---

Yeah, that means that the file(s) with IsPresent=0 can't be restored from that backup. Only time I've seen that is when you do a backup and specify particular...

Just looking for confirmation on what I am seeing here: http://www.sqlservercentral.com/Forums/Topic1760134-391-1.aspx.

Ed Wagner (2/9/2016)

---

Lynn Pettis (2/9/2016)

---

Phil Parkin (2/9/2016)

---

Lynn Pettis (2/9/2016)

---

Who has the Crystal Ball??

Silver Spoon(2/9/2016)

---

I Get the following error when attempting to Configure Distribution on a SQL Server 2014 Machine

ServerName\Instance Cannot...

Phil Parkin (2/9/2016)

---

Lynn Pettis (2/9/2016)

---

Who has the Crystal Ball??

Silver Spoon(2/9/2016)

---

I Get the following error when attempting to Configure Distribution on a SQL Server 2014 Machine

ServerName\Instance Cannot be configured for publishing...

Who has the Crystal Ball??

Silver Spoon(2/9/2016)

---

I Get the following error when attempting to Configure Distribution on a SQL Server 2014 Machine

ServerName\Instance Cannot be configured for publishing and distribution. Publishing and...

The snarky answer based on everything you posted above is: You are doing something wrong.

How about walking us through the steps you are using, that may give someone a better...

Try this:

SELECT

max(case when a.Type_Id = 6 then a.Description end) As PROD,

max(case when a.Type_Id = 98 then a.Description end) As R,

...

jasona.work (2/5/2016)

---

So the other day I was paying bills, and got curious about my electric bill. It was easily 2x what it had been last year at the same...

Michael L John (2/4/2016)

---

Actually, the way to collect the pot would be to call someone names, belittle their...

TheSQLGuru (1/29/2016)

---

Is there a performance impact to using varchar(8000) parameters? Is it that the server must reserve the memory space to possibly hold that much data each time it is...