Off the topic, but I see two signature in your post. :w00t:

The one highlighted above, that link doesn't work.

Finally, My Best wishes for your new blog (nice...

I guess Yes (because it works for SSIS).

For More:

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=11180

Every time I plan to...

First of all it’s SQL Server Central and you should not expect the answer for PL/SQL query here.

Secondly, few guys here work on multiple databases but its advanced PL/SQL (Oracle...

Just-In-Time 😛

You could download EVAL version from Microsoft site. That’s the authentic way of doing it.

It’s a BIG chapter in itself & few guys (consultants) earn their bread & butter just because of it :-D. Please give opportunity to some of those guys, they will...

MS SQL cursor is not a well performing solution (Oracle is somewhat better in it). Please try to achieve it with set based approach.

GSquared (12/20/2011)

---

I'm assuming you're asking me, but I'm not clear on what you're asking. XML doesn't have columns, it has elements. Is that what you mean? If...

PaulB-TheOneAndOnly (12/20/2011)

---

Dev (12/20/2011)

---

At the end of the day, if business is asking for granular data or for an aggregation nobody thought before there is little choice but hitting...

As a quick suggestion you may modify your code to match with following...

Example:

-- JOIN based deletion

USE AdventureWorks2008R2;

GO

DELETE FROM Sales.SalesPersonQuotaHistory

FROM Sales.SalesPersonQuotaHistory AS spqh

INNER JOIN Sales.SalesPerson AS sp

ON spqh.BusinessEntityID = sp.BusinessEntityID

WHERE...

Charlottecb (12/20/2011)

---

Dev (12/20/2011)

---

Charlottecb (12/20/2011)

---

Thank you Dev and GilMonster for the responses.

Since I don't know exactly what time of the day the majority of records will be loaded,...

MothInTheMachine (12/19/2011)

---

Great! Thanks Roy. I'm still confused about how I got it to show results last night with a database but maybe that's an Express thing. I appreciate the clarification....

select t1.f1, t1.f2, ...

from table1 t1

left join table2 t2 on t1.id = t2.id

where table2.id > 0 --table2.id is null

...

Charlottecb (12/20/2011)

---

Thank you Dev and GilMonster for the responses.

Since I don't know exactly what time of the day the majority of records will be loaded, I was thinking of...