Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,146 through 32,160 (of 59,099 total)

RE: Are the posted questions getting worse?

Jim Murphy (10/26/2011)
With outlook, my wife didn't know where I was planning to be.
BWAA-HAAA!!!! Some fellows I know would consider that to be a feature! 😛
--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)

October 26, 2011 at 11:09 pm

#1399985
RE: Converting rows to columns

Actually, that's a better decision than the VIEW. Thanks for the feedback and glad to help.
--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)

October 26, 2011 at 11:06 pm

#1399984
RE: Converting rows to columns

Sure... you'll probably need to remove the WHERE clause in the first CTE. You can use such a WHERE clause when you select from the view. Be well...
--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)

October 26, 2011 at 4:39 pm

#1399955
RE: Backups and Bandwidth Dilemma

Nope... I was going to suggest it but didn't think it would work in your situation... I though you were doing long haul stuff.
--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)

October 26, 2011 at 2:16 pm

#1399909
RE: insert and expand table according particular condition

memostone86 (10/26/2011)
Jeff Moden (10/26/2011)
@memostone86,
Are you all set on this or do you still need help?
Hello Jeff, thanks for reply. I am still working on this.
I understand your requirements and I'll...
--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)

October 26, 2011 at 10:09 am

#1399750
RE: Set based Numbering process

Why are you reposting your original post? Did you even try the code I posted?
--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)

October 26, 2011 at 10:08 am

#1399747
RE: Backups and Bandwidth Dilemma

IIRC, CDs only handle about 750MB... it would take quite a few to handle a 200GB backup. Single layer DVDs can hold a bit over 4 GB. Double...
--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)

October 26, 2011 at 7:01 am

#1399556
RE: parsing data into SQL by dash - what are my bext options ?

steveb. (10/26/2011)
I was just offering another suggestion, I am aware of the power of the tally table split. As SSIS can deal with individual rows quite effiecntly...
--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)

October 26, 2011 at 6:55 am

#1399553
RE: total inside cte

It splits the Hierarchy path back to ID's. Each ID can be a part of several "paths" and the only way to accumulate the total "cost" associated with each...
--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)

October 26, 2011 at 6:52 am

#1399551
RE: insert and expand table according particular condition

@memostone86,
Are you all set on this or do you still need help?
--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)

October 26, 2011 at 6:23 am

#1399521
RE: Storing Hexadecimal Datatypes

I guess my recommendation would be BINARY(1) and BINARY(2).
--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)

October 25, 2011 at 8:22 pm

#1399397
RE: parsing data into SQL by dash - what are my bext options ?

You can't BULK INSERT from a table simply because BULK INSERT wasn't designed to do such a thing.
What you need is a good splitter... please see the following...
http://www.sqlservercentral.com/articles/Tally+Table/72993/
--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)

October 25, 2011 at 8:04 pm

#1399395
RE: Backups and Bandwidth Dilemma

dajonx (10/21/2011)
Right now on our 100 Mbps WAN connection, it takes about six hours to transfer the full SQL backup to the backup site.
...
...
...
Does anyone have any suggestions?
Yep......
--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)

October 25, 2011 at 7:55 pm

#1399394
RE: Converting rows to columns

Sorry for the delay... there were a couple of posts ahead of you...
--Pretend that this is your dbo.ApplicationBldTypes table...
IF OBJECT_ID('TempDB..#ApplicationBldTypes','U') IS NOT NULL
...
--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)

October 25, 2011 at 7:45 pm

#1399392
RE: Set based Numbering process

I hope "RestOfData" isn't too wide for you to add an index to in both tables. Here's your original test data and a non-RBAR solution...
Declare @OriginalTable table(OT_ID int identity...
--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)

October 25, 2011 at 7:19 pm

#1399388

Viewing 15 posts - 32,146 through 32,160 (of 59,099 total)