I think what you are going to need to do is have a separate column for each OR condition, for example:

SELECT

...

,case when...

Since you have to resort to dynamic SQL anyways, don't bother with two statements and a temp table. You can do something like:

Declare @sql varchar(max);

Set

Whether or not you use simple or full recovery model is not dependent upon any features of SQL Server....

Yes - it will generate all scripts. I do not know whether or not it can be automated - but it is easy enough to find out. Download...

Muralidharan Venkatraman (2/19/2008)

---

Hi,

My transaction log file has grown to 25GB.

I did dbcc shrinkfile which did not help much.

Pls confirm if this is the right procedure.

1. Backup the database.

2. Backup...

What you are asking about is a multi-node cluster (one cluster with three nodes). You cannot (afaik) have two separate clusters sharing a node.

With that said - yes, you...

Jason Wisdom (2/14/2008)

---

Actually, that is exactly it.

I want to duplicate the database.. EXCEPT for...

Lookup_BI (2/12/2008)

---

Peso,

Im the one who logged that topic on SQLTeam as well.I currently have got the INSERT part working with some help.Currently working on Update.

I know it is a very...

One thing you also should be aware of is that you always have the option of executing a SQL Task in your maintenance plan.

So, you don't have to use the...

Sorry - the command should be:

Use [db1]; Execute sp_updatestats;

Use [db2]; Execute sp_updatestats;

...

Just one other note: In SQL Server 2005 the system stored procedure 'sp_updatestats' has been improved to only update statistics on tables that have been modified.

If you use the maintenance...

John Morris (2/3/2008)

---

jeff.williams3188 (2/3/2008)

---

Another option is to download a trial version of SQL Compare (www.red-gate.com) and SQL Data Compare.

Build a comparison project between your two databases using SQL Compare, select...

You can also use variables in the CTE:

DECLARE @myVAR int;

SET @myVAR = 1;

;WITH myCTE (col1)

AS (SELECT col1 FROM myTABLE WHERE col2 = @myVAR)

SELECT * FROM myCTE;

Another option is to download a trial version of SQL Compare (www.red-gate.com) and SQL Data Compare.

Build a comparison project between your two databases using SQL Compare, select only those objects...

I know you stated you did not want to use third party tools, but I am assuming that is because of cost. So, visit http://www.quest.com and download...