Viewing 15 posts - 3,031 through 3,045 (of 6,036 total)
Guys, it has nothing to do with reality of this world.
One of my recent projects was like this.
It was for a big company, I mean very big, bigger than a...
May 26, 2008 at 10:54 pm
Does folder "d:\W3Root\Test\" exist on the server where SQL Server is running?
May 24, 2008 at 7:43 pm
Why not just add IDENTITY column?
May 23, 2008 at 1:47 pm
Peso (5/22/2008)
Sergiy, did you test the code?
I don't think it deserves it.
It's absolutely stupid task and useless exersise.
IMHO, any DB developer who takes such task to work should be...
May 22, 2008 at 2:37 pm
helloanam (5/20/2008)
There could be better ways to do it. Try this. I think i tried to cover every situation. 🙂
Solid approach, but too much typing, as for me.
😎
-- create...
May 21, 2008 at 10:36 pm
Think a little.
Read error message again.
Look at your statement.
Find where you've got money type declaration and where you're trying to assign varchar value to it.
May 21, 2008 at 6:53 am
Jeff Moden (5/20/2008)
If I remember correctly, NOT EXISTS can actually be a bit faster in the presence of the correct index. Still, it uses correlation which is hidden RBAR.
These...
May 20, 2008 at 10:37 pm
Jeff Moden (5/20/2008)
So, what was the problem?
With 99% probablility it was empty strings.
May 20, 2008 at 8:15 pm
I guess should work (if you'd follow Jeff's advice I could test it):
SELECT [SystemID] , 'Maybe' as [Confirmation] , MAX(convert(datetime, RecordDate, 101)) as RecordDate
FROM [tblSystem] a
WHERE Confirmation =...
May 20, 2008 at 6:06 pm
To screw the test completely:
INSERT @t
SELECT 'A1', NULL, '12', ...
May 20, 2008 at 5:37 pm
David Lester (5/20/2008)
Just finished adding the concept to my code Jason, works like magic.Its just beautiful!! :w00t:
You should improve your testing skills.
I can see logic holes in Jason's code,...
May 20, 2008 at 4:37 pm
premnathk.chn (5/19/2008)
yes i am sure and we have also tested.
Sure you did.
Everybody does.
Of course, you wrote proven code which will decide which of threads being held by a thread currently...
May 19, 2008 at 2:17 pm
Did you ever play a scenario when 2 or more users at the VERY SAME MOMENT are trying to save a record in your table?
How your java code will know...
May 18, 2008 at 3:10 pm
Just don't forget - non-clustered indexes may reside in different filegroups then table itself.
May 15, 2008 at 10:43 pm
Viewing 15 posts - 3,031 through 3,045 (of 6,036 total)