Viewing 15 posts - 5,701 through 5,715 (of 6,676 total)
Based upon your table definitions and sample data (thanks) this will work.
Update #propval
Set str_val = (Select CustomerCode
...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 7, 2009 at 11:43 am
And, if you really think you have to use nested cursors - review the following article that describes a couple of ways of optimizing cursor operations:
http://sqlblog.com/blogs/hugo_kornelis/archive/2007/11/21/curious-cursor-optimization-options.aspx
As others have already said...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 7, 2009 at 11:12 am
Jeff Moden (1/6/2009)
Crud... I was just reaching for the bucket o' fresh pork chops... 😛
Fresh? You want to use fresh chops? Come on - you need to age...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 6, 2009 at 4:11 pm
Open the Maintenance folder in Object Explorer - right click on your maintenance plan and view history. This history will show you what step in the maintenance plan failed.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 6, 2009 at 2:08 pm
You can use EXCEPT to compare your tables:
SELECT {columns}
FROM db1.dbo.tablea
EXCEPT
SELECT {list of columns that match other select}
FROM db2.dbo.tableb
This will return a list of rows...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 6, 2009 at 2:05 pm
Review the article I link to in my signature on how to post a question to get a better/faster answer. Providing the create statements, insert statements for sample data...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 6, 2009 at 1:34 pm
I cannot believe you recommended a cursor to solve this issue. One of the previous posters already posted a way to do this using EXCEPT.
If you want to see...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 6, 2009 at 1:27 pm
You can get the object using the objectid column - but, if you want the actual stored procedure call you need to get it from a trace.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 5, 2009 at 5:07 pm
I have to agree with Jack - this really does not make sense. The cursor is defined to select two values (Product and Variance).
You then create a cursor over...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 5, 2009 at 4:57 pm
GilaMonster (1/5/2009)
Meteor hits the server room.
Maybe meteors are a bigger threat for you, but for me I am more worried about the aircraft taking off and landing next to the...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 5, 2009 at 2:30 pm
You can use the information schema views or the system table sys.columns.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 5, 2009 at 2:17 pm
I use Redgates SQL Compare to perform these kinds of comparisons. There are other tools available that do the same thing, some are even free.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 5, 2009 at 2:16 pm
Lookup CASE statement in BOL. General outline is:
CASE WHEN {expression} THEN {value}
WHEN {expression} THEN {value}
ELSE {value}
END
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 5, 2009 at 2:13 pm
SQLBOT (1/5/2009)
Will a restore work for getting the backup into a readable active log?~BOT
Nope, a restore will restore the database and apply the changes stored in the transaction log backup....
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 5, 2009 at 1:47 pm
It is not a Kerberos issue - please read the document I linked to for further information. On Win2008/SQL2008 you cannot just add a user to the local Administrator...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 5, 2009 at 9:30 am
Viewing 15 posts - 5,701 through 5,715 (of 6,676 total)