Viewing 15 posts - 3,376 through 3,390 (of 6,036 total)
It's bcp thing.
I've got similar problem recently.
My reporting procedure created and populated table #Result.
Last statement was
SELECT * FROM #RESULT
Depending on parameters (mainly @ReportNo) table #Report had different columns.
Everything worked...
October 24, 2007 at 5:14 am
When I was sick I was better.
:hehe:
Return to the original version:
[Code]
IF OBJECT_ID('dbo.fnAddWeekdays_Sergiy','fn') IS NOT NULL
DROP FUNCTION dbo.fnAddWeekdays_Sergiy
GO
CREATE FUNCTION dbo.fnAddWeekdays_Sergiy (@Start DATETIME, @Days INT)
RETURNS DATETIME
AS
BEGIN
DECLARE @End DATETIME
...
October 24, 2007 at 4:42 am
hot2use (10/24/2007)
I'm not sure if this is what you are looking for ...
SQL Server Management Studio just does not have Taskpad at all.
That's negative, not positive side of this...
October 24, 2007 at 2:14 am
Tomm Carr (10/23/2007)
October 23, 2007 at 8:34 pm
[Code]select dbo.BizDaysAdd ('2007-10-20', 260) -- should be '2008-10-20' (52*5=260)
[/Code]
Actually 1 year normally contains 52 weeks AND 1 day (2008 contains 52 weeks and 2 days).
😀
should be '2008-10-18' (52*5=260)
October 23, 2007 at 8:23 pm
Tomm Carr (10/23/2007)
Ok, fine. If you don't want to take the trouble to tweak it, I guess I will. It is my code, I suppose, so who better?
If we compare...
October 23, 2007 at 4:16 pm
Chris Hedgate (7/25/2005)
You will not see this error in SQL Server 2005, since SQL Server 2005 does not have Enterprise Manager.
No applications - no errors.
I should think about this way...
October 23, 2007 at 4:00 pm
tjames (10/23/2007)
CREATE TRIGGER trg_#1 ON dbo.table1
FOR UPDATE
AS
IF UPDATE( dtmDateApproved)
BEGIN
INSERT INTO tbl_table2(table1ID)
SELECT DISTINCT...
October 23, 2007 at 3:10 pm
Tomm Carr (10/23/2007)
On my server it means Monday, not Sunday.
That's fine, use the values that match your server or DateName() instead. Remember, these routines were developed to meet in-house needs....
October 23, 2007 at 1:52 pm
Michael Meierruth (10/23/2007)
Sergiy (10/22/2007)
if DatePart( dw, @StartDate ) = 1 -- SundayOn my server it means Monday, not Sunday.
I think...
October 23, 2007 at 5:56 am
Peter Larsson (10/23/2007)
Jeff, excellent code but I think you should start using QUOTENAME function for those having brackets, spaces or even single quotes in their table/column names.
It doesn't make any...
October 23, 2007 at 12:43 am
if DatePart( dw, @StartDate ) = 1 -- Sunday
On my server it means Monday, not Sunday.
October 22, 2007 at 8:48 pm
I said - I could not test.
There was a typo in the formula.
Also I corrected small logical error in the code:
[Code]
IF OBJECT_ID('dbo.fnAddWeekdays_Sergiy','fn') IS NOT NULL
DROP FUNCTION dbo.fnAddWeekdays_Sergiy
GO
CREATE FUNCTION dbo.fnAddWeekdays_Sergiy (@Start...
October 22, 2007 at 7:39 pm
David McFarland (10/22/2007)
The clustered index scan is basically the same thing, as the leaf level nodes are simply the data.
Then what's is "not-basical" difference you aware of?
This is a...
October 22, 2007 at 7:12 pm
David McFarland (10/22/2007)
Sergiy (10/22/2007)
Do you know the difference between table scan and clustered index scan?
Sure do (you really don't want to go here, but feel free to continue). Do you...
October 22, 2007 at 5:44 pm
Viewing 15 posts - 3,376 through 3,390 (of 6,036 total)