Where Field = '' returns all rows that have empty string.

Where Field <> '' Returns all rows that are not empty strings.

Where Field != '' same as above.

Where Field...

Agreed.. I like his solution best. But wanted to show that there are different ways to do it depending on what you need. Good luck.

I have used ErWin and its a decent tool. But I have had issues with its abilities to successfully reverse engineer nad make database changes. In general I...

There are numerous possible causes for this issue, you need to start eliminating specific items. Here are some things to check.

Check that all services are running.

Check event...

Alternate method (lots of different ways)

DECLARE @String AS VARCHAR(MAX)

SET @String = 'ABC Company, The'

SELECT @String [Original],

RIGHT(@String, len(@String) - charindex(', The', @string) - 1) + space(1) + LEFT(@String, charindex(', The', @string)...

As stated already, you could consider the attribute/value method. I have used the EAV style model before for this type of issue and entire systems. I would say...

I have never been able to figure this out, so I am interested in knowing as well, as I have always had to put it to disk. So I...

Not sure how elegant of a solution you are looking for....

But if you have the values already, just use simple math.

SELECT rating1, rating2, ((rating1 + rating2)/2) as [total]

FROM sometable.

If you...

My experience has been that the format of (column = '' or column is null) works better than the isnull(column, '') = '' method. I am not sure of...

Phillip,

I think I will need to talk to the SAN provider and see what options they have as they are probably a great source. I was looking at other...

I would agree that creating an SSIS package to import the excel and using that imported table as the source is probably the best option. A less secure...

Why are you specifically locking the records? That's typically a bad idea unless you can't adress your issue in another manner. Why not put your records into a...

Explain what you mean by graphical output?

Also need to know how is the data stored? As string text, as binary, as xml data type?

Have you looked at...

Agreed. You will need to look into Amazon and other sources for books. Also spend time with BOL and MSDN. Each of those topics is an area...

The attach command is a way to attach data and log files to a sql server. So you are basically telling it to attach a new database. Attach...