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...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
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;
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 20, 2015 at 11:49 am
Jack Corbett (10/20/2015)
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
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...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 19, 2015 at 3:37 pm
Luis Cazares (10/19/2015)
ITU_dk2012 (10/19/2015)
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 19, 2015 at 1:40 pm
robert.wiglesworth (10/19/2015)
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 19, 2015 at 1:37 pm
It would help if we could see the code from the stored procedure.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
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. 😀
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 19, 2015 at 9:44 am
Jeff Moden (10/18/2015)
Any "hybrid" DBAs that have...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
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!!
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
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...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 14, 2015 at 7:55 am
sushil_dwid (10/12/2015)
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
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...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
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...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 8, 2015 at 11:16 am
garfieldlandry (10/8/2015)
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 8, 2015 at 11:07 am
Viewing 15 posts - 226 through 240 (of 3,666 total)