The cases for and against "null" in databases is argued endlessly.

Ask the dev how he/she wants to handle known-unknowns without using nulls. If the answer is something that can...

Yep, and it looks like you beat 4chan to...

Something like this:

DECLARE @BATCHES TABLE (

BATCH_NUM int NOT NULL,

BATCH_TIME datetime NOT NULL)

INSERT INTO @BATCHES (BATCH_NUM, BATCH_TIME)

SELECT 1, '20101108 08:37:00.000' UNION ALL

SELECT 2, '20101108 09:26:12.000' UNION ALL

SELECT 3, '20101108 12:35:00.000' UNION...

Actually, what I wrote is it depends on what you're selecting from.

In order to do a Select Into, SQL has to determine data types, and potentially data sizes, from the...

Since holidays are subject to change, and in many cases are business-specific, yeah, it'll require human intervention at some level. However, just about every job I've ever had, the...

In your select query, you have a different Where clause than in the Update query. Make them match and see what you get.

Also, keep in mind that if the...

Check out the recursive CTE Microsoft has in MSDN. It's for a hierarchy crawl, which is what this is (think of the second batch ID as a child ID)....

Craig, you need to include a column name that's an SQL keyword, at the very least.

billyholliday: Ignoring Joe's usual trollishness, and Craig's humor, did my sample hierarchy crawl get you...

The best way to do this kind of this is a time table and a calendar table.

The calendar table stores days, including which ones are business days. The time...

Beat me to it! Was about to post almost the same thing.

T-SQL doesn't have a file creation command for general...

Part of the reason CLR was added into SQL 2005 is that the sp_OA procedures are a pain to...

GilaMonster (11/11/2010)

jcrawf02 (11/11/2010)

Nice sig 😉 To be perfect, should start with "Yea" instead of "'lo", and have an extra thy in "Thy spool and...

It's a multi-step AD authorization error.

When you're running it, are you running it automatically, are you running it manually from a workstation, or are you running it while using remote-desktop...

It's saying you already have T: assigned as a drive name, and then failing because of that.

First, I'm not sure if you meant to, but it looks to me like...