Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,166 through 48,180 (of 59,102 total)

RE: Traversing through the data

Sure thing, Terry... I'd recommend solving the entire hierarchical problem and storing it in a separate table using Nested Sets. Here's a link...
http://www.codeproject.com/KB/database/nestedsets.aspx
... some folks end up converting 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 22, 2008 at 5:42 pm

#875335
RE: Can any one help me to prepare basic check list for database server for SQL server 2005.

anand (9/21/2008)
hi
my present database size is around 1-2 GB
So, take a look at the link Jason posted. 🙂
--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 22, 2008 at 5:30 pm

#875331
RE: Count the number of spaces in a field

mbookout (9/22/2008)
I was pulling information from a table that has claims that were sent to the insurance company and in this one field it lists all the procedure codes that...
--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 22, 2008 at 5:24 pm

#875328
RE: How to validated a field for special characters in SSIS?

Soorya (9/22/2008)
Problem solved. The posts were really helpful. Thanks to all those who replied
Heh... good for you, but two way street here... please tell us how you solved the 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)

September 22, 2008 at 5:22 pm

#875327
RE: store output of stored proc into temp table

Madhivanan (9/22/2008)
My reply "Yes it is" is to your reply "Heh... not exactly true..."
Actually I agreed with your reply 🙂
Heh... pretty bad misunderstanding on my part. Thanks, Madhivanan.
--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 22, 2008 at 5:15 pm

#875326
RE: Using value in a specific cell within an specific table as query criteria

You bet. Thanks for the feedback, Kelly. 🙂
--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 21, 2008 at 8:29 pm

#874767
RE: How to Select max Value for a DataType

That will certainly give you the number of bytes the datatype can or does occupy. But it will not give you the min or max values without prior knowledge...
--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 21, 2008 at 7:28 pm

#874763
RE: Using value in a specific cell within an specific table as query criteria

Ummm... ok... now I understand the latest question...
The answer is that isolation of the "cell" and using it as a criteria is done as a combination of a JOIN between...
--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 21, 2008 at 7:24 pm

#874762
RE: Using value in a specific cell within an specific table as query criteria

Ok... here it is... had to look. Copy the query I gave you and paste it into the SQL pane of the query designer. Make sure 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)

September 21, 2008 at 6:54 pm

#874760
RE: Using value in a specific cell within an specific table as query criteria

Heh... Sorry, I wouldn't know. I don't use query designer to design queries. What I gave you is the "core" of the query that you'd end up with.
--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 21, 2008 at 6:42 pm

#874758
RE: Using value in a specific cell within an specific table as query criteria

SELECT sot.*
FROM dbo.SomeOtherTable sot
INNER JOIN dbo.TheValues tv
ON sot.TheData = tv.TheData
WHERE tv.[Desc] = 'ComPeriod'
--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 21, 2008 at 6:26 pm

#874756
RE: When is a Database truly a SQL Server 2005 Database?

Being that the company you're talking about appears to be nearly ignorant of SQL in general and probably would not have used any advanced features, my suggestion would be 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)

September 21, 2008 at 6:11 pm

#874755
RE: (Cell - grand Total )

Sorry... that formula makes no more sense than the origianl post. Please see the link 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)

September 21, 2008 at 6:02 pm

#874753
RE: Not using Index

psangeetha (9/19/2008)
Sorry, that was a typo.
select * from sales where (sales_id = 1123013 AND sales_in_no >= 199901 AND sales_in_no <= 199701)
This is the output I get from the execution...
--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 21, 2008 at 5:54 pm

#874752
RE: Combining Rows into single one

Yes... please see the following link which is a bit of a "how to" along with some things to avoid when doing this type of concatenation.
--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 21, 2008 at 5:51 pm

#874751

Viewing 15 posts - 48,166 through 48,180 (of 59,102 total)