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...

Sure... why not?  Perhaps they're trying to make a delivery route list to cut down on the number of stops that a truck has to make where street numbers and...

Since you have no Primary Key, I have to agree... might be a problem with the table design a bit...

Anyway... take the query you posted...

select count(1)

from CL_PRODUCT_ATTRIBUTE

where ATRRIBUTE_ID = @attrib_id

and...

Ok, thanks... isn't that the way?  Company buys something and that won't let you use it which forces you to revert to undocumented features in SQL Server...

This will work in...

Thanks John... appreciate the feedback!