You're not just whistling, Phil. 

I have tried every variation of CHAR(13) + CHAR(10), and every example of ECHO I could find.  No joy.

BOL is your friend:

The scope of a local variable is the batch, stored procedure, or statement block in which it is declared.

Mr. or Ms. alluded to the batch, which...

Good one.

Without cranking up QA, I think Query #1 will give you the result in the wrong order, mm-dd-yy instead of ccyymmdd like you want it.  Queries #2 and 3...

BOL for SQL Server 2000 says:  "This procedure is included for backward compatibility. Use sp_grantdbaccess."  So maybe they finally took it out in Yukon?

BOL for SQL Server 2000 says:  "This procedure is included for backward compatibility. Use sp_grantdbaccess."  So maybe they finally took it out in Yukon?

Dang.  I was hoping someone would come back with, "yep, that's a known bug".  That's how I call it, too.

declare @ReturnCode int

, @jobID uniqueidentifier

EXECUTE @ReturnCode = msdb.dbo.sp_add_job 

  @job_id = @JobID...

I would load the data into a staging table with bulk insert, then insert the date into the batch table, and finally insert the data from the staging table into...

This was posted 12/18.

I have used a lookup table.

CREATE TABLE dbo.BusinessDays (

BusinessDay datetime NOT NULL PRIMARY KEY CLUSTERED)

go

--Load the table with dates, starting with the first business day...

An INSTEAD OF trigger should work.  Check out "Designing INSTEAD OF Triggers" in BOL.

What if you used a derived table instead of a udf?

select a.id from MyTable AS a

JOIN 

(SELECT MyLastTable.id FROM MyNextTable JOIN MyLastTable ON MyNextTable.colb = MyLastTable.colb) AS b

ON a.id = b.id

I don't...

That's odd, the page redacted most of my comments.  Right before the ALTER TABLE you need to manually edit the table, deleting the rows which have dates that are not...

I have used a lookup table.

CREATE TABLE dbo.BusinessDays (

BusinessDay datetime NOT NULL PRIMARY KEY CLUSTERED)

go

Load the table with dates, starting with the first business day of the year:

TRUNCATE TABLE dbo.BusinessDays...

I agree with Herb on Advanced T-SQL for SQL Server 2000:

"http://www.bookpool.com/.x/3b9ypa4by8/sm/1893115828

Ken Henderson's "Guru" books are also very helpful.  Inside SQL Server 2000 gives good explanations on what is happening...

Thanks, all.  Silly me, I was looking for a FIPS standard at the FIPS site, http://www.itl.nist.gov/fipspubs/.

What was I thinking? 

Yep, that's what I mean.  Nothing even close to a delimiter, multiple codes on one line.  I was hoping that I wasn't the only one who needs to validate FIPS...