Beware, recursive CTEs can perform poorly. See here[/url]

A linked server maybe? See here

3. Encryption.

Two options I can think of:

1. Put the pasword in another table, (along with a FK back to the logins table) and alter permissions on this table to control...

See the section on string splitting in Jeff Moden's tally table article. Link is in my sig below

Edit: Apologies I see that somone has already pointed you to that article...

No, but I...

lmu92 (2/8/2010)

Ooops!

Could...

Oh yeah, plenty of s*** round here :-). Gotta make sure I use the right sample, or could recreate...

My hamster just fell through a distortion in the space-time continuum. Is it possible to get him back using DBCC TIMEWARP. Please help, he was my best friend.

Hmm! Sounds familiar 😛

Yes, use the DATEADD function, see: http://msdn.microsoft.com/en-us/library/ms186819.aspx

Edit: Sorry, misread your...

Excellent! :w00t:

Paul,

Thanks. Here's hoping I get a chance to install 2008 soon.

How would a LEFT OUTER JOIN perform compared to the MERGE?

(for us lesser mortals trapped with older versions :-))

SELECT

t1.TranID, t1.TranDate, t1.TranCode, t1.Amount

from

#Transactions t1

LEFT OUTER JOIN

#VendorExport t2 on...

Good, glad you understand that you can't update an integer column with a character value.

In general, any column can contain a NULL unless specifically prevented in the table definition...