Viewing 5 posts - 1 through 5 (of 5 total)
CAST(
(RAND() * 10000 + RAND() * 10000 + RAND() * 10000 + RAND() * 10000 + RAND() * 10000) +
(RAND() * 1000 + RAND() * 1000 + RAND()...
August 20, 2010 at 1:34 am
satishseth143 (6/18/2010)
Hi All,I have a number 20.34545. I need to format to 20.34 in SSRS. Please suggest.
Thank You,
SELECT CAST(FLOOR(20.34545 * 100)/100 AS Decimal(5, 2))
June 18, 2010 at 8:49 pm
Sahasam (6/18/2010)
Hi friends,How can i calculate quarters for the past 10 years.
Thanks,
Sam
Hi Sam
Do you want calculate quarters between 2 dates
This is my code.
DECLARE @NewDate Datetime, @OldDate Datetime
SELECT @NewDate = 'Jan...
June 18, 2010 at 8:10 pm
I install sqlexpress sp1 and management studio, that's ok. Thanks for your reply.
March 22, 2006 at 5:49 pm
Thank you for your replies. I am new in MS SQL, I working with Foxpro. I upgrating my software to MS SQL. That is ok in foxpro. Now I find other...
November 21, 2005 at 12:28 am
Viewing 5 posts - 1 through 5 (of 5 total)