Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,511 through 39,525 (of 59,098 total)

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
RE: Off topic: Images in the forums

J M-314995 (3/5/2010)
I'm not one that has ever had the need to post any sort of picture/image online. From time to time, I think it would be really helpful...
--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:40 pm

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

Garadin (3/5/2010)
Debbie Edwards (3/5/2010)
Its quite exciting to find out about a new bit of SQL 😀
Debbie
I'd agree with that completely. Had some fun playing with "GROUPING SETS" this morning...
--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:34 pm

#1129516
RE: horizontal vs vertical table structure

chidev (3/4/2010)
The fields will be id - year - revenue - net income - income tax - earnings before tax - etc
If it's truely and only for historical lookups 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 5:55 am

#1129102
RE: CLR, to be or not to be, that is the question!

Roust_m (3/3/2010)
I've posted it already: Post #876546
I saw that and didn't see the function being used in the code and figured it was an incomplete listing. I don't see...
--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 4, 2010 at 10:01 pm

#1128946

Viewing 15 posts - 39,511 through 39,525 (of 59,098 total)