Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,281 through 44,295 (of 59,097 total)

RE: sp_dates add this proc to your code collection

How very strange... your screen shot of my most is as I saw it when I posted it. It's the new code window with colorized code and 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)

April 9, 2009 at 7:10 pm

#975529
RE: sp_dates add this proc to your code collection

The purple "windows" that your code is in on this thread is the "old" style and it worked well especially for people to copy from. The new code style...
--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)

April 9, 2009 at 6:31 am

#974973
RE: sp_dates add this proc to your code collection

Heh... somebody please tell me how you're managing to use the old code windows... I really don't like the new ones because of the errors they currently have in them....
--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)

April 8, 2009 at 11:52 pm

#974844
RE: Timestamp to Datetime

leo4Ever (4/8/2009)
Yes, I agree with you Jeff. That's the reason I had mentioned this as a workaround rather than the best possible fix.
The final datetime value obtained from timestamp being...
--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)

April 8, 2009 at 11:45 pm

#974841
RE: Finding previous/next record based on criteria without using a cursor

I believe you've successfully converted the Cross Join to an Inner Join with the criteria so, I think this will do the same thing...
[font="Courier New"]Select t1.UserId, t2.StatusDate LogoutDate, Min(DateDiff(n, t1.StatusDate,...
--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)

April 8, 2009 at 4:43 pm

#974769
RE: sp_dates add this proc to your code collection

Florian Reischl (4/8/2009)
So here is my formatting function 😉
It's another concept than Lowell's but might also help in some cases. Keep in mind, if possible use CONVERT due to a...
--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)

April 8, 2009 at 4:37 pm

#974766
RE: sp_dates add this proc to your code collection

Lowell (4/8/2009)
Florian thanks for your function;
one format, the ISO one, is really handy for me, as I have to do a lot of that conversions;
ISO8601 (XML) ...
--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)

April 8, 2009 at 4:33 pm

#974764
RE: How to display number of rows in each table in database

Ells (4/8/2009)
I have a script that I use. Basically it loops through all the tables in a database and uses
exec sp_spaceused
This then returns
...
--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)

April 8, 2009 at 2:53 pm

#974731
RE: Timestamp to Datetime

andrewd.smith (4/8/2009)
Obviously, the actual value of the resulting datetime column is meaningless.
At the risk of rattling the rubble, that statement is 100% spot on. The original developer made a...
--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)

April 8, 2009 at 2:46 pm

#974720
RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

Ummm.... no.... to be as safe as possible with this method, you MUST include a FROM clause in the update and it must use a TabLockX and index hint 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)

April 8, 2009 at 10:27 am

#974491
RE: Just Walk Away - Blacklisting - and Twits without Twitter

Way to go, Roy! I had a similar experience where I'd interviewed person after person after person for a Sr. Developer position. They all had degrees and certs...
--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)

April 7, 2009 at 11:56 pm

#974023
RE: Are the posted questions getting worse?

Bob Hovious (4/7/2009)
... this is the kind of newbie I like to see...
He is a trophy. Stuff him and mount him on the wall. You could tell 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)

April 7, 2009 at 10:53 pm

#974009
RE: Compare Two Tables

AFIFM (4/7/2009)
Is this domain type??
No it is not. One of the legacy applications (A) uses 'Access_Level' as VARCHAR which only uses "1", "2", "3",....."8". The second application (B) uses 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)

April 7, 2009 at 10:45 pm

#974007
RE: Crosstab type report -- Horizontal Summray

Ok... here we go. I copied your very fine test data code and added the answer to it...
[font="Courier New"]--Post to SQL Server Central
--===== If the test table already exists,...
--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)

April 7, 2009 at 9:19 pm

#973976
RE: Crosstab type report -- Horizontal Summray

Maxim Picard (3/27/2009)
You can find two excellent articles from Jeff Moden on cross tabs and pivots here that should help you tackle this challenge.
Cross Tabs and Pivots, Part 1...
--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)

April 7, 2009 at 8:30 pm

#973971

Viewing 15 posts - 44,281 through 44,295 (of 59,097 total)