Viewing 15 posts - 406 through 420 (of 530 total)
Sorry for butting in!
If you are dealing with last value on IDENTITY columns I would suggest using:
IDENT_CURRENT( <table_name> )
According to my book it is always the fastest one. According to...
September 18, 2003 at 4:23 am
Hmm. Reading yesterday about the complaints about SQLServer development or Administration title issue made me think that the question could belong in both topics but now it is starting to...
September 18, 2003 at 3:49 am
We can delete our own posts 🙂
Regards, Hans!
P.S If you meant topic I don't know if it is possible...
September 10, 2003 at 3:31 am
David: I've had a sligtly similar problem. With undersized DB hardware and oversized userbase. Well, not at all 4.5 k/s but a couple of hundred (which with our configuration at...
September 9, 2003 at 3:48 am
Hello!
In the script th @fs INT var will contain the OLE handle to a 'Scripting.FileSystemObject' object. (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/fsooriScriptingRun-TimeReference.asp).
@fs will contain the OLE handle to an open file (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/jsmthopentextfile.asp)
Try the method CreateTextFile...
September 2, 2003 at 3:18 am
5409045121009:
You are right. But it is NOT written in the specifications for the Update command. It say that if you reference the same table more then once, you cannot alias...
September 2, 2003 at 2:46 am
Frank:
quote:
seems to be not very smart systems
Right, it is quite an obnoxious system 🙁
(Maybe...
August 28, 2003 at 6:51 am
Hi Frank! Hi Michael!
Perfect tips 🙂 Unfortunatly for me our company have to support Excel 97 🙁 Next problem is that the legacy systems using some of the Excel files...
August 28, 2003 at 3:33 am
Hello everyone!
This is a highly interesting topic for me since it seems like everyone want Excel reports for everything. Unfortunatly for me Excel Automation does not seem to be the...
August 28, 2003 at 2:29 am
But how do you drive a horse? Can it actually be defined as a vehicle? 😛
/Hans
August 19, 2003 at 7:40 am
Note to self: Investigate the most commonly used vehicle to drive on the left side in Britan before the war of independance...
August 19, 2003 at 3:29 am
BTW Why is the author removed from the QOD? I believe this question should be totally disregarded since it quite obviously is impossible to know what answer should be the...
August 18, 2003 at 2:53 am
Hi.
Thought to also give my 2 cents independent of what your @@DATEFIRST settings are...
SELECT (DATEDIFF(d, @SD , @ED)) / 7 +
CASE WHEN ((DATEPART(dw, @SD ) + @@DATEFIRST +1)% 7 >...
July 24, 2003 at 9:05 am
mstric:
Actually trying with @startdate = '2003-05-03' and @enddate = '2003-05-31' gives 5 fridays... So it doesn't work either :/
July 24, 2003 at 6:52 am
And remember if you have an SS2k with a setting other then U.S. English, you have to verify that DATEPART for Friday actually is 6.
See BOL 'DATEFIRST':
July 24, 2003 at 2:36 am
Viewing 15 posts - 406 through 420 (of 530 total)