Viewing 15 posts - 53,956 through 53,970 (of 59,065 total)
In my book you should be getting 00.0000000000000000000000000000001 which is 1.0E-31. Anything else is a lie.
Yes... I agree... in DECIMAL math, you would be absolutely correct. But FLOAT does...
November 24, 2007 at 8:51 am
No, no... (just making sure)... I said you "could" use a cursor... it wasn't a recommendation. 😀
Perhaps an example of the type of validation I'm talking about is required...
So...
November 23, 2007 at 10:12 pm
Moreover you are newbie to this site.
Ummmm... that's a bit arrogant on your part... you're a bit of a newbie yourself and, so far, I've not seen you answer...
November 23, 2007 at 10:07 pm
Yes... pretty much all of that and more... for example, you'll never see me use a While Loop to create a list of contiguous dates... I'll always use a Tally...
November 23, 2007 at 9:53 pm
But when I'v used this method, the result of the select * query was unexploitable like the result can appear in a cmd window.
Sure, I can help... but I don't...
November 23, 2007 at 5:22 pm
Now, those sound like some pretty strange places... Senior Sybase DBA with 0 days experience... they must have had a death wish. 😉
November 23, 2007 at 5:19 pm
Randy,
There's just a huge number of options because you don't have any triggers. For example, IF you're staging table contained ALL the customers (including ones that are no longer...
November 23, 2007 at 5:14 pm
Output from a stored procedure does not have a PK Constraint and cannot be indexed unless first materialized as a table. So, it depends...
November 23, 2007 at 4:32 pm
Yep... you're right... database sure can't do any of that And, I'm sure that the VB program does it with much more speed...
Everyone does realize that my statement...
November 23, 2007 at 4:22 pm
I wish I knew enough about replication to help you out of the pickle you're in...
Thanks for the feedback.
November 23, 2007 at 4:19 pm
Then, you're probably going to be ok...
November 23, 2007 at 4:15 pm
karthikeyan (11/22/2007)
Really i dont know can you tell me how does this site is running ? Atleast they...
November 23, 2007 at 4:13 pm
So long as they don't change it to decimal math... that would just slow it down 😀
November 23, 2007 at 4:08 pm
Is this the constraint that you cannot delete?
if exists (select * from dbo.sysobjects where name = 'FK_tdta_ebMatrix_tkey_eBaum')
ALTER TABLE [dbo].[tdta_EntscheidungsbaumMatrix] DROP CONSTRAINT FK_tdta_ebMatrix_tkey_eBaum
GO
If so, what happens when you manually run the...
November 23, 2007 at 4:06 pm
Viewing 15 posts - 53,956 through 53,970 (of 59,065 total)