Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,171 through 40,185 (of 59,098 total)

RE: How to read list of files in folder using T-SQL?

Yes...
The first "1" controls how many "levels" to go down from the directory listed in quotes with the directory listed in the quotes being "Level 1". In other words,...
--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)

January 21, 2010 at 11:48 pm

#1107119
RE: passing out put of one sql statement into another as a input and looping using cursor

Heh... after two days, I wonder if it's still "urgent". :hehe:
--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)

January 21, 2010 at 11:43 pm

#1107117
RE: Split the month as weeks

KpSQL123 (1/21/2010)
Hi,
Can some one please let me know how to split the month as weeks. Let's take January has 6 months
1-2 as 1st week
3-9 as 2nd week
10-16 as 3rd week
17-23...
--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)

January 21, 2010 at 11:41 pm

#1107116
RE: select comma Separated values

Here are a couple of more suggestions along with some caveats to watch out for.
http://www.sqlservercentral.com/articles/Test+Data/61572/
--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)

January 21, 2010 at 11:35 pm

#1107115
RE: Mishi Kobe Niku

What? No pork chops? :hehe:
--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)

January 21, 2010 at 11:27 pm

#1107114
RE: Update with rowcount

This is one of the very few places where I'd condone the use of a Trigger. Read about triggers in Books Online.
--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)

January 21, 2010 at 11:26 pm

#1107112
RE: Date Calculation

Anitha,
You're probably not getting the help you need just because of the way you posted the data. Take a look at the first link in my signature below to...
--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)

January 21, 2010 at 11:15 pm

#1107108
RE: Syntax Help PLEASE

I'm not sure that you need the ISNULL, Lowell... if "0" isn't a value in the table, NULL will give the same result as "0" because NULL isn't even equal...
--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)

January 21, 2010 at 11:12 pm

#1107107
RE: Need help using While

Sharul Nizam (1/21/2010)
My table and row as follow,
My hat's off to you, Sharul... you really made it easy for folks to help you with the way you posted. 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)

January 21, 2010 at 11:08 pm

#1107103
RE: Need help using While

lmu92 (1/21/2010)
Why not using a solution that doesn't use any while loops at all and do it all in one path?
Well done, Lutz!
--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)

January 21, 2010 at 11:06 pm

#1107102
RE: Mistake or #Fail

Excellent pod cast and excellent points. To coin a phrase, "Invest in yourself or people will invest in others." 🙂
--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)

January 21, 2010 at 10:56 pm

#1107099
RE: Integer bigger than bigint?

Stephen Fry (1/21/2010)
@mister.magoo:
Thanks for the effort, much appreciated!
What you have though is precisely my point...while I agree that it's not overly complicated, it's certainly "more" complicated, and i would think...
--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)

January 21, 2010 at 10:46 pm

#1107096
RE: Integer bigger than bigint?

Revenant (1/21/2010)
Bitwise operators can operate on varbinary as the left operand; only the mask ( the right operand) has to be one of the integer types. To quote SQLS...
--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)

January 21, 2010 at 10:35 pm

#1107091
RE: How to read list of files in folder using T-SQL?

Without xp_CmdShell...
EXEC Master.dbo.xp_DirTree 'yourpathhere',1,1
You can use INSERT/EXEC to capture the info in a table if you prebuild the table.
--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)

January 21, 2010 at 10:33 pm

#1107090
RE: HUGE Database Update (> 550 million rows)

Actually, a Cursor or While Loop is just what the doctor ordered here...
Every system has a "tipping" point where it just loses it's mind during an update. A million...
--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)

January 21, 2010 at 10:31 pm

#1107089

Viewing 15 posts - 40,171 through 40,185 (of 59,098 total)