Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,626 through 38,640 (of 59,098 total)

RE: Missing numbers in a series

Paul White NZ (5/5/2010)
Weird huh?
Heh... it's not a fault... it's a feature. Gives folks more time to take a sip of Scotch whilst waiting for their code to run.
Thanks...
--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 5, 2010 at 2:12 pm

#1162777
RE: Finding "strings" without extensions

Ummmm.... wouldn't you just find all the names that don't have a period in them? i.e. Use CHARINDEX or NOT LIKE?
--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 4, 2010 at 4:33 pm

#1162161
RE: Inserting data into a Table with no Identity Column

Paul_Harvey (5/4/2010)
I am using a SSIS package to synchronise data between my data warehouse main tableset, and an application database.
The application database has no identity column, but the application itself...
--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 4, 2010 at 4:29 pm

#1162160
RE: table backup

ramyours2003 (5/4/2010)
how can we take table backup in a database in sql 2005 , other than export/import wizard .
can any one send the query 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 4, 2010 at 4:23 pm

#1162156
RE: How long to build index

SQLJocky (5/3/2010)
Jeff Moden (5/3/2010)
SQLJocky (5/3/2010)
Is there anything that can tell me how long it might lock down my table if I add a new index? We are running 2005...
--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 4, 2010 at 4:19 pm

#1162153
RE: Expression problem displaying rolling weekly/daily/monthly average

niccolem (5/4/2010)
Thanks a lot, I figured it out by using first/last day of month
Are you passing those as a parameter? If so, what happens if someone forgets some like...
--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 4, 2010 at 4:08 pm

#1162147
RE: very simple update statement question

Very cool of you to comeback, Henrik. Thank you much and thanks for taking the time to "repost" your 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 4, 2010 at 3:52 pm

#1162144
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Doug Bass (5/4/2010)
Another excellent article, Jeff. I liked it as much as, or better than, part one. I especially liked your usage of concatenation to generate the columns...
--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 4, 2010 at 11:54 am

#1162004
RE: Missing numbers in a series

Jeff Moden (5/4/2010)
Hey guys.... just ignore this post... I was testing our Injection Blocker for anything that contains code.
--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 4, 2010 at 10:58 am

#1161955
RE: Missing numbers in a series

Paul White NZ (5/4/2010)
Jeff Moden (5/4/2010)
Absolutely. You know me... I never turn down knowledge. Thanks, Paul.
Hey Jeff and Mr Coffee - I'm not saying a SQLCLR solution won't...
--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 4, 2010 at 10:29 am

#1161936
RE: very simple update statement question

henrik.bernhard (5/4/2010)
never mind - found a trigger to cause this issue.
In the future, please don't delete your original post just because you found a fix. Someone might be able...
--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 4, 2010 at 10:23 am

#1161930
RE: Missing numbers in a series

Paul White NZ (5/4/2010)
Hey, would anyone like to see the SQLCLR solution to this same problem? 😉
Absolutely. You know me... I never turn down knowledge. Thanks, Paul.
--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 4, 2010 at 7:01 am

#1161758
RE: Missing numbers in a series

rajesh.subramanian (5/4/2010)
Yes jeff you are right. Just started to use this forum... I have just posted what I have tried first when I read that.
I know even in our...
--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 4, 2010 at 7:00 am

#1161757
RE: Optimization: DE-Delimiting a Semi Colon Delimited List

Paul White NZ (5/3/2010)
Jeff Moden (5/3/2010)
Paul White NZ (5/3/2010)
Nine times out of ten a SQLCLR solution is faster than the Tally table and uses fewer resources:
... for string splits.
Yes 🙂
There...
--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 4, 2010 at 5:25 am

#1161707
RE: how to update a table from another table in differents db

willian.funes (5/3/2010)
Thanks Jeff,
Both database are in the same server because they are using the same system but for different little companies in a corporation, so when users add a new...
--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 4, 2010 at 5:21 am

#1161703

Viewing 15 posts - 38,626 through 38,640 (of 59,098 total)