Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

DATETIME - 4 Expand / Collapse
Author
Message
Posted Monday, March 18, 2013 12:23 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 29, 2014 10:04 AM
Points: 2,299, Visits: 1,356
I missed it, but still a nice one... Thanks, Ron!

Not all gray hairs are Dinosaurs!
Post #1432304
Posted Monday, March 18, 2013 11:11 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, August 4, 2014 5:38 AM
Points: 945, Visits: 558
Nice question and i learned about accuracy and 2012 function(DATETIMEFROMPARTS). I don't know how this accuracy will help me in production..

What I feel is Instead of assigining values to all variables in seperate select statement,Either could have done it in single select or as shokx said straight away could written in one statement..


--
Dineshbabu
Desire to learn new things..
Post #1432471
Posted Tuesday, March 19, 2013 4:15 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Thursday, June 12, 2014 4:19 AM
Points: 701, Visits: 1,145
Thanks for the question.
Post #1432551
Posted Wednesday, March 20, 2013 1:43 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:51 PM
Points: 13,639, Visits: 10,534
Great question, had to read it a few times.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1433033
Posted Wednesday, March 20, 2013 7:06 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 8:03 AM
Points: 825, Visits: 319
I've been catching up with unanswered DATETIME... questions of late so this was an easy one.
Post #1433188
Posted Wednesday, March 27, 2013 12:37 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 2:20 PM
Points: 2,136, Visits: 870
Easy Points
Post #1435781
Posted Thursday, April 4, 2013 12:38 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 10:38 PM
Points: 1,287, Visits: 1,117
Good question !!!
Post #1438658
Posted Tuesday, April 16, 2013 1:16 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 5:20 AM
Points: 3,546, Visits: 2,651
Thanks for this question. Good one.
Post #1442618
Posted Saturday, April 20, 2013 12:08 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, July 21, 2014 3:43 AM
Points: 1,938, Visits: 1,162
Nice question and nice explanation

Malleswarareddy
I.T.Analyst
MCITP(70-451)
Post #1444684
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse