Chris Harshman (10/21/2016)

---

Maybe I'm missing something, I'd...

Ed Wagner (10/21/2016)

---

Manic Star (10/21/2016)

---

Ray K (10/21/2016)

---

Ed Wagner (10/21/2016)

---

Revenant (10/21/2016)

---

Ed Wagner (10/21/2016)

---

djj (10/21/2016)

---

Luis Cazares (10/21/2016)

---

crookj (10/21/2016)

---

Hugo Kornelis (10/21/2016)

---

Ed Wagner (10/21/2016)

---

BWFC (10/21/2016)

---

Ed Wagner (10/21/2016)

---

djj (10/21/2016)

---

Stuart Davies (10/21/2016)

---

Ed Wagner (10/20/2016)

---

TomThomson (10/20/2016)

---

Ray K...

First, be sure to understand backup and restore. Then make sure that's working fine.

Then, get this book (the pdf is free): http://www.sqlservercentral.com/articles/books/76296/

So, the question remains. Do you need any more help?

The information that you need come from the system views (sys.schemas, sys.tables, sys.columns, sys.types) or the information_schema views (which I...

GUI

BLandry474 (10/21/2016)

---

My apologies Brandi - you're right - you did say that in your edit. However, you also just addressed constraining the columns entry when I asked a very...

Perhaps something like this can help you start?

SELECT 'SELECT * FROM ' + t.TABLE_SCHEMA + '.' + t.TABLE_NAME

+ ' WHERE ' + STUFF(( SELECT ' OR...

PasLe Choix (10/20/2016)

---

My code again here:

Select CutoffMonth,

ROW_NUMBER() OVER(ORDER BY [ProjectName] ASC) AS ProjectID, [Employee Number],

'Nov 2015',

'Dec 2015',

'Jan 2016',

TotalHRSWORKED, HourlyRate

From (Select distinct

CutoffMonth,

[ProjectName],

[Employee Number],

SUM(CASE WHEN [Mois Imputé:Cutoff Month]='Nov 2015' THEN...

I have...

Street

Here's an example on what you might need. The explanation can be found in the following article:

http://www.sqlservercentral.com/articles/T-SQL/63681/

It's incomplete and untested, so you need to complete it and test the results...

That's a weird requirement. What's the story behind this?

Here's a shorter alternative which I expect that might be a bit faster (not much).

WITH numbers AS

(

SELECT ROW_NUMBER()...

Brandie Tarvin (10/20/2016)

---

Luis Cazares (10/20/2016)

---

mister.magoo (10/20/2016)

---

I was wondering whether all this complexity is worth it...just to run a dtsx? But I'm not a DBA, so I assume this is a...

You can check this: https://www.microsoft.com/en-us/sql-server/sql-server-editions

That also links to the more detailed document here: https://msdn.microsoft.com/en-us/library/cc645993.aspx

Brandie Tarvin (10/20/2016)

---

jasona.work (10/20/2016)

---

Brandie Tarvin (10/20/2016)

---

I don't quite feel your pain, but I'm in the midst of migrating a handful of DBs to a new server. One is ~134GB...