CONVERT:select convert(varchar(100), cast(float_field as decimal(20, 2))) from ...STRselect str(float_field, 20, 2) from ...LAST_UPD date column that contains the date of last modification for a given record. Using this you can easily write a procedure to look for tables/records that have changed since a specific date (or in the last "n" minutes). Thus you can find out for every operation available in Siebel Tools the tables it involves. Eg. you can edit the web layout of an applet, save the changes and then query the list of tables that contain records updated in the last 1-2 minutes to see where are the layout settings stored. You can apply the same method for any operations via the user interface (like adding/modifying a new contact, an employee, etc.).@Table parameter and the rowid of the record in the @Rowid parameter) by going through all the foreign keys that are pointing to the specified table and executing a query to get the count of referring records. Since this is a Transact SQL code snippet, it suggests you're running Siebel CRM on a Microsoft SQL Server (which is not the typical case ... but occurs anyway as it did with one of the clients of my company). 
Recent comments
1 day 13 hours ago
1 day 18 hours ago
3 days 1 hour ago
3 days 5 hours ago
3 days 10 hours ago
5 days 7 hours ago
1 week 8 hours ago
1 week 2 days ago
1 week 5 days ago
1 week 6 days ago