Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,611 through 23,625 (of 59,099 total)

RE: Importing improperly formatted excel file

@watchgeek,
I see that you've already pounded out a solution. It does't appear that this spreadsheet has any proprietary or private information in it. Would it be possible for...
--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 21, 2014 at 7:11 pm

#1715544
RE: Building a self-referencing hierarchical table.

Not a problem there. Those columns would only exist long enough to build the Adjacency List which would use surrogate IDs to map the "positions" in the Adjacency List....
--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 21, 2014 at 6:57 pm

#1715543
RE: What are you worth?

I have a friend from NY City and his saying is "The squeaky wheel gets greased". 😉 Heh... "Thing aboud 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)

May 21, 2014 at 6:48 pm

#1715540
RE: Building a self-referencing hierarchical table.

shannonjk (5/21/2014)
Thank you for the articles Luis, most informative! I also now know what I am looking for and referencing 🙂
Jeff, after reading your articles, I understand now what 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 21, 2014 at 6:41 pm

#1715538
RE: SQL exam question

rara007 (5/21/2014)
No its from a conversion course. Sorry I missed a lot so trying to catch up for the exam.
So how did you get a copy of this exam...
--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 21, 2014 at 6:35 pm

#1715537
RE: table manupulation sql ssis

With the data in the non-usable format that it is, try "ROLLUP". If you'd like a coded example, please see the first link under "Helpful Links" in my signature...
--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 21, 2014 at 5:54 pm

#1715533
RE: Return parent record of child record

gautham.gn (5/21/2014)
I need a help regarding this...
There is a table like this
PK Desc Reference_PK
---------------
1GauthamNULL
2HarshaNULL
3Kamal1
4Sai2
5Rajesh2
6Pradeep1
I want a select statement to display like...
1>...
--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 21, 2014 at 5:50 pm

#1715532
RE: Linked AS400 stopped working

John Cooper (5/21/2014)
Did you ever find a working solution for this? I am having the same issue 🙁
Read two posts above yours. Try that to see if 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)

May 21, 2014 at 5:47 pm

#1715531
RE: Building a self-referencing hierarchical table.

Do you want just a voluminous test table of randomized nodes? If so, the articles that Luis poinnted you to have just such a generator.
If you want something 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)

May 21, 2014 at 5:26 pm

#1715529
RE: No "GO" allowed in Execute

It won't be just "one" to create the objects. If the objects are procs, views, functions, and the like, you'll need one EXEC for each object.
--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 21, 2014 at 3:21 pm

#1715505
RE: Sudden CPU % Jump to 100% Usage

Matt Crowley (5/21/2014)
On the first point, I certainly agree. I am beginning to hate applications based on Java for this reason (among several others).
I've learned that I can save...
--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 21, 2014 at 3:17 pm

#1715503
RE: Recursive CTE? Not Sure How To Do This...

autoexcrement (5/21/2014)
Thanks to everyone who has replied already. A better group of fellas I couldn't possibly ask for.
@Eirikur: Thank you again for all your work on this solution! 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 21, 2014 at 3:05 pm

#1715498
RE: No "GO" allowed in Execute

To amplify Jason's post above, the GO "command" isn't actually a command. It's a batch separator for SSMS and is not a part of T-SQL, which is why you...
--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 21, 2014 at 2:39 pm

#1715491
RE: Saving Password in SSIS Configurations

Koen Verbeeck (5/20/2014)
Jeff Moden (5/20/2014)
greeshatu (5/19/2014)
Please let me know how to store password permanently in configurations
I'll be the first to admit that I don't know much about SSIS but my...
--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 21, 2014 at 12:19 am

#1715226
RE: Recursive CTE? Not Sure How To Do This...

The Quirky Update will do this on a million row table in scant seconds but, because it's not supported and there's quite a bit of FUD in the eyes of...
--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, 2014 at 11:47 pm

#1715221

Viewing 15 posts - 23,611 through 23,625 (of 59,099 total)