Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,766 through 33,780 (of 59,099 total)

RE: Tally Table vs. While Loop

GSquared (6/3/2011)
I'd change that "LIKE" statement to something a little more REGEX-ish.
CREATE TABLE #T (
DT CHAR(10))
INSERT INTO #T (DT)
VALUES ('1/1/11'),('01/01/2011'),('1.1.11'),('1-1-11'),('Bob');
SELECT *
FROM #T
WHERE DT LIKE '%[/.[-]]%[/.[-]]%';
Wouldn't that allow for things that...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 4, 2011 at 12:50 am

#1334004
RE: Increment a date T-SQL Statement

Jnrstevej (6/2/2011)
Brilliant i can work with that
My recommendation is that you don't so that you don't get into any bad habits. If you have one, format the dates in...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 4, 2011 at 12:00 am

#1334001
RE: Increment a date T-SQL Statement

As a bit of a sidebar, here's a blanket statement...
[font="Arial Black"]NEVER EVER USE A RECURSIVE CTE TO BUILD SEQUENTIAL SETS OF NUMBERS NO MATTER HOW SMALL THE SET MAY BE!!!...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 3, 2011 at 11:50 pm

#1334000
RE: Increment a date T-SQL Statement

skcadavre (6/3/2011)
When you post sweeping comments, you should probably include a test script that proves what you're claiming. {snip}... but your sweeping comment without any evidence doesn't change the opinions...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 3, 2011 at 11:17 pm

#1333999
RE: Two questions in mind (for genralized approach)

tfifield (6/3/2011)
Jeff Moden (5/24/2011)
sqlnaive (5/24/2011)
Unfortunately that brings me to the same point where I started. In a complex stored procedure, what should be the thumb rule for implementing temporary data...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 3, 2011 at 4:06 pm

#1333969
RE: Are the posted questions getting worse?

WayneS (6/3/2011)
Just received a wonderful PM... someone thanking me for the help I'm doing... for someone else!
Those are the best and welcome anytime. They can turn an otherwise bad...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 3, 2011 at 3:57 pm

#1333965
RE: Best way to separate "stacked" records

Bill Tidwell (6/3/2011)
When I say, "horizontal format", I mean one single record per scan. For example, in the raw-data file I get from the POS, everything is "single stacked"...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 3, 2011 at 3:50 pm

#1333962
RE: need to learn how to be a DBA

I've found that reinstalling SQL Server every 120 days is a real PITA. 😛
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 3, 2011 at 12:53 am

#1333525
RE: Database Connection Time Outs

I've found that most people are doing the wrong thing by simply increasing the timeout. Do you really want the users to wait for more than 20 seconds? ...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 2, 2011 at 5:08 pm

#1333486
RE: Best way to separate "stacked" records

Bill Tidwell (6/2/2011)
I have been handed the task of parsing (might be better to say "unstacking") records produced by a cash-register system. The register activity is logged as it...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 2, 2011 at 4:55 pm

#1333481
RE: need to learn how to be a DBA

If you have a computer at home then...
Step 1. Buy the Developer's Edition of SQL Server. It only costs about $45-50 USD and is the equivalent of the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 2, 2011 at 4:52 pm

#1333480
RE: Are the posted questions getting worse?

jcrawf02 (6/2/2011)
So, who else will be coming to SQL Saturday #75? I'm going to need to figure out how to hook up with you guys with an ancient, Twitter-impaired phone....
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 2, 2011 at 4:31 pm

#1333469
RE: Tally Table vs. While Loop

Yes, at the very least. That's correct for when the "numeric" date format is unknown. If you have dates like '1 Jan 2011' or 'January 1st, 2001' (etc),...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 2, 2011 at 4:21 pm

#1333464
RE: Tally Table vs. While Loop

jarid.lawson (6/2/2011)
I don't have a choice regarding the date data type being set to Varchar. This was set up by our application developers, and they require all fields be set...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 2, 2011 at 7:59 am

#1333118
RE: Concatinating the results of selected rows

thomas.bassett (6/1/2011)
Jeff - I am very interested in an RBAR-less solution
Declare @InFoodID int
SET @InFoodID = 2
SELECT
AnimalFood.FoodID, Animal.AnimalName
FROM
AnimalFood INNER JOIN
Animal ON AnimalFood.AnimalID = Animal.AnimalID
WHERE
...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 1, 2011 at 11:27 pm

#1332907

Viewing 15 posts - 33,766 through 33,780 (of 59,099 total)