Phil is right - it would be a lot easier you you could change to a normalised table design.  If you're stuck with what you have, though, you can do...

Cast as something like decimal(7,2).  Don't take my word for that, though - make sure you read and understand the documentation about the decimal data type.

John

There are scripts out there that will help you with stuff like this.  Search for something like "query for tables in dependency order".

John

Yes, it's very confusing!  How does that stored procedure get invoked?  It won't just run by magic when something changes,  And don't forget - it's not the view that changes,...

Do you have any control over the structure of the ssf_widget_history table?  If so, why not just put an identity property on the checkpoint_id column, and let the table do...

Stephen

The only other thing I would say is that you need to explain to whoever owns the server that if they want you to manage it, you need...

UPDATE Timesheets
SET Timesheet_Number = STUFF(Timesheet_number,1,4,'HPCD')
WHERE Timesheet_Number LIKE 'EPCB%'
Make sure you understand what the STUFF function does before you use this in production.  You're the one...

Stephen

Yes, the advice from the previous DBA is good.  What I would do is speak to users to find our excatly what they're doing when the application is...

Also, syscomments.text is confined to 4000 characters, so large stored procedures and functions will get cut off. If the database name reference is past character 4000, you’re out...

We don't really have arrays in SQL Server.  I think your choices are to declare individual scalar variables (@ReplaceThis1, @ReplaceWith1, @ReplaceThis2, @ReplaceWith2, ...) but that also suffers from having to...

You could change your UPDATE statement so that you have lots of nested REPLACEs.  The drawback with that is that you'll need to change the code if you need to...

I think in the next version, there might be, but for now you'll need to find some way around it.  Do you not have SSMS?

John