Any rows with NULL in keyVal in T2? If so, Not In will return 0 rows.

Makes sense if you think of NULL as "we don't know". "Not in"...

I recently completed a project that required cleaning up over 100-million rows of name-and-address type data. It was a mess, and the clean-up was very, very resource-hungry. But...

Scott, as a post-script:

Don't assume that your opinion, unbacked by data, is going to convince people of anything. Repeatedly asserting "Erwin>Visio" without any sort of analysis at all being...

ScottPletcher (8/1/2012)

---

GSquared (8/1/2012)

---

ScottPletcher (8/1/2012)

---

Stefan Krzywicki (8/1/2012)

---

ScottPletcher (8/1/2012)

---

...

>> every database I'm currently doing dev work in <<

A straw man, since the topic...

Usman Butt (8/2/2012)

---

@GSquared Any reason for not turning it into iTVF/iSF? I guess then the it could have been much...

It's been 10 years since I last used VB with any intensity. I just look things up online and then modify/fiddle till it does...

Script object is your best bet.

ScottPletcher (8/1/2012)

---

Stefan Krzywicki (8/1/2012)

---

ScottPletcher (8/1/2012)

---

I didn't think Visio even offered a logical data model (i.e. Entity modeling vs table modeling), I...

Here's a function I tested, and the test I used:

USE [ProofOfConcept]

GO

/****** Object: UserDefinedFunction [dbo].[InitialCapTest1] Script Date: 08/01/2012 11:20:42 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER FUNCTION [dbo].[InitialCapTest1] (@String...

You can find a list of features deprecated/being deprecated, in versions of SQL Server, here: http://msdn.microsoft.com/en-us/library/ms143729(v=sql.90).aspx

Use...

L' Eomot Inversé (8/1/2012)

---

Grant Fritchey (8/1/2012)

---

Nah, I'm sure 5 different people are going to swoop in and post once time...

Grant Fritchey (8/1/2012)

---

SQLRNNR (7/31/2012)

---

Grant Fritchey (7/31/2012)

---

I worked on a project for about three years (it was supposed to take 18 months) that still wasn't done when I left the company....

Glad I could help. You're welcome.

I use a combination of things to track changes.

First, I have a folder for each project I'm working on, and store all DDL and DML scripts for the project in...

If you turn off ANSI_NULLS settings in your query environment, you can do "X = NULL" type tests. Details here: http://msdn.microsoft.com/en-us/library/ms188048.aspx

It is strongly recommended that ANSI_NULLS be turned on,...