I always find it interesting when people think of taxes as the "Government's" money. 

It's our money!  They take from us and should be accountable for spending.  They don't make it,...

To add to the confusion, (this second line errors on my server as well) I altered the third select to CAST MyDecimal to DECIMAL(2,0); its existing state...  And that ran...

Here is quick script that might help as well.  It will look up all User Tables for monitoring. 

SET NOCOUNT ON

CREATE TABLE #TableName( RowID int IDENTITY (1, 1) NOT...

Don't do a thing!  I think posting a lawyer is very humerous. 

Is there a difference in the locations of the fields between the two tables?  (i.e., does one table have a date in a location and the other table has a...

There was a good posting on "Work Days" a while back. 

I grabbed this from it: 

DECLARE @StartDate datetime,

 @EndDate datetime

SELECT @StartDate = '01/01/2005'

SELECT @EndDate = GETDATE()

SELECT...

Remi and Mike are correct.  Please disregard my idiocy.... 

#TempTables are destroyed once a stored procedure completes.  So, why are you checking for Existence ahead of time?  Does this table get created somewhere else? 

Also, if I am not...

Look up dynamic SQL on this site.  Be sure to do the following: 

Reasons to be reluctant or/and mindful of dynamic SQL can be found...

Thanks for the insights and teaching!  (My degree was NC State - not touchy-feely, even with many goofy academicians being touchy-feely).  Co-gen is still good.  If it weren't for some...

I got my undergraduate in Environmental Science and used to regulate a lot of these industries.  Government is real good at squashing the little guy, but can never seem to...

I have found this works much better and quicker in Query Analyzer than using Enterprise Manager... 

A simple bulldozer approach might be to select each type into a #TempTable and then UNION ALL into a final #TempTable for output. 

Otherwise, it sounds to me like you...

Thanks all!  This was an unusual circumstance in some of the standard code where I am contracted.  I'm a knucklehead for not seeing that directly - oil well, too close to the...

I may not be clear, but it looks like you wanted the most recent record. 

Try SELECT TOP 1 Field1, Field2... FROM Table ORDER BY Field2 

You have no WHERE...