Viewing 15 posts - 30,826 through 30,840 (of 59,102 total)
So, did the SMALLDATETIME realization and the fact that the last 30 seconds of the day are rounded up to the next day shed any light on your partitioning problem...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 8, 2012 at 8:10 am
Golden_Behzad (3/8/2012)
how to use?
Please lookup IDENTITY column in Books Online. It's nothing more than a simple autonumbering column that you would add to each table and make it the...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 8, 2012 at 8:05 am
Gianluca Sartori (3/7/2012)
--Jeff Moden
Change is inevitable... Change for the better is not.
March 8, 2012 at 7:10 am
sqlfriends (3/7/2012)
--Jeff Moden
Change is inevitable... Change for the better is not.
March 8, 2012 at 6:57 am
Careful folks. @@IDENTITY won't work the way you think it will if a trigger is involved and you should always plan on someone adding such a thing in the...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 8, 2012 at 6:39 am
SKYBVI (3/6/2012)
I have a table which has itemno,itemID,newprice,oldprice,changedate,seqid
the data is like this :-
a123 12345 5.50 2.30 2012-03-06 1
a123...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 7, 2012 at 7:55 am
Golden_Behzad (3/7/2012)
to...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 7, 2012 at 7:40 am
Nicolas BrainPowered.Net (3/7/2012)
i find this solution very loose (if not wrong) *but* it delivers the goods.after implementing the above checksum() i have successfully added a unique index over this column.
I'm...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 7, 2012 at 7:36 am
Hang on a minute while I get the egg off my face. 🙂 I saw that just before you posted and corrected my post.
--Jeff Moden
Change is inevitable... Change for the better is not.
March 7, 2012 at 6:59 am
I guess I don't understand why you need recursion for this at all. If the NEWID doesn't appear in the OLDID column, then it is a leaf level node.
{EDIT}......
--Jeff Moden
Change is inevitable... Change for the better is not.
March 7, 2012 at 6:52 am
Koen Verbeeck (3/7/2012)
[/url](if SOPA got through, this site could be taken down)
Not without due process of proper notification and the opportunity to comply. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
March 7, 2012 at 6:39 am
ssdba (3/7/2012)
Already feeling a bit relieved by the response.....though I am yet to implement it & see any difference.
Feels great to know ppl have actually gone ahead...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 7, 2012 at 6:31 am
I used to take exception to these types of articles. My thought was "Are you nuts? Why would you teach the world how to hack?"
After seeing what many...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 7, 2012 at 6:17 am
siva 20997 (3/7/2012)
I dont undertand why at the start we are using the case stament to split it into 4...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 7, 2012 at 6:05 am
Sean Lange (3/6/2012)
--Jeff Moden
Change is inevitable... Change for the better is not.
March 6, 2012 at 11:26 pm
Viewing 15 posts - 30,826 through 30,840 (of 59,102 total)