As both a programmer and DBA I got tired of having to deal with NULL in the code side and avoid NULLABLE columns at every turn.

I do however use...

Yes... that helps. Thank you for confirming. It just sounded odd to me having a file that is dot, space, [name]ps1

In this article you say:

Listing 6.3 Creating a file that will be used with dot-sourcing

Dot-sourcing simply means to use a period and then a space followed by the name of...

Thank you for the article. I'm not getting any results from either of the queries in listing 1. Sorry if I missed something here.

SELECT ROW_NUMBER() OVER (ORDER BY SalesOrderID) RowNumber

...

Hi Jack,

Damn database gremlins.

Now when I run the query on the Master I get no results and 156 on the DB where the tables exist and where I expect to...

Hi,

I hope you guys can help me get something straightened out here. I ran this query on the Master DB:

select f.name

, i.name

...

Seth,

Thanks. Oh... so.. simple. Gotcha. Makes sense. Just never did a clean dups by deleting them all from the original table.

Yeah, there's tons of ways to deal with dups. Still...

If you found two duplicated item_no's why did four rows get deleted? Wouldn't you want to delete just one of the duplicates so that one unique row would remain?

I must...