Viewing 15 posts - 826 through 840 (of 3,221 total)
Keep in mind:
A year will be a leap year if it is evenly divisible by 4 , but not 100. If a year is divisible by 4 and...
December 2, 2011 at 12:24 pm
To assist others in assisting you please post the table definition, some sample data. You can do this quickly and easily by clicking on the first link of my...
December 2, 2011 at 11:41 am
Try this:
DECLARE @d DECIMAL(18,6)
SET @d = 73.190002
SELECT CAST(CAST(ROUND(@D,1,2) AS VARCHAR(10)) AS DECIMAL(18,1)),CAST(@d AS dec(10,1)) AS 'OOPS'
Results:
(No column name)OOPS
73.1 ...
December 1, 2011 at 11:33 am
My wife and I are celebrating our 21st anniversary today. As part of that, I'm taking next week off of work (my third vacation since 1988), and probably won't be...
December 1, 2011 at 10:45 am
L' Eomot Inversé (11/30/2011)
Today's QotD and my response to comments on it could be taken as an object less in...
November 30, 2011 at 8:45 am
Look at the function GETUTCDATE() for example
SELECT GETUTCDATE(),GETDATE()
Results
--GETUTCDATE GETDATE
2011-11-29 00:03:56.0002011-11-28 19:03:56.003
Here...
November 28, 2011 at 5:08 pm
Nice article Roy ... now waiting for the follow up article ..
November 28, 2011 at 10:29 am
Bruce Li
It seems that I cannot declare the decimal variable with dynamic length and decimal places though. Any idea how to do this?
Jeff Moden (11/22/2011)
--------------------------------------------------------------------------------
Multiply QUANTITY in Ron's answer...
November 27, 2011 at 9:52 pm
cengland0 (11/27/2011)
Don't you hate it when the explanation says, "Despite what BOL says..."It should either be mentioned in BOL or do what the BOL says.
Heck no one is perfect, and...
November 27, 2011 at 9:33 pm
Can you post your stored procedure and the items you want to incorporate within that SP ? In this fashion someone will be able to assist you....
November 27, 2011 at 4:25 pm
Viewing 15 posts - 826 through 840 (of 3,221 total)