Hi everyone, The code that call the function looks like this: -- Update SafetyStock UPDATE #ServiceLevel SET SafetyStock =...
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...
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"> quote:<br...
Hi Madhivanan<br /><br />I ran your script and it works cool. You only need to add <font color="blue">order by colorder</font id="blue">, or it could...
Thanks Frank! Will try that. Sanette SQL Developer JustEnough Software Corporation Walking on water and coding of a spec is easy, as long as both...
Thanks for all the replies. Please find the sql code where I have this problem. Maybe this will shed some light on my problem. It sometimes happen...
Yes I know, but how can I trap for this? SQL Developer JustEnough Software Corporation Walking on water and coding of a spec is easy, as long as...
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...
There will be no cascaded deletes here. I am just worried that if I do drop and recreate the PK it will have an impact on the speed of the procedure....
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...
Thanks guys!!! All sorted. Sanette SQL Developer JustEnough Software Corporation Walking on water and coding of a spec is easy, as long as both...
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. Thanks for the advice. I managed to write the following code and thought I would share it with you. DECLARE @len int , @string...
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....
Thanks Satya, so just to confirm if I run DBCC CHECKDB it will fix the defragmentation of the files? Has it got an overhead on the server or can I...
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...
Thank you Bambola!<br /><br />Why could I not think of this!!!! <img src='/community/emoticons/emotion-1.gif' alt=':-)' /><br /><br />Sanette
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...
Twan, Is COALESCE undocumented? I found it in BOL. Sanette SQL Developer JustEnough Software Corporation Walking on water and coding of a spec is...
Separate names with a comma.
