Backups are of a complete database or filegroup.

I would suggest creating the table(s) in the new database and, if on the same server, select the rows from the original table(s)...

Matt Whitfield (1/5/2009)

---

declare @sql varchar(4096)

set @sql = ''

select @sql = @sql + 'UPDATE [CustomerProducts] SET [RateVariance] = [RateVariance] + ' +

convert(varchar, [Variance]) + ' WHERE [' + Description +...

Based on the limited information you have provided I don't know what help you can get. Please see the links in my signature about how to post questions so...

I think you can do this a couple of ways.

1. Nest the trended table in the details table.

2. Put both tables inside a list control.

The word "thread" in Noel's post and in the quote IS a link.

Another thing you can do when analyzing a trace is to aggregate as you may be better off tuning a statement that takes 1/2 a second to run, but runs...

You do understand that your Update statement as provided will Update all CustomerProduct rows whenever the@Product variable is "YES"?

I'd do this without a cursor:

Update CP

Set RateVariance...

If the data is numeric use a numeric type, in this case integer. As has been mentioned in other posts, as soon as you go character you get data...

I also use RedGate SQLCompare, but if the databases are on the same server you can write a query using the information_schemas views and get a rough comparison of column...

Do I understand correctly that you have tried logging in with the sa account with the new password and still cannot connect?

Something like this will work:

Update table

set column = Left(column, 5) + 'B'

Where

right(column, 1) = 'P'

You want to use the CASE function. Something like this:

SELECT

[Order_Amount],

[First_Name],

[Last_Name],

[Middle_Name],

...

GilaMonster (1/5/2009)

---

RBarryYoung (1/5/2009)

---

If I could find a good article on it here at SqlServerCentral.com then I could put it in my briefcase and point posters to it. Maybe you...

Good thread, I've picked up some things that I think will help me do a better job documenting my code.

I saw this one too, and will probably start using it regularly with a comment like,...