Alter table1 add column1 datatype

Update t1

set Column1 = t2.Column1

From Table1 t1

JOIN Table2 t2 on t1.UniqueID = t2.UniqueID

Table1 is the table you're adding the column (column1) to.  Datatype is the type of...

bit is the way to go.  It works just fine with windows controls (although "null" can be trickier) and other coding.

Great article...I'm going to have to set this up.  Analysis services can be a bit of a drag to optimize, and this sounds like a great tool to help in...

Aaron,

I'm confused as to how this executes all the strings in the temp table.  It appears to execute 3 string variables, so the max length would be 24,000.  Can you...

There is a fascinating book on this topic; called "The Evolution of Useful Things":

http://www.amazon.com/exec/obidos/tg/detail/-/0679740392/002-7551932-7452055?v=glance

The author shows how a lot of the things we use today came to be.  In studying...

I've run into this same problem using DTS create object; so I don't know if that's going to help you.  As pointed out above, the order of table creation is...

bergshawn,

AKM's code is the most optimal performance wise, but the tradeoff is a potential maintenence nightmare (that's your "prize" for writing less code).

Using the case statement is extremely un-optimal, as...

--------------

Now the next topic would be - If you store the delimited text in a column, what's the best way to parse the individual items back out?

--------------

The answer for java would...

Optionaly, you can use the "Dynamic Properties Task" in DTS.  This isn't nearly as sophisticated as what you can do with ActiveX, but it's sufficient for setting connection variables.

I haven't...

Yeah, I "ran" it (IE: verified it would compile) "Sans the Oracle specific functions" as I said in my post. 

Very interesting on the...

Well I'm not sure now..I think maybe they should have been rights. 

Right join means keep all records from the "right" table whether or not they match a record in...

Chris,

If it means anything, I thought your answer was lucid and to the point; sukhoi must be crabby because he's writing crappy code. 

Sans the Oracle specific functions, this query...

"I Have 4 table and I need to find out the list of the rows that are present in Table A and doesn’t exist in...

It's impossible to say, based on your code.  There's ambiguity about where the IF Else begins and ends.  Always use the form:

if condition

 BEGIN

  do something

 END

Else

 BEGIN

  so something else

 END

If you don't use...

No, don't do that...use left joins instead for performance reasons.

Select a.*

From TableA a

LEFT JOIN TableB b on a.PK = b.PK

LEFT JOIN TableC c on a.PK = c.PK

LEFT JOIN TableD...