Was this change in processing time across the board or specific to certain databases?

This msdb..backupset is equvilent to this msdb.dbo.backupset.

CELKO (4/26/2012)

---

Please post DDL, so that people do not have to guess what the keys, constraints, Declarative Referential Integrity, data types, etc. in your schema are. If you know how,...

I may be wrong, but it looks like when you are scripting from your local system that it may be defaulting to generating scripts that are targeted for SQL Server...

capn.hector (4/26/2012)

---

Lynn Pettis (4/26/2012)

---

GilaMonster (4/26/2012)

---

Lynn Pettis (4/26/2012)

---

GilaMonster (4/26/2012)

---

capn.hector (4/26/2012)

---

at least on most of his other posts i could...

GSquared (4/26/2012)

---

polkadot (4/26/2012)

---

Ok I understand what you are saying and why my query isn't working.

I need to isolate what isn't found in the result set. What comparison...

polkadot (4/26/2012)

---

Ok I understand what you are saying and why my query isn't working.

I need to isolate what isn't found in the result set. What comparison operator...

More information, still not sure what it is you are trying to do. A concrete example of what you would expect would help.

Please realize that we are volunteers and help when we can. While you are waiting, please feel free to continue working on your problem.

polkadot (4/26/2012)

---

Two part problem:

(1) For validation purposes need to compare returned int values of result set with a list of int values typed into where filter.

select system_id, name

from Validate

where system_id...

GilaMonster (4/26/2012)

---

Lynn Pettis (4/26/2012)

---

GilaMonster (4/26/2012)

---

capn.hector (4/26/2012)

---

at least on most of his other posts i could some what understand...

GilaMonster (4/26/2012)

---

Well that bears no resemblance to the code I gave you but still.

Yes, you can do it there.

if (consolidate = 1)

set @Portfolio = '+' + @Portfolio

You really,...

NO -> if consolidate =1 then @Portfolio = +@Portfolio

YES -> IF @consolidate = 1 THEN SET @Portfolios = '+' + @Portfolios

Oh, so sad. He is claiming another victim.

GilaMonster (4/26/2012)

---

capn.hector (4/26/2012)

---

at least on most of his other posts i could some what understand what the problem...