It looks like @@rowcount equals the count from mapRiskMeasure.  In other words, @count1 = @count2.  There does not seem to be any WHERE on the selections; either to fill the...

If you need a leading zero, try this: 

SELECT CASE

 WHEN LEN( DATEPART( day, '01/01/2005')) = 1

 THEN SUBSTRING( DATENAME(month, '01/01/2005'), 1, 3) + '0' + DATENAME( day, '01/01/2005')

 ELSE...

The government's money?!?!  That was one of the main points; its YOUR money. 

On April 17th of this year, you finally paid off the...

Not sure.  It looks like "tp.ttype_id=tt.ttype_id" might have two t's for type_id. 

You may want to run this select on its own, (rather than putting it into #TempTable) and see...

Try this: 

SELECT SUBSTRING( DATENAME(month, GETDATE()), 1, 3) + CONVERT( varchar(4), DATEPART( day, GETDATE()))

Try this in query analyzer and I think you will see your difficulty: 

SELECT CONVERT( money, '349') /100

SELECT '349' / 100 

You probably want to convert your Col011 before...

What little I know of copyright laws makes it even more sickening.  If I am company and have a trademark and you are small company, (say a gas station) and...

Any society that would give up a little liberty to gain a little security will deserve neither and lose both.

Benjamin Franklin 

Can you post a bit of your code?  You seem to inserting the decimal and that may involve a ROUNDing function. 

Thanks

Too funny.  The Democrats ran the show for 40 years - no dictatorship there.... And isn't everyone happy with the results? 

My silly walk needs work too..., where do you...

Boy, we forget the 90's quick.  I worked for one company that threw the most lavish parties you have ever seen!  Now they are down to less than 1/3 their...

'zactly Frank.  This is very perplexing.  Even CASTing MyDecimal as its own datatype works... 

I have forwarded this thread to our DBA.  We deal with different numeric datatypes all the...

I like that function!  Did that come with SQL Server 2005? 

Have you looked at any appropriations bills lately?  They are wieghed down with lots of extras.  I did not vote for this..., did you? 

If I'm not mistaken, (been there, done this...) you don't have much recourse.  The rollback is VERY important to SQL Server, (understandable).  Even if you turn off the machine and...