Viewing 15 posts - 3,946 through 3,960 (of 5,394 total)
Tom.Thomson (7/16/2010)
Kanji is Japanese written with Chinese characters...these two versions of Yokogaki have different Japanese names
Thank you Tom. I thought that Japanese was Japanese, period. It's a very fascinating...
July 16, 2010 at 8:23 am
You're not doing yourself a favour on this thread.
I think you should acknowledge that there might be things that you cannot change, but can only accept and use, or refuse...
July 16, 2010 at 7:46 am
Tom.Thomson (7/16/2010)
July 16, 2010 at 7:08 am
doobya (7/16/2010)
Gianluca Sartori (7/16/2010)exactly as I would have expected based on my java experience
Funny, you are pretending to be stupid as a joke?
I don't get this one. Probably I'm missing...
July 16, 2010 at 4:28 am
doobya (7/16/2010)
Lynn Pettis (7/15/2010)
Here is what I hear from the OP:...
Yes!
and that should apply to CATCH blocks also ...
... they should never be resumptive under any circumstances
I believe this is...
July 16, 2010 at 3:42 am
Paul White NZ (7/15/2010)
Jeff Moden (7/15/2010)
Can you good folks give me an example of when IDENTITY will not work?
When you need a sequence across several tables
When you need to pre-allocate...
July 16, 2010 at 1:14 am
My bad. I ran into the same mistake...
SELECT
fo.objectId
,MAX(dd.ActualDate)
...
July 15, 2010 at 7:17 am
It's something I personally hate. If you have the choice, avoide it.
July 15, 2010 at 7:05 am
CASE shortcircuits for the first expression that matches.
Try inverting the two expressions:
SELECT
fo.objectId
,MAX(dd.ActualDate)
...
July 15, 2010 at 6:57 am
Paul White NZ (7/15/2010)
July 15, 2010 at 4:28 am
Paul White NZ (7/15/2010)
mike 57299 (7/14/2010)
Paul,Do I need to do an explicit Begin Trans / Commit to make sure there is no duplicate sequence #'s?
Mike
Hey Mike,
No - and that's...
July 15, 2010 at 2:37 am
Paul White NZ (7/14/2010)
Gianluca Sartori (7/14/2010)
I'm happy you took the time to sort it out.
It was a bit more effort that I would usually put in - but you did...
July 14, 2010 at 7:59 am
skcadavre (7/14/2010)
Something tells me that I may have just answered a homework question :Whistling:
Not sure. It's not typical quoting object names with square brackets in homework...
I could be dead wrong,...
July 14, 2010 at 6:50 am
Paul White NZ (7/14/2010)
Gianluca Sartori (7/12/2010)
This is a very tricky requirement and I did my best to solve it, with no luck.http://www.sqlservercentral.com/Forums/FindPost950057.aspx
Can somebody suggest something better? I'm totally stuck.
Sorted 🙂
That's...
July 14, 2010 at 6:47 am
Great! I was hoping you could take a look at this thread.
I first thought of a CLR aggregate because I was thinking about the second part of the problem (aggregating...
July 14, 2010 at 6:38 am
Viewing 15 posts - 3,946 through 3,960 (of 5,394 total)