I agree with Vladan... spend some time with Books Online...

Although I think MONEY is the correct datatype to use here, using DECIMAL(10,2) won't kill you if you don't mind...

I think you're making a big design mistake but it's your funeral...

 CREATE

PROCEDURE dbo

Rajesh,

What feeds the proc you just posted?  A GUI, a batch job, another proc? or ???

While I'm looking at this, gotta ask... did you run the SELECT through the Index Tuning Wizard, yet?

Rajesh!

Did you try it or what?

David,

Just to add to what Andy has already said... your article has provoked some pretty good conversation.  Don't ever let the occasional nasty comment deter you from writing these types...

The only reason why you think there is no performance problem on the UPDATE is because it is only updating 1 row at a time and you are comparing it's...

... and why on Earth are you using a cursor?  Do this set based...

The column is called "Month_of_file".... why are you looking for just one day?  Try this as your WHERE clause to return rows for the month of September 2006....

where...

A slightly easier to see method... if "Value1" is a column name....

SELECT REPLACE(Value1,CHAR(9),'') AS Value1

  FROM your table

"CHAR(9)" is the TAB character.

HOWEVER!!!!  If you have such characters...

Serqiy is correct... the MONEY datatype is the way to go here... the MONEY datatype takes the same as a datetime... 8 bytes and gives you 4 decimal places to...

Almost correct... You don't need to do a different owner prefix... temp tables have scope by session only.  You do not need to use a dynamic table name if the...

Why not post them here so we can all learn something?

Martin,

If the Total_1 column is any of the integer datatypes and (so it appears) that the Total_1 column is a total number of minutes worked, you may be in for a...

I think I'd use a permanent working table before I used a Global Temp table...

Sol, the confusing part of this whole question is... don't you know each user can...