Jeff Moden (12/21/2011)

---

Several years ago, some manager posted about...

Dev (12/22/2011)

---

Refresh your memories please 😉

Below is NON-ANSI outer join example for Oracle. Was it working for SQL Server as well?

SELECT T1.ID

FROM

T1,

T2

WHERE

T1.ID = T2.ID(+) -- OUTER...

SQLRNNR (12/21/2011)

---

Those are the old non-ansi style Outer Join references. This was deprecated in SQL 2005. The upgrade advisor in 2005 will inform you of this joins and...

I do that kind of thing through source control and DDL logs. I'm assuming you don't have those in place, so really can't help you on this one.

If it's truly limited to three levels, just take what I wrote, and add another Outer Apply to get to the data for the third level, and add that to...

If you can get SSMS to connect, it's usually okay to do so. Probably will need to use an SQL Server login since your domain login (even through VPN)...

Can this cascade more levels than that? Like a hierarchy? If so, you'll need to query it with a recursive function. Take a look at "Common Table...

Your first Inner Join goes to a derived table with no Select statment:

FROM stg_history_ira i

INNER JOIN (--dates properties became inactive

(SELECT pa.fk_property_id, s.max_date_event

FROM oe_mf_data_mart..mf_history_property_active pa, oe_mf_data_mart..mf_property p

WHERE pa.fk_property_id = p.pk_property_id)

If that...

WangcChiKaBastar (12/21/2011)

---

I explored Red Gate. My concern is more about how to maintain a proper sequence of scripts ...what goes when... if we have many drop columns and add columns...

Something like this?

IF OBJECT_ID(N'tempdb..#MyParTable') IS NOT NULL

DROP TABLE #MyParTable ;

CREATE TABLE #MyParTable

(MotherGrid VARCHAR(40),

ChildGrid VARCHAR(40),

...

David Moutray (12/21/2011)

---

That was a well considered reply, G-Squared. The point you closed with (don't use this feature unless you know what you are doing) could be extended to...

WangcChiKaBastar (12/21/2011)

---

GSquared,

I was reviewing code written by another developer and came across scenarios

where is he has been checking AND of two columns

Application ID and Application Mask

===========

..WHERE ApplicationMask & Application_ID...

Only where you need to do bitwise comparisons.

I've been working with databases and their code for about 11 years, and I've never yet needed to use one.

They're mainly used for...

David Moutray (12/21/2011)

---

GSquared (12/21/2011)

---

I've also had a few cases where dozens of stored procedures all needed the same three columns from the same two tables, and that kind of thing....

I'm not exactly expert at CLR, but I've bumbled my way through writing a text file using VB.NET's file operations just by digging through Bing searches on the subject. ...