Viewing 15 posts - 57,331 through 57,345 (of 59,059 total)
Sorry... had posted a solution here (and deleted it) for hours that didn't take into account days that were on the weekends... I'll be right back with the correction....
October 24, 2006 at 6:05 pm
This will give you whole days... modify the "ends" of the range to do hours... also, not affected by @@DATEFIRST settings... very fast... very simple...
SELECT (DATEDIFF(dd,@StartDate,@EndDate)+1)
-(DATEDIFF(wk,@StartDate,@EndDate)*2)
...
October 24, 2006 at 5:38 pm
Also, have you looked into using sp_AddLinkedServer... it, in fact, supports links to DB2. See Books Online,
October 24, 2006 at 4:13 pm
You could use Sp_ExecuteSQL but then you'd still end up with a table variable that cannot be made to use statistics...
If it were me, I'd use a temp table instead...
October 24, 2006 at 4:09 pm
Sorry, Remi... that wasn't directed at you... I got so ticked
at the mere suggestion that such a simple data manipulation be done...
October 24, 2006 at 7:49 am
Ok... I know... "put up or shut up, Jeff"... fine
Let's see you do it any simpler in an app
October 24, 2006 at 7:20 am
I try to use my memory... but I forget... ![]()
October 24, 2006 at 6:08 am
Serqiy... You really that old ? ![]()
October 23, 2006 at 11:35 pm
Commando...
First, I gotta share the normal diatribe about your numeric sequence and forgive me while I blast the designer... if you were the designer, sorry, but not sorry...
October 23, 2006 at 11:18 pm
No sure what the "Number" parameter in Sybase is but...
There a multiple functions in SQL Server that return info about the current connection... for example... @@SPID returns the SPID of...
October 23, 2006 at 6:56 am
create an updateable passthrough view in each target database
I don't see where you said those words, but may that's what you meant... I was talking about just creating...
October 23, 2006 at 6:28 am
Yep... I missed that one... guess it's time for some sleep ![]()
October 22, 2006 at 8:15 pm
Viewing 15 posts - 57,331 through 57,345 (of 59,059 total)