If you took the time to do a little research in Books Online, you would probably have been able to figure this one out yourself. Please take the time...

Just a follow-up. I will now be spending one or more hours moving a column back to its original position in the row in seven tables. ...

Arrrggggg!

Have you tried any of the solutions provided?

Simple answer, no.

The question I have is why would you exclude any table(s) from the backup?

Just for giggles (plus I need to keep SQL Server fresh in my mind):

create table #foo(id int, name varchar(200), [state] varchar(90), varchar(450))

insert into #foo

SELECT 1, 'JAMES',...

I have found backups to network shares to be somewhat problematic. I haven't had any real issues with restores from network locations, except they can take longer under heavy...

I have posted my resume on monster.com, linkedin.com, sqlpass.org, and a few other sites. Unfortunately, most of the calls I have gotten are not SQL oriented or have been...

I guess I am missing how the business reason behind what you are doing isn't meshing with your fruit analogy.

Using analogies doesn't always help us help you solve your problem.

Personally, I don't care about how many are beneath me in the rankings. It is immaterial since there are over 1.25 million registered users on SSC. Many maybe...

aj_jm964 (1/17/2011)

---

Lynn

Attached is an Excel of a quick screen look at waht I'm looking to get. Items in yellow/red are what I need to get from the query. All others...

aj_jm964 (1/17/2011)

---

MS SQL

Both columns can be Blank/Null or one or the other will be populated

I want to only see where both COLUMNS are Blank/Null or the document number in...

Is it possible for both of these columns to contain data or to be empty.

If both contain data, is it possible for the data to be different.

If both are empty,...

Also, as I was looking through your code, I have to ask; is this MS SQL Server code or Oracle code? The reason I ask is that the following...

First, please read the first article I reference in my signature block below. Then please provide the DDL for the table(s) (CREATE TABLE statement(s)), sample data for each table...