Viewing 15 posts - 511 through 525 (of 702 total)
Jeff Moden (5/12/2009)
john.arnott (5/12/2009)
It's an interesting series of posts from the latest pork chop target.What's the link for that one, John?
http://www.sqlservercentral.com/Forums/Topic715000-338-1.aspx
May 13, 2009 at 12:11 am
It's an interesting series of posts from the latest pork chop target. I'm starting to think that the hijacking of that "you no wanna ans, don't ask" thread may...
May 12, 2009 at 7:47 pm
cAN ANYBODY EXPLAIN ME HOW THE SELECT COMMAND IS WORKING HERE TO ASSIGNING THE VALUE TO THE DIFFERENT VARIABLES DECLARED.
The first Select simply assigns @VARIABLE a value of TEST
The second...
May 12, 2009 at 12:48 am
Jeffrey Williams (5/11/2009)
Alvin Ramard (5/11/2009)
Grant Fritchey (5/11/2009)
Suffice to say....
May 11, 2009 at 4:38 pm
anu1krishna (5/11/2009)
this is not the ans of my question please dont ask question if u dont wann to give ans.//
Your original question ....
can anybody provide me the name of indian...
May 11, 2009 at 11:35 am
Here's one I've about given up on. I haven't convinced the author of a recent SSC article that it's a poor practice to do a datetime range...
May 11, 2009 at 11:12 am
m.berggren (5/11/2009)
Got it to work after many hour´s 🙂
///drop Table #custTable
create Table #custTable (num int, cat char(1) )
insert #custTable values (0,'A')
insert #custTable values (0,'A')
insert #custTable values (0,'B')
insert #custTable...
May 11, 2009 at 10:11 am
In MS SQL 2005, the likelihood of hitting millisecond values of 998 or 999 is nil. Zero. It cannot happen. So, yes you could maybe guarantee proper behavior...
May 10, 2009 at 7:59 pm
On the plus side, that tweak certainly seems to work. But I'd like to know how we can be certain it will always work. The input datetime is rounded...
May 10, 2009 at 1:06 am
It looks as though your test of my suggested modification to the function did not include changing the data table. Please notice that the end time in each row...
May 9, 2009 at 1:09 pm
It can be dangerous to use BETWEEN with time values. Does the function given in this article work for times within the last second of an intended range? I don't...
May 8, 2009 at 10:26 am
Well, you've got me stumped. Either you didn't run the entire statement including the parts that set each counter up by 1, or there's an insurmountable difference between MS...
May 7, 2009 at 2:42 pm
Jack Corbett (5/7/2009)
Lynn Pettis (5/7/2009)
May 7, 2009 at 12:31 pm
Grasshopper,
Sorry to confuse you. By saying the answer is in the "etc.", I was trying to get you to look at the overall process. Your actual results...
May 7, 2009 at 12:09 pm
The answer is in your "etc.". That is, you didn't show all the results, but I can see that regardless of whether you updated an s1 or s2...
May 7, 2009 at 9:22 am
Viewing 15 posts - 511 through 525 (of 702 total)