Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
deepgfishing
Starting Member
12 Posts |
 Posted - 2007-10-10 : 13:12:51
|
| Yes, I understand how it could appear that way. Let me try and formulate how to ask this question so I can get some serious responses.Thanks,deep |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2007-10-10 : 13:42:20
|
quote:
Originally posted by deepgfishing
How many different ways can this query be written.
42 different ways.Hand that in, and see what grade your professor gives you. Or, do your homework yourself.e4 d5 xd5 Nf6 |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-10 : 13:54:53
|
"Server: Msg 242, Level 16, State 3, Line 1The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.The statement has been terminated." |
|
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2007-10-10 : 14:03:00
|
| I think it's a trick question blindman.There are an infinite number of ways the query can be written, but only a very few of them will produce the desired result!Jim |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-10 : 14:10:03
|
| "There are an infinite number of ways the query can be written,"No .. no .. no ... no ... no ... if you do it that way they won't get Cached! |
|
|
|
deepgfishing
Starting Member
12 Posts |
Posted - 2007-10-10 : 14:20:16
|
| It is not a home work question. I was asked the question and I admitted to the person it stumped me. I wanted to learn something. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-10 : 14:27:24
|
Well, you probably get the drift that we don't like homework questions very much  This question has all the appearance that it was cut & pasted from the Prof.'s test  Show us your working, and ask questions for what you are stuck on, and I expect folk will give advice and guidance. I doubt you'll get anyone to write you a solution though ... not without beer and subsistence.Kristen |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2007-10-10 : 16:48:27
|
| Hint: We also don't like people editing their original post.Forum friend count dropping....emergency action required.e4 d5 xd5 Nf6 |
|
|
|
|
|
|
|
|
Stumped by SQL Question