Viewing 15 posts - 226 through 240 (of 3,666 total)
Lynn Pettis (10/20/2015)
Alvin Ramard (10/20/2015)
Or:
set @testTime = '23:45';
SELECT @testTime = cast(dateadd(minute, 15, cast(@testTime as time) ) as char(5));
SELECT @testTime;
Remember, the OP is working with SQL Server 2005 so no...
October 20, 2015 at 12:02 pm
Or:
declare @testTime char(5);
set @testTime = '23:45';
SELECT @testTime = cast(dateadd(minute, 15, cast(@testTime as time) ) as char(5));
SELECT @testTime;
October 20, 2015 at 11:49 am
Jack Corbett (10/20/2015)
October 20, 2015 at 8:11 am
From: http://www.sqlservercentral.com/Forums/Topic1720717-1292-4.aspx#bm1729123
ITU_dk2012 (10/19/2015)
... I think I should post this into another SSC forum because I am not getting any help over here.Thanks.
Oh I'm sure that will really help...
October 19, 2015 at 3:37 pm
Luis Cazares (10/19/2015)
ITU_dk2012 (10/19/2015)
October 19, 2015 at 1:40 pm
robert.wiglesworth (10/19/2015)
October 19, 2015 at 1:37 pm
It would help if we could see the code from the stored procedure.
October 19, 2015 at 11:34 am
Above post reminds me of a TV commercial ... from guy who worked on a time machine: today's lunch? Leftovers from tomorrow's dinner. 😀
October 19, 2015 at 9:44 am
Jeff Moden (10/18/2015)
Any "hybrid" DBAs that have...
October 19, 2015 at 9:27 am
The query does not return product information therefore all answers are WRONG! Salesorderid does not equal product!
Really need to stop posting questions where the wording is incorrect!!
October 15, 2015 at 7:16 am
An important difference between cats and dogs is how they react when punished.
Punish a dog for doing something bad and it thinks: "I'd better not do that again."
Punish a cat...
October 14, 2015 at 7:55 am
sushil_dwid (10/12/2015)
October 12, 2015 at 3:46 pm
Have you looked into the use of synonyms?
As long as you have space for 2 copies of the database on the server, I believe you could point synonym to the...
October 12, 2015 at 7:34 am
garfieldlandry (10/8/2015)
Yes, the job has no problem running. It just doesn't load the second column. There are two columns, col1 int, Col2 varchar(80).
Which question are you answering here? Remember, we're...
October 8, 2015 at 11:16 am
garfieldlandry (10/8/2015)
October 8, 2015 at 11:07 am
Viewing 15 posts - 226 through 240 (of 3,666 total)