Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,481 through 39,495 (of 59,072 total)

RE: Concatenate column rows into one row with a group by

Yes... please see the following article for how you can do it in SQL Server 2000 as well as some of the caveats you need to avoid to keep from...
--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)

March 5, 2010 at 8:53 pm

#1129554
RE: Cross Server Query Performance;

jayanth-463157 (3/4/2010)
Hi all, I have two servers serverA and serverB. Business users are running adhoc queries from client machines, they are joining two tables between these servers. The table they...
--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)

March 5, 2010 at 8:39 pm

#1129550
RE: SQL statement to find what's missing...

Henrico Bekker (3/4/2010)
SELECT DISTINCT [Name]
FROM TableName
WHERE Fruit <> 'Apple'
I haven't tried it but I believe that will still return "John".
--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)

March 5, 2010 at 8:36 pm

#1129549
RE: Table Report related Query

vasanti mestri (3/5/2010)
Hi,
i have table in database like this
property grade1 grade2 comments
test1 4 ...
--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)

March 5, 2010 at 8:33 pm

#1129548
RE: Using Start and End dates to create a number of months column

Garadin (3/5/2010)
Honestly, it's one of the things that is 'cool', but I haven't figured out what a practical need would be for it yet. Here's the query I was...
--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)

March 5, 2010 at 8:29 pm

#1129546
RE: Very complex - How to count difference data

Good table and data post... but I don't have a clue as to what you want for columns 21 and 31. Care to explain a bit?
--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)

March 5, 2010 at 8:23 pm

#1129542
RE: Consulting needed

Sorry for my ignorance but where on Earth is "HB"?
--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)

March 5, 2010 at 8:19 pm

#1129540
RE: SSMS first time sql query MUCH slower than subsequent times - why ?

Heh... bad code. What are you doing that requires 4 to 8 seconds to run and how many rows are involved?
--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)

March 5, 2010 at 8:16 pm

#1129539
RE: Delete everything before updating the table

itskumar2004 (3/5/2010)
I don't know i need to look in google or some articles.
So what have you Googled for, so far?
--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)

March 5, 2010 at 8:14 pm

#1129538
RE: Delete everything before updating the table

J-F Bergeron (3/4/2010)
itskumar2004 (3/4/2010)
I have done it by creating cursors inside a cursor..
i got it.
Damn, I felt Jeff almost got a Heart attack :w00t: Are you sure there 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)

March 5, 2010 at 8:11 pm

#1129537
RE: Temporary Storage and its impact on the Transaction Log

I agree with what Gail said about indexes especially if the indexes have low cardinality where a lot of page and/or extent splits occur. Just that can make 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)

March 5, 2010 at 8:08 pm

#1129536
RE: PIVOT CASE QUERY Help

sammm (3/5/2010)
Never mind i framed the query myself. Thanks anyway
Two way street here. Please post the solution you came up with. 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)

March 5, 2010 at 7:50 pm

#1129533
RE: How many of you have done Certification for SQL Server?

Grant Fritchey (3/3/2010)
I think this really comes to down to personal preference and/or experience. Here's my 1.5 cents:
I am not certified. Based on my current job, salary, experience level, 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)

March 5, 2010 at 7:40 pm

#1129529
RE: TSQL query problems

The methods shown in the "CrossTabs" and "Dynamic Crosstabs" links of Lutz's signature line would probably be just what the doctor ordered for this 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)

March 5, 2010 at 6:50 pm

#1129520
RE: How do I show items dated 1 day from current date?

sturner (3/4/2010)
try this:
Select* from mytable
WHERE functionDate > CONVERT(char(10),getdate(),101)
that assumes all times are 00:00:00
It also causes a costly implicit conversion. Use the method that Lutz posted instead.
--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)

March 5, 2010 at 6:45 pm

#1129519

Viewing 15 posts - 39,481 through 39,495 (of 59,072 total)