Viewing 15 posts - 421 through 435 (of 3,666 total)
Sean Lange (8/11/2015)
Alvin Ramard (8/11/2015)
Sean Lange (8/11/2015)
Alvin Ramard (8/11/2015)
Sean Lange (8/11/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]
August 11, 2015 at 9:14 am
Welsh Corgi (8/11/2015)
It lacks Transaction, try, catch etc.
It also lacks the WHILE Loop and the commit size.
DECLARE @ArchiveDate DateTime
SET @ArchiveDate = '2002-01-01'...
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]
August 11, 2015 at 9:06 am
Sean Lange (8/11/2015)
Alvin Ramard (8/11/2015)
Sean Lange (8/11/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]
August 11, 2015 at 9:04 am
Sean Lange (8/11/2015)
OMG. I just ran across this in a database from a 3rd party. There are actually 50 nvarchar(1) columns with names 1 - 50. :w00t:
ATTRIBUTE1 nvarchar(1)
ATTRIBUTE2 nvarchar(1)
.
.
.
ATTRIBUTE50 nvarchar(1)
And...
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]
August 11, 2015 at 8:55 am
Ed Wagner (8/11/2015)
Sean Lange (8/11/2015)
Ed Wagner (8/11/2015)
Here's a quote I don't think I've every seen before:
Unfortunately...
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]
August 11, 2015 at 8:45 am
Take a look at this. It may not be exactly what you need, but it's a start.
CREATE TABLE #test
(
createdon datetime,
kms_quoteorder varchar(15)
)
INSERT INTO #test VALUES ('2015-06-10 14:03:04.000',NULL)
INSERT INTO #test VALUES...
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]
August 11, 2015 at 8:41 am
Sean Lange (8/11/2015)
Ed Wagner (8/11/2015)
Here's a quote I don't think I've every seen before:
Unfortunately I get...
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]
August 11, 2015 at 8:15 am
This is a very messy query to right. If only the Rev # had a leading zero when necessary, then this would be simple.
Would also be much easier,...
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]
August 11, 2015 at 8:11 am
Ed Wagner (8/11/2015)
Here's a quote I don't think I've every seen before:
Unfortunately I get your code...
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]
August 11, 2015 at 8:07 am
What's the maximum number of digits that the number after REV can be? Will it always be an integer?
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]
August 10, 2015 at 3:51 pm
lcarrethers (8/10/2015)
and I'm expecting the max kms_quoteorder
so if there are no /REV then I should only see the number.
The /REV stands for Revision. ...
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]
August 10, 2015 at 3:34 pm
If you plan to use SSIS for more than just the basic stuff then you must take the time to learn how to use SSIS.
Break down your problem into it's...
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]
August 10, 2015 at 3:15 pm
GilaMonster (8/10/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]
August 10, 2015 at 3:05 pm
Sean Lange (8/10/2015)
SQLRNNR (8/10/2015)
Alvin Ramard (8/10/2015)
Lynn Pettis (8/10/2015)
And Silver Spoon is definitely one of them.I see Celko is trying to do some mentoring, so all will be ok.
At least until...
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]
August 10, 2015 at 3:02 pm
Overcomplicated this thread has become. Weak was the force.
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]
August 10, 2015 at 2:58 pm
Viewing 15 posts - 421 through 435 (of 3,666 total)