Hi All, I hope there is someone out there that will be able to help me with the following problem I have. I have a function that gets called 42...
Hi All, I would like to find out if there is any command in SQL that will "ignore" any constraints on a table. Reason: I have a table with 100M...
Hi everyone, We have a calculation that uses the LOG function and fails with a "Domain Error". After investigating the calculation it was found it...
Hi All, Our Sales table has been partitioned. The partitioning is based on a range of InventoryID's. I now have a cleanup procedure that will remove...
Hi All, I am trying to use the SQRT function to calculate a value. My problem is that in some instances the value is < 0 and then SQRT does not...
Hi everyone, I need help on the following. I have a string: 'tbl_Forecast_123456_789010' and I need to extract the number fields from the string....
Hi everyone, I was told to the best way to correct this is to dump and restore the database. Is this correct or is there anything else that I can...
How do I get to the fraction portion of a float field. E.g. if the value = 10.5 I need to do a test on the .5 portion. I tried the following but...
I have a table with the following layout: CausalID BucketID Factor PromotionNumber Datestamp 1 10 0.14 ABC 10 Aug 2003 2...
I have read that it is easy if the table is on it's own Filegroup and that filegroup is backed up. We do not have any Filegroups set up (using...
Let me explain... We have an Archive table that grows by around 10 million records per day. I need to clean this table up and only keep the last 2...
Separate names with a comma.
