Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,296 through 38,310 (of 59,102 total)

RE: Simple Update using three tables. . .

donato1026 (5/20/2010)
Lowell (5/20/2010)
Donato this is how i usually update a table from multiple sources...note the commented SELECT statement so i can run the bottom portion to test before and after:
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)

May 20, 2010 at 7:39 pm

#1170556
RE: Concatenation Error

Jdoggz (5/20/2010)
Can anyone tell me what's wrong with this query:
Select (sum(Datediff(HOUR,clkIn, clkOut))+ ':' + sum(Datediff(MINUTE,clkIn, clkOut))) as "Total Hours" from History WHERE CONVERT(CHAR(10),clkIn,1) = '05/20/10'
I get the following...
--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)

May 20, 2010 at 7:16 pm

#1170546
RE: How to default Zero-length string to NULL ?

Take a look in Books Online at the NULLIF() function. It may not help directly for the load into your staging table (you do have a staging table, I...
--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)

May 20, 2010 at 6:19 pm

#1170538
RE: How to count left side nodes and right side nodes for managing a chain link(binary tree)application

Joe Celko (5/20/2010)
Let's make a simple cycle:
INSERT INTO AdjTree VALUES ('foobar', 1, 1);
Damn. I knew I was forgetting something. Thanks, Joe.
We also need to compel a root with...
--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)

May 20, 2010 at 6:01 pm

#1170533
RE: SQL to manipulate rows of data

@krenshau,
Not sure if you got notification of an additional post so trying one more time. Did the code I post solve your problem? If not, let me know...
--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)

May 20, 2010 at 5:38 pm

#1170526
RE: Comparing two rows in one table for changes in column

The code isn't actually difficult to write... the first code I wrote actually worked but there's the human perception that it does not because it looks like there are dupes...
--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)

May 20, 2010 at 5:34 pm

#1170524
RE: Are the posted questions getting worse?

CirquedeSQLeil (5/20/2010)
GilaMonster (5/20/2010)
CirquedeSQLeil (5/20/2010)
Looking for insight / opinions on this.
I was searching for the SQLSat Utah information and came across this blog. I am uncertain if it is RSS'd...
--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)

May 20, 2010 at 4:12 pm

#1170497
RE: Are the posted questions getting worse?

Jack Corbett (5/20/2010)
CirquedeSQLeil (5/20/2010)
Looking for insight / opinions on this.
I was searching for the SQLSat Utah information and came across this blog. I am uncertain if it is RSS'd...
--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)

May 20, 2010 at 4:09 pm

#1170495
RE: How to read data from file (not well formatted) with ssis

BCP and Bulk Insert really don't care how many "rows" make up a "record" or whether or not each row has the same number of "fields" so long as 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)

May 20, 2010 at 3:49 pm

#1170486
RE: DateDiff Function

Heh... dang it... I forgot to subtract a month and a day. Thanks for the feedback... I'll fix the error tonight after work.
--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)

May 20, 2010 at 7:45 am

#1170131
RE: Calculating Median and Percentiles

I haven't actually tested it but I believe that +0.0 is more effecient. At the machine language level, a simple add takes about 1-2 clock cycles... whereas a multiply...
--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)

May 20, 2010 at 7:38 am

#1170122
RE: DateDiff Function

I'm not sure why you need 3 digits for days since a month can't have more than 31 days in a month, but here's my humble take on the problem......
--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)

May 19, 2010 at 9:26 pm

#1169846
RE: How do I count the occurrences of a sequence of records

RobD1 (5/19/2010)
Once again thanks for all the help on this. I went through the posts, took the code from the cte example, changed it to use a temp table and...
--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)

May 19, 2010 at 8:35 pm

#1169835
RE: Help with Date part

rjv_rnjn (5/19/2010)
Jeff Moden (5/18/2010)
Actually, ISDATE() is very sturdy. It wasn't designed to validate date formats... it was designed to determine if a string value COULD be converted to a...
--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)

May 19, 2010 at 4:40 pm

#1169803
RE: Remove Pattern in sql query

ColdCoffee (5/19/2010)
Thanks Jeffy;
Ummm.... not to be a stick in the mud but two people in the known universe get to call me "Jeffy"... and you're not either one of them....
--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)

May 19, 2010 at 4:35 pm

#1169801

Viewing 15 posts - 38,296 through 38,310 (of 59,102 total)