Viewing 15 posts - 17,821 through 17,835 (of 26,489 total)
vikas bindra (12/21/2009)
Lynn Pettis (12/21/2009)
vikas bindra (12/21/2009)
declare @lastFriday datetime
SET @lastFriday = convert(datetime,convert(varchar(10),getdate() - (datepart(w,getdate())+1),121))
select
@lastFriday - 6
,@lastFriday - 5
,@lastFriday - 4
,@lastFriday - 3
,@lastFriday - 2
,@lastFriday...
December 21, 2009 at 6:35 am
Looks like the DTC (Distributed Transaction Coordinator) is not properly configured on the two servers. We've seen this between our PeopleSoft HR and Finance servers as the application uses...
December 21, 2009 at 6:28 am
vikas bindra (12/21/2009)
declare @lastFriday datetime
SET @lastFriday = convert(datetime,convert(varchar(10),getdate() - (datepart(w,getdate())+1),121))
select
@lastFriday - 6
,@lastFriday - 5
,@lastFriday - 4
,@lastFriday - 3
,@lastFriday - 2
,@lastFriday - 1
,@lastFriday
You don't...
December 21, 2009 at 6:18 am
Since it is double posted, I'll say it again here for clarity.
What's the point?
December 21, 2009 at 6:16 am
Something like this?
declare @TestDate datetime;
set @TestDate = '2009-12-19';
select dateadd(wk,datediff(wk,0,@TestDate + 1),-9),dateadd(wk,datediff(wk,0,@TestDate + 1),-3)
set @TestDate = '2009-12-24';
select dateadd(wk,datediff(wk,0,@TestDate + 1),-9),dateadd(wk,datediff(wk,0,@TestDate + 1),-3)
December 21, 2009 at 6:03 am
Alvin Ramard (12/20/2009)
I want a hippopotamus for ChristmasOnly a hippopotamus will do
Don't want a doll, no dinky Tinker Toy
I want a hippopotamus to play with and enjoy
🙂
Cute, Alvin. Just...
December 20, 2009 at 6:42 pm
Something changed between the 16th and the 17th. Working code doesn't suddenly stop working for no reason. Something in the environment, the data, or the code changed. ...
December 18, 2009 at 8:34 pm
sureshdeenu (12/18/2009)
The job was running till Dec16 2009, it was started failing from dec 17th. pls help wht is causing the problem.
Job worked on the 16th, failed on the 17th....
December 18, 2009 at 8:18 pm
From what I can tell, haven't done it myself as we are running x64 SQL on our x64 OS's, is the 32 bit SQL will run just fine on x64...
December 18, 2009 at 1:48 pm
So, Steve, going tell us about the upgrade?
December 18, 2009 at 1:45 pm
Knowing what I know (and don't as well), I'd prefer to keep away from creating dynamic sql in the application. I would prefer to use stored procedures to encapsulate...
December 18, 2009 at 1:44 pm
Properly used CTE's are well worth considering. They can help with the development of complex queries, and if you have section of code that would use the same...
December 18, 2009 at 1:38 pm
Sample data, expected results?? The more you do to help u help you, the better answers you will get.
December 18, 2009 at 1:27 pm
That can do it. Let us know if changing to a domain accout solves the problem.
December 18, 2009 at 12:47 pm
Viewing 15 posts - 17,821 through 17,835 (of 26,489 total)