Jeff Moden

Forum Replies Created

Viewing 15 posts - 49,681 through 49,695 (of 59,091 total)

RE: For loop in sql server

pduplessis (6/26/2008)
:DAwesome Jeff...
Thanks!
but Venki specifically asked how to do this in SSIS (call a SP from his package), which I am trying to get him to avoid.
Ummmm.... Nope... 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)

June 26, 2008 at 5:30 am

#834536
RE: eliminating duplicates

*hides from the RBAR police*
Heh.. nah... "we" see all RBAR 😛
The problem with even that solution is that the op said "no intermediate tables"... @TestCount qualifies as an...
--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 26, 2008 at 5:21 am

#834526
RE: vtable

Ah... got ya...
Nope... I don't know, at the machine language level, what the memory address of vtable in SQL Server is.
--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 26, 2008 at 5:15 am

#834524
RE: more elegant search

That worked much better... but I gotta get some shuteye... I'll take a whack at it after I get home from work tomorrow...
--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 25, 2008 at 10:23 pm

#834389
RE: Find number of weekdays(Monday,Tuesday..) between two dates yearwise

bpbhalerao (6/25/2008)
Hi All,
thanks a lot for all your help. I created one function for this which will calculate the total no. of Mondays or Tuesdays... etc.
2 way street here... would...
--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 25, 2008 at 10:21 pm

#834388
RE: more elegant search

Heh... not good. It looks like you replaced all of the commas with tabs... DTS is trying to turn it into 11 columns because of things like the second...
--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 25, 2008 at 9:52 pm

#834380
RE: For loop in sql server

venki (6/25/2008)
Hi,
Your suggestions are always welcome. No body responded for this one yesterday that's why I deleted it.
I have kept it for halfen hour and taken back. Now 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)

June 25, 2008 at 9:44 pm

#834378
RE: For loop in sql server

pduplessis (6/25/2008)
Now....
For the SSIS bit.
1) Create connectionmanager to your data
2) Create a preparation SQL task which basically deletes the data, as per the delete statement
3) Create a dataflow. OLEDB source...
--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 25, 2008 at 9:41 pm

#834377
RE: more elegant search

Aw crud... Bill, some of the rows have some commas in the actual data which pretty much screws up "easy". Could you recreate the zip file using Tab delimited...
--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 25, 2008 at 8:38 pm

#834368
RE: more elegant search

Good to see you too... and thanks for the book data in a format that I can actually load easily 😀
Do you have an example set of words that you'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)

June 25, 2008 at 6:32 pm

#834357
RE: more elegant search

How are the words being passed and do you have a wad of example book titles we can test with? See the link in my signature for the best...
--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 25, 2008 at 5:45 pm

#834348
RE: Handling hirarchy in tables

Rashmi,
How often is the hierarchy going to change?
--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 25, 2008 at 5:41 pm

#834346
RE: Exporting and Versioning Lookup Data: A Real-World Use of the CLR

We have lots of embedded tabs
That would certainly be a fly in the ointment. Thanks for the feedback.
--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 25, 2008 at 5:30 pm

#834345
RE: what date format is this?

Then what in the application is giving you the offset of either 5 or 6 hours? Could it be that all the times are assumed to be GMT 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)

June 25, 2008 at 5:23 pm

#834344
RE: display single column data into multiple clolumns

Stephanie Giovannini (6/25/2008)
Jeff, I like your schema better. Thanks for clarifying how phone numbers and addresses are ideally stored.
Heh... not sure it's the "ideal" way to do it, but 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)

June 25, 2008 at 5:16 pm

#834343

Viewing 15 posts - 49,681 through 49,695 (of 59,091 total)