GilaMonster (1/10/2014)

---

No, it's an unnecessary use. If the data is static during the day then there aren't going to be any X locks around to block the reports and so...

We have some semi-static reporting databases that run long queries. Some of them use nolock to avoid one report blocking another. In this case, the data was refreshed over night...

It might help to give specific info about your SQL version and relevant server OS version.

Yes, Table_B has 45,000 nulls in Email1, but that shouldn't be related to the 43 records. I can't see what is different about them. All 488 came from...

Ed, That gives me the 43 missing records.

"B" also gives me 445.

That makes sense. Looks like it's going to work, Thanks !

I tried something like this, and the temp table does contain the new MemID values, but get the error " Must declare the scalar variable "@MemberID"." during...

You can display all your views in SSMS "Object Explorer Detail" window, then highlight all the views you want to change. Right click and select "Script View As" -> "Drop...

Thanks, I was guessing it was something like that, but I have not found it yet. I assumed it would be on the target server where it runs, while pulling...

You can use Import/Export Wizard as Gail suggests, then when you finish setting everything, you can "SAVE" the wizard as an SSIS package that you can rerun each week.

There are...

Or maybe a SQL scheduled job that backs up the DB to a local drive, then step 2 runs a batch file to copy to DVD ??

Sql Server Integration Services (SSIS) has a lot of functions to transfer and manipulate data.

At a previous job the person doing reporting had some jobs that used Reporting Services to populate Excel sheets for users to read.

You can look up plenty of online example of CASE statements. To see what columns a table has, look in sys.columns.

select name from MyDatabase.sys.columns where OBJECT_NAME(object_id) = 'MyTable'