Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,226 through 48,240 (of 59,102 total)

RE: Count the number of spaces in a field

mbookout (9/16/2008)
Hi!
I have a table that has a Procedures field which includes several numbers separated by a space (i.e. 99202 10060 99000 A6402). I need to count the number...
--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)

September 19, 2008 at 8:01 pm

#874524
RE: How to Identify in how many Storedprocedures hasa sp been called?

Chirag (9/18/2008)
another way is to right click on the proc in SSMS and select view dependencies. It will show all objects that depend on the proc and also all...
--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)

September 19, 2008 at 7:43 pm

#874522
RE: Table locked while Bulk Insert in sql sever 2005

Grant Fritchey (8/1/2008)
Ooh. I hadn't thought of that.
It wouldn't show up as a database lock though, would it?
No... in fact, it wouldn't show up as anything because you simply can'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)

September 19, 2008 at 7:22 pm

#874520
RE: MSSQL 2005/T-SQL Query/CTE: How to identify BACKWARD/FORWARD Hierarchies at the same time

It's important... how often will the hierarchy be made 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)

September 19, 2008 at 7:18 pm

#874519
RE: Does OPENROWSET using BULK preserve the original file's order?

Jason,
I have to ask... what's in these files where the order they are loaded in is important?
--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)

September 19, 2008 at 7:15 pm

#874518
RE: Columns...

Step 1. Throw the original query as far away as possible.
Step 2. Read the following article.
http://www.sqlservercentral.com/articles/T-SQL/63681/
--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)

September 19, 2008 at 7:09 pm

#874516
RE: Traversing through the data

Unless the hierarchy changes every minute or two, there's no sense in recalculating the same thing over and over and over...
I gotta say this first... you need to take the...
--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)

September 19, 2008 at 7:03 pm

#874514
RE: Building a Hierarchical dataobject (with properties) from one or more datasets

I've not written any non-TSQL in quite a bit... however, when I did, I wasn't opposed to using someone else's example to get the job done. Take a look...
--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)

September 19, 2008 at 5:24 pm

#874506
RE: File System Task

Ummm... will that create the sub-directory if it doesn't already exist?
--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)

September 19, 2008 at 5:11 pm

#874504
RE: Automatically Generated Numbers

Heh... just reverse the IDENTITY number...
--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)

September 19, 2008 at 5:09 pm

#874503
RE: Query with a column of concatenated values

lduvall (9/19/2008)
I figured it out on my own! In fact, I used the article Matt posted...
That's good feedback... thanks. I always wonder if articles like that help folks. 😀
--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)

September 19, 2008 at 5:08 pm

#874502
RE: Query with a column of concatenated values

tbeadle (9/11/2008)
Hello,
Concatenating strings is no problem but you may have to get a bit creative to avoid the limitations on text lenghts.
Look at the spec difference between varchar's...
--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)

September 19, 2008 at 5:04 pm

#874501
RE: Cleaning city name

Search for "CASS CERTIFICATION" software... it does the whole thing from womb-to-tomb and provides updates as new address information comes available from the US Postal Service. I believe "ZP4"...
--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)

September 19, 2008 at 5:02 pm

#874500
RE: Group by Date....

b_boy (9/19/2008)
sorry guys but my own syntax worked perfect for me, tried yours but got incorrect results....
If you used a conversion to group by date, then you probably did 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)

September 19, 2008 at 4:56 pm

#874499
RE: Organizations With No DBAs

arbarnhart (9/19/2008)
Jeff Moden (9/19/2008)
p.s. I also want to say that when I say "developers", I'm talking about the greater populous... there are some individual developers that I'm NOT including...
--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)

September 19, 2008 at 8:56 am

#874289

Viewing 15 posts - 48,226 through 48,240 (of 59,102 total)