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 1234»»»

DATETIME 2 Expand / Collapse
Author
Message
Posted Wednesday, August 1, 2012 9:26 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:58 PM
Points: 5,575, Visits: 24,827
Comments posted to this topic are about the item DATETIME 2

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1338926
Posted Wednesday, August 1, 2012 9:36 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:40 PM
Points: 6,582, Visits: 8,864
Thanks Ron... I love questions that make me think.

Wayne
Microsoft Certified Master: SQL Server 2008
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings
Post #1338932
Posted Thursday, August 2, 2012 12:18 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 10:26 AM
Points: 13,359, Visits: 10,223
Thanks, great question.

I first thought: "statement 1 doesn't return a row at all!" Then I read the question a little better




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 #1338962
Posted Thursday, August 2, 2012 1:26 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 1:10 AM
Points: 1,539, Visits: 8,136
Excellent question Ron. I had to run the code through to understand what it was doing and learned something new.

BrainDonor
Linkedin
Blog Site
Post #1338975
Posted Thursday, August 2, 2012 1:27 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 6:38 PM
Points: 1,371, Visits: 1,560
Wonderful question!
Such questions build your concepts...and keep you think while you solve them.

Keep posting such questions


~ Lokesh Vij

Guidelines for quicker answers on T-SQL question
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com

Follow me @Twitter

Post #1338976
Posted Thursday, August 2, 2012 1:35 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, July 10, 2014 7:17 AM
Points: 439, Visits: 151
Hi,

??????????
How can I choose an answer and there is statement that insert into D4 table. !!!!!!!!!!!!!!!!!!!!!!!!!!

Thanks
Post #1338981
Posted Thursday, August 2, 2012 1:37 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, March 17, 2014 6:21 AM
Points: 1,073, Visits: 6,477
Good question Ron,

Thanks!


-------------------------------------------------------------
"It takes 15 minutes to learn the game and a lifetime to master"
"Share your knowledge. It's a way to achieve immortality."


Post #1338984
Posted Thursday, August 2, 2012 1:39 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 10:26 AM
Points: 13,359, Visits: 10,223
khelloufsofiane 6183 (8/2/2012)
Hi,

??????????
How can I choose an answer and there is statement that insert into D4 table. !!!!!!!!!!!!!!!!!!!!!!!!!!

Thanks


Read the question. Read it again. Read it again and now pay special attention to the sentence enclosed in brackets.




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 #1338986
Posted Thursday, August 2, 2012 1:41 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: Yesterday @ 4:48 AM
Points: 888, Visits: 1,229
Nice question - should have read it closer as I misunderstood the insert part of the question...doh...coffee time.
Post #1338988
Posted Thursday, August 2, 2012 3:57 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: Today @ 5:06 AM
Points: 3,013, Visits: 3,211
Got me thinking - good question.
Thanks


-------------------------------
Posting Data Etiquette - Jeff Moden
Smart way to ask a question

There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
Post #1339039
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse