Jeff Moden

Forum Replies Created

Viewing 15 posts - 54,496 through 54,510 (of 59,072 total)

RE: simplifying code

Not sure what you're trying to do, but here's a different angle... think of it as a "set-based IF" 😀
SELECT TOP 1
CASE...
--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)

October 20, 2007 at 5:50 pm

#743881
RE: Date Display issue on frontend

GUI code (Like VB, etc) and SQL have different base dates and one may not have recognized the year 2000 as a leap year.
--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)

October 20, 2007 at 4:35 pm

#743880
RE: Nineteen Eighty Mom

I agree... way to much "big brother" already...
Shoot, I'm still ticked off about having Fluoride, ABS, airbags, seatbelts, lid laws, the fact that my truck records the last 5...
--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)

October 20, 2007 at 4:09 pm

#743879
RE: 10/22

Although I got the answer right, it's kind of misleading... if the value of a column has been updated to the same value (usually do to bad GUI code), do...
--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)

October 20, 2007 at 3:29 pm

#743877
RE: returning balance value on TSQL

First of all... I'm not going to solve all your problems with all your temp tables, etc, etc... You've already done most of that. My purpose here is just...
--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)

October 20, 2007 at 3:22 pm

#743876
RE: Case Statement

This is a classic "Name/Value" table that you have where both the name of the attribute and the value of the attribute are contained in rows instead of having separate...
--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)

October 20, 2007 at 1:12 pm

#743874
RE: Can You Give Me Tips To Creating Test Data

Here's a way to make lots of constrained test data of many types... so far as not making "too many" rows, I agree, partially... when you are experimenting to make...
--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)

October 20, 2007 at 9:16 am

#743861
RE: returning balance value on TSQL

luissantos (10/19/2007)
I hold many lines because i want to return for each u_subconta (account of Customer) all the movment of this account.But i thinks that is not the problem.
My 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)

October 20, 2007 at 8:43 am

#743857
RE: Grouping not Grouping

Heh... I thought the same thing... but there's two columns that look very much alike...
Committed_Fund_ID
Committed_Fund_Item_ID
I don't see the Committed_Fund_Item_ID being used in the problem GROUP BY query... 'course, the formatting...
--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)

October 20, 2007 at 8:35 am

#743856
RE: System Performance - High CPU utilization--> SQLSRV.exe

Heh... yeah... I forgot about that. Well said...
--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)

October 20, 2007 at 8:28 am

#743855
RE: Designing Cross Database Queries

Not sure I agee about linked servers always being slower... I've found that it depends on the number of hops it has to make... I've got several linked servers at...
--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)

October 20, 2007 at 8:25 am

#743854
RE: how to remove numbers from strings?

Heh... I'm thinking you missed a great "tool box" opportunity with the DBA... not a problem... thanks for the feedback.
--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)

October 20, 2007 at 8:15 am

#743853
RE: Designing Cross Database Queries

That so wierd
Umm... using passthrough "synonym" views to perform the crosstalk between databases without using the full 3 part naming convention was the whole purpose of the article... what's wierd...
--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)

October 20, 2007 at 12:37 am

#743843
RE: how to remove numbers from strings?

You didn't wait long enough
Couple of us didn't... I missed that... sorry. :ermm:
--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)

October 20, 2007 at 12:29 am

#743841
RE: how to remove numbers from strings?

vadimt (10/18/2007)
the first solution didnt work. because of the Tally i didnt implement.
i dont need it as a function because i need it only in one place in the whole...
--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)

October 20, 2007 at 12:19 am

#743840

Viewing 15 posts - 54,496 through 54,510 (of 59,072 total)