Right-click -> tasks -> Import Data. It's below 'generate scripts'

I strongly recommend, with only a few columns like you appear to have, to avoid dynamic SQL.

It's easy to get wrong, and it's prone to horrible security flaws (used,...

Luis Cazares (4/21/2016)

---

BLOB_EATER (4/21/2016)

---

Luis Cazares (4/21/2016)

---

Brandie Tarvin (4/21/2016)

---

Okay, this is weird. I went searching for an error I got in SSIS 2012 and the first thread that pops up in...

So it will tell you what row, the row in the table with the matching username to the row in the spreadsheet.

In that case, import the spreadsheet into a database...

IIF was added in SQL 2014, but in earlier versions you'd use CASE (IF is control flow)

CASE WHEN [PDT_ORG_4_CDA LIKE 'X%'

...

Oh, so what, in the spreadsheet tells you what row in the table the new email address belongs to?

You can't parameterise column names.

If you have a small number of options, separate queries (or better separate procedures). Since the query implies there are only a few columns in the...

Try this

DECLARE @CurrentDate DATETIME = GETDATE() --'2016-01-01'

select DATEADD(qq,1,DATEADD(yy,DATEDIFF(yy,0,DATEADD(qq,-1,@CurrentDate)),0))

What's the definition of the table and where is the list of new values?

The book I linked should have restore details as well.

I'll go for a nice round number.

13.0.1600

(or if you want it expressed to 4 numbers, 13.0.1600.00)

Azure VM loaded with server 2012 R2. The uninstallers and upgrades often tend not to work 100% effectively on CTPs and RCs.

As for what DB, depends what I'm doing. If...

Try using sys.dm_exec_text_query_plan instead of sys.dm_exec_query_plan. You get the same plan back, but it's a varchar/nvarchar type, not xml, and so avoids that error.

And again, that's not going to be...

A word of caution. Scalar functions can be horrible for query performance. If you're planning on using that function within another query, you're likely to end up with a really...

Ed Wagner (4/20/2016)

---

GilaMonster (4/20/2016)

---

Ed Wagner (4/19/2016)

---

Are you...